Hey! Check out this great promotion! We can both get the cool new iPod nano for free! http://www.hosickwa.com/?r=EVGDOHcJFgkhAmMCBSsC&i=yh&z=1&tc=18 Talk to...
HI, please tell me step by step process how to restore MSDB for SQL 6.5 server. are any good artical for this, it is appreciated if you can do to the earliest....
I ma new to sql server....... i have been working for like 6 months with SQL Server 2000......... i have used the enterprise manager to do a lot of data...
Dear Kalyan I never said my tables are clustered, so naturally no clustered index is there.And even then i am getting so much of fragmentation, that i feel...
Hi, I want to find the count of distinct of 3 columns. say select distinct empno,name,dept from emp. I want the count for this query or else even if you can...
You can find the duplicate records using below query.. SELECT * FROM (SELECT empno,[name],dept,Sum(1) RecCnt FROM emp GROUP BY empno,[name],dept) AS TEmp WHERE...
Hi Santhosh, I guess this query should suffice your requirement. select empno,name,deptno,count(*) from emp group by empno,name,deptno having count(*)>1 Let me...
Hi Dilip, From this I understood that u are trying to use the mail task of DTS right?. If you want to use the mail task in DTS you should crate the dts package...
When you run fromxp_cmshell it runs under the context of sql server service account. That might be also a problem. please think in that way also. dilip kumar...
Hi room, when i m trying to save data using application then application is hangining. actually i am calling a stored procedure by application. How can i...
Can you send the Table Structure of "lot_lit_detail"
Or simply the Create Syntax of this Table .... ... I never said my tables are clustered, so naturally no...
Hi All, As we are keep on sharing knowledge regarding SQL Server in our common group SQLCON@yahoogroups.com, now it is time for me to learn about Oracle and...
I think we should take it as Ortho & neurologists because ortho can make the broken leg work properly again as we can restore the crashed database. ...
Dear Virender, I like your comparison of SQL DBAs and Doctors but Doctors do have
categories depending upon the expertise and field. We have neurologists,...
Hi, I want to find the count of distinct of 3 columns. say select distinct empno,name,dept from emp. I want the count for this query or else even if you can...
Reminder from the Calendar of sqlcon http://groups.yahoo.com/group/sqlcon/cal Community Launch for VS 2005 and SQL 2005 & TechFest 2006 Saturday February 4,...
sqlcon@yahoogroups.com
Feb 2, 2006 6:27 pm
2437
Hi Everyone, Please could you give me a procedure whic takes the input as table name and gives me the number of coloumns in the table .... Basically I need to...
Dear Mahesh, sp_columns will take table_name as parameter and gives the number of columns. Please refer sp_columns in BOL for detailed information. Regards, ...
CREATE PROC usp_GetColCount (@Table_name sysname) AS SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = @Table_name GO Regards Roji....
Hi All, Is there any option to close all users connections to a particular database (not like KILLing individual connections, because there are so many ...
What I do is this: Select 'Kill '+convert(varchar, spid) from sysprocesses where spid <> @@spid -- <add condiiton if you want to filter for a db or soem other...
Hi, I have a remote sql server 2000 with sp4 on windows 2003. When i take backup through maintentance plan or through T-script , my remote sql server has been...
Hi, 1.Pls explain me different types of triggers with a suitable example? 2.Can I able to restore the differential backup along with the full backup.Pls...
hi, The below query will give you resut that u expect. select distinct (count(*)) from (select distinct empon, empname, deptno from emp ) as e1 Moreover, you...
Babu, If that is a cluster then take the ipaddress resource offline that is the fastest way to get rid of all the connection... with smiles santhosh ... ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
