Did you try enclosing the dbname in square brackets?

ie exec sp_msforeachdb "use [?]; select * from sysobjects"

Create yourself a proc in the master database that will run the following...

CREATE PROCEDURE SP_PULL_SQL_PERMISSIONS

AS

create table #protectinformation (UID int identity(1,1), Owner VARCHAR(25), object VARCHAR(200), grantee VARCHAR(75), grantor...

You could copy it from another install of SQL.

Look at DTSRUN in Books Online, specifically look at the /A switch, it allows you to pass global variables in.

I have the same troubles with Remedy. Changing the views doesn't really help a whole bunch, and as we have a lot of large tables we get occassional blocking issues....

I've experienced the same problem with DTS packages and the global variables in the past (2K EE, SP3a, 8.00.818). I have no idea what causes it.

You could run SET ARITHABORT ON before executing the statement. It's best to change it serverwide however as otherwise you will have to manually set this for every object that...

Check the SQL connection settings. To run an insert/update/delete on the table ArithAbort must be set to ON. By default I believe that this is set to off, to change...

The two getdate() thing might be a bug. Create 2 global variables, populate them with the two halves of the query and use them both in the vbscript DTSGlobalVariables("part1").Value &...

Make sure that the job owner is SA, then try again.

If you right click on the job and View Job History, check the Show Step Details box you get no...

What's the error that you're getting in the agent?

You need to set some startup parameters before the move....check out http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

You do pretty much the same thing as before, create the global variable, populate it, and then assign that variable to the location of the file. I am running a...

Would you not want to create the second select using Inserted rather than Survery as the first condition in the join?

Because you are trying to perform a calculation on the result of the convert it turns it into an int datatype, you need to encapsulate within another convert statement thus:

Select...