You can use xp_cmdshell to run dtsrun, but perhaps it would be better to add a record to a control table, and have a scheduled task watching that table and...

Maybe you need to look at the security on the server, and see who really needs dbo level access or above.

If you can restrict who can do this, it should...

The only thing I remember I had a couple of sp's which did not work on 2000. This was where the developer had coded 'int(4)' into there declare statements. Changing...

Have you tried leaving profiler running over night to see if any sql is being fired at the server?

I've had this one before as well.

I seem to remember changing the enviroment variables for tmp and temp (as Susan says above)

Do you have a backup device called MyNwind_1 created which points to your backup file.

If not use FROM DISK = <path\filename> instead of MuNwind_1

eg

FROM DISK = 'c:\track_db_200309010100.BAK'

There are a number of solution for file growth from setting up a sql agent alert to

coding checks.

Take a look at http://www.sqlservercentral.com/scripts/contributions/108.asp

Is it the data portion that grows, or the log file?

If it is the log file, index defrags etc hit the log file quite hard.

Does the file 'J:\MSSQL\Data\Equifax_Data.MDF' exist

you can test this with

xp_cmdshell 'dir 'J:\MSSQL\Data\Equifax_Data.MDF'

I was a Powerhouse 4GL developer (Cognos) on Digital VMS and HP-UX boxes

And prior to that when to Uni and got an Hons degree in computing with 'Database Management' and...

Thomas,

I take it that you are not a Leeds fan then.

(and since pets are being added to the family list, I've also got a dog (a bordie collie)

This link should solve your problem

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281517

If the backup is too big, or if it is just data (not schema) you want to move. You could use DTS (or the Export Wizard) to export each table...

It would be easier if you can identify the modified records in Oracle. If you can you could use a select statement to bring the data across.

Sometimes other programs grab port 1433 before sql server starts.

If after running Brian's command you find port 1433 is used you will need to find the application, and make it...