The file is 228GB and cant be copied locally

Thanks

Hi All

I agree that you can run into problems when using cursors without thought

However I have an instance where I have to gather information from a 3.2 billion row partioned...

so you cant turn off the auto generated ones?

You dont know how to turn them off

The ssms toolpack seems to get overridden by thes plus/minuses

I want to create regions over more than BEGIN END BLOCKS

Thanks All

All useful stuff 🙂

Thanks

Hi guys

Have let this slide onto the back burner. But It has now been resolved. The stats on the MSReplication_subscriptions

table were out of wack. There were 7 records...

Figured it out. If you remove all target servers MSX Master is removed

I used sp_delete_targetserver

We use redgate on most of our servers. For whatever reason this server did not have it installed

I instaled it yesterday and tried to do a backup but it gave...

This is in the error log:

Unknown,The operating system returned error 1450(Insufficient system resources exist to complete the requested service.) to SQL Server during a write at offset 0x000021fd852200 in file...

Its not you, Its definately above mine

Ive had a look , theres no blocking but the spid is suspended with a wait type of ASYNC_IO_COMPLETION

on the top row,BACKUPBUFFER in the...

Create #temp(id int,colums...)

insert into #temp(1 as id,....)

exec server1.dbname.db.proc

insert into #temp(2 as id.....)

exec server2.dbname.db.proc

you will have all the data in a table and you can then compare

You must declare the transaction within the try

BEGIN TRY

Begin Transaction

DELETE FROM #TABLE1 WHERE customerid = @customerid

DELETE FROM #TABLE2 WHERE customerid = @customerid

DELETE FROM #TABLE3 WHERE customerid = @customerid

Commit transaction

END TRY

BEGIN...

AND Sessions LIKE '%'+char(37)+'%'