1. In general, you can't update system tables.  According to BOL, they may be accessed under certain circumstances using a "Dedicated Administrator Connection", but it's not recommended.  See "Using a...

Oh, now I see what you're talking about.  I do have the same problem as long as the DTS Designer is open.  I've now idea how to get around that,...

I want to echo bledu's question and also ask if the user could ever login to the SQL 2000 instance.  If no, make sure his login has been added and...

You can create the stored procedure in master if you qualify sysprocesses and sysdatabases with the schema sys.  They are system views in SQL 2005 rather than system tables i.e....

Personally, I wouldn't attempt to restore a backup of master on a new instance.  I'd just install the named instance, restore backups of the user databases and recreate logins from...

Nope.  It works just like DTS Designer in SQL 2000.  Strange problem.

Greg

Hi Carol,

It depends on the security settings in msdb, particularly EXECUTE permissions on stored procedures that work with DTS packages i.e. sp_add_dtspackage, sp_drop_dtspackage, sp_enum_dtspackages, etc. 

My suggestion is to go...

No, Copy-only is a new feature in SQL 2005.  I think the closest you'd get in SQL 2000 would be to use BCP or DTS to export data. 

Greg

Lowry,

Are the packages stored in Meta Data Services?

Greg

You can create a temporary table in the stored procedure that has columns for the results of sp_help_job.  Then, insert the results of sp_help_job into the temp table.  You can...

Service packs are always separate downloads.  I've never seen one that included the original server components so you're stuck with installing them sequentially.

Greg

"add your users to the db_owner role..."

Come on.  The guy just wants to create and execute stored procedures.  He doesn't need all the permissions that the db_owner role grants.

Greg 

sp_cycle_errorlog cycles the SQL Server error log, not the SQL Server Agent error log.

Greg

Here's a query I've used:

--This script list all the users defined for each database on the server, it gives --the database name, the user name, the role membership, and the...

It's normal behavior for SQL Server Agent to keep 9 archived error log files in addition to the current log.  It opens a new one when the Agent service is...