is there any way to create temp table and then see?

without sum , it is retruning 4416709 rows

here are script for table & now let me know?

CREATE TABLE [dbo].[Store](

[Id] [uniqueidentifier] NOT NULL ,

[IncomingType] [varchar](20) NOT NULL,

[ConfirmationId] [varchar](20) NOT NULL,

[CreationDate] [datetime] NOT NULL ,

[StoreId] [int] NOT NULL,

[CustomerNumber] [varchar](20)...

It is in store table & both tables having clustered index.

I want to do further processing on this table that is too by another cursor.

this query is useful.

please send alert t-sql too?

give read-only access to msdb of sql 2000 and then tell user to connect using ssms 2005

use the below script

_________________________________________________

Dim fso,fol,fx

set fso = CreateObject("Scripting.FileSystemObject")

Set fol = fso.GetFolder("F:\BACKUPS\")

For each fx in fol.Files

if datediff("d",fx.DateLastModified,now()) > 7 and right (fx.path,4) =".bak" then

fso.DeleteFile fx.Path

End if

next

set fso=nothing

____________________________________________________

goto- job - newstep --...

no but this will take a lot of time

dude ,

re-configure replication pointing to new distribution db server

instead of that drop and re-create indexes. schedule this as sql agent jobs

refer this

http://www.scriptsahead.com/sql-server/t-sql/t-sql-script-to-divide-one-column-data-into-two-columns

I never attempted such case but I feel you have to reconfigure log shipping.

I will suggest do a small test on sample db and then see.

Post your results.

u can contact...

hmmmm...

" Not in " will take more time.

job will run as it is.

post your performance improvement results