Hi,

Can you please share the compatible code for SQL 2K8 R2.

because, this script not working.

Thanks

Thanks for Reply,

My Question is how to find the Actual Row Count and where it will show me the acutal row count likewise Estimated Row Count in the Execution...

Declare @table1 as Table(cID bigint,Uid bigint)

insert into @table1 select 23,40

insert into @table1 select 20,50

insert into @table1 select 23,60

declare @groupid1 nvarchar(10)

set @groupid1 = '40,50'

declare @t1 as table (uid1 bigint)

insert...

Could you please tell me what is CU and where I can read the issue list.

Is there any why I can find the list of issues been fixed on SP3..

Thanks

There is no SSIS and SSRS in the system

Any Help in this ? ..:-)

Thanks for the reply and find the below info.

SQL Serve Edition - SQL Server 2005 Enterprise Edition, SP2

OS - Windows Server 2003 R2 (Standard Edition) , SP2

Physical Memory -...

Thanks to everyone for give me the best approach.

However, I would like to follow the practice while will delete the records in the loop..

by incrementing 10000 records at each loop...

Okay, I agree with your point - If I start all the activity at the same time for sure server will get into hung stage.

Intension of this requirement is to...

There are more than 150 Jobs are running, this is painfull task to copy the each jobs and pasting at the destination servers.

I am using SQL Servef 2005 64 Bit...

http://mohanraj-jayaraman.spaces.live.com/blog/cns!EACF5D65BF47EF1E!287.entry

when I try that by using sqlservr -c -m -f i am getting below error.

2008-09-19 14:45:53.82 Server Error: 17058, Severity: 16, State: 1.

2008-09-19 14:45:53.82 Server...

17 GB free space available

Scott Duncan,

Its really fine & worked for me, but I am little bit confused with Step 7.

For Eg: Master db restore

Alter Database master modify file (name = master, filename...

Okay, Thanks

Regards,

Mohanraj Jayaraman