Try just doing execute permissions.

Andy

Its easier that way of course! You can either do 'Save As' to a file, then copy the file to the other server (via disk or whatever), or save it...

The easiest way is to use DTSRun in a job, then have the stored procedure start the job.

Andy

See if this will help:

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

Andy

Try writing the info out to a table instead.

Andy

Or here, without leaving the site!

http://www.sqlservercentral.com/columnists/bknight/sp_msforeachdb.asp

Andy

Fair point!

Andy

Think you have to put it back in standby.

Andy

With SQL2K you can, take a look at full text index - think you have to have a column that includes the document extension for it to search anything besides...

If you have access to the file you can do it.

Andy

Try this:

RESTORE DATABASE MyNwind

WITH RECOVERY

Andy

Before you try changing a lot of stuff, you really really want to get a network engineer to monitor the situation when the timeout is occurring. Just checking stats from...

Its undocumented, but this article by Brian should get you going:

http://www.sqlservercentral.com/columnists/bknight/sp_msforeachdb.asp

It will work, but I like Steve's suggestion of the view better.

Andy

I think you're confusing the identity function with the identity property used in table creation.

Andy

I dont think so. You have to set it at a session level, no way to temporily disable it for all users. So when you set it you'd keep track...