You don't need to enable AWE on a 64-bit server. That feature is for a 32-bit machine, to allow it to address the excess memory (if any) installed on the...

Glad the tool was useful.

Hi barb.wendling

Do you have SQL Server Management studio installed on your machine?

I am using SMO in this app. SMO relies on .NET Framework 2.0 and SQL Native Client....

wow... havn't any body come across a similar situation?? :crying:

you can save the DTS packages as a .vbs file.

for the jobs, i had to create a small vb.net console app to do it.

available at http://shivaramchalla.googlepages.com/ProjConsoleJobScripter.htm

ConsoleJobScripter.exe...

Try running a profiler on this object and see how often and who is calling this sproc.

that will give u insight into how its being used and why. and you...

ssis = SQL Server integration services, available in SQL Server 2005.

this wouldnt help you for msde.

This is the method I use in situations I cant use SSIS or any...

sp_delete_backuphistory deletes the history in the systables but doesnt the physical files.

you have to use maintenance plan (ssis provides an option to delete old back up files).

Other wise,...

I am having the same issue with a sproc.

I cant drop/modify a sproc

this sproc is inserting a remote data set (using an oracle linked server) into a local...