Both ideas worked thanks very much for your help.

Thanks everyone I resolved the issue of the dts not working when scheduled as a job. It was discovered that the system path on the server to the dts...

I was able to reindex two of my larger tables using dbcc reindex tablename, this weekend I will run the dbcc reindex table in batches to test to see how...

Since I have a limited amount of space would you suggest reindexing a table, doing a shrinkfile, and then reindexing another table, and shrinking again?

Thanks,

Catherine

Phillip,

When I executer EXEC dbo.usp_CaptureActivity from the query analyzer it works fine.  When I run it as a job with sa as the owner I get an error.

Question2

I was looking...

sa is already listed as the owner.

sa is the owner.

Hi

I got over the linked server error.   server name stageserver, linked server stageserver1, database name production.  I replaced the 3 database names in the script to production and the server...

I tried the script capture_spwhoScript. I added my database to the script, I tried creating my server as a linked server and I received an error. You cannot create a local...

what will this select statement do?

select

 objectproperty(object_id('sysprocesses'),'Tableisfake')