this is the delete code which loops through 10 tables for deleting duplicates.

set @sql = 'delete C

From ' + @PhiscalDB + '.dbo.RevCode' + @Phiscalyr + ' As C

Inner Join '...

Here is the script for my linked server

EXEC master.dbo.sp_addlinkedserver @server = N'DevSQL', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DevSQL',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO

EXEC master.dbo.sp_serveroption @server=N'DevSQL', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'DevSQL', @optname=N'data access', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'DevSQL', @optname=N'dist', @optvalue=N'false'

GO

EXEC...

Hey i have some clue for my problem. whats happening is

When I RDP from the computer C and query from SErver A to SErver B then i get this...

11 million is not on top of 12 million, last week was 12 and now its just 11 million. I do not have any type of indexes on any tables.

thanks

All logins are windows authenticaed.

when i checked on both servers it gave me

net_transport auth_scheme

-------------...

I have the same error but when i check on both servers it gave me

net_transport ...

1 thing to mention here. Server A (standard) is in mised mode (sql and windows authentication and serverB(enterprise) is in windows authentication mode.

is there anything i am missing when creating...

trying to query from SErver A to SErver B through a group Developers. SErver A is 2005 standard edition and Server B is enterprise. when i check i linked server...

above query pulls 20k records in 24min, i thing its not gud though my indexes are all doing good.

what if i had a detacched database?

I dont see naym esg from the error logs but if some one shed light on my doubt tht wud be gr8.

In general what wud be the reason behind the...

how do i check that and what do i need look for into it?

every time i restart the server some of the db's are in recovery state. it happened in another server too. what shud i do.

2008-12-03 15:06:48.15 spid41s ...

I just recovereed the huge DB after 4hrs and after that we reboot the server but after rebooting again that DB went into ( In Recovery) mode, why is that?...

Last night i had set up my jobs to rebuild indexex on the some db's, now the problem is only with those db's. once i restart the sql server all...