Stephen is correct about the certificate (password) issue. Except that Microsoft requires passwords AND connection strings to be encrypted. The problem arises when:

1. PersonA creates a package (it is now...

We don't know the specs about your server, nor how you are doing the restore (from tape? from disk? across the network?). So, it's hard to tell how long it...

Then I would accept the default...I think that SQL Server 2000 looks for MSSQL as a folder. So, if it doesn't exist, it has to create one.

-SQLBill

sp_who2 ????? It's hard to tell what you are really looking for. Can you be more specific?

-SQLBill

Also, when you right click on the job and select View Job History, the history window will have a check box for View Job Steps. Check that. Then you can...

If the job was scheduled and enabled, go the schedule tab of the job and check what day it was scheduled to start.

-SQLBill

Nope. SQL Server 2005 and SQL Server 2000 Master databases aren't interchangeable. I don't know what the differences are, but there are differences in stored procedures, how certain...

Why are you trying to install SQL Server 2000 SP4 to a SQL Server 7 path?

-SQLBill

You might try to delete the registration in EM and re-register the instance.

Or uninstall EM and reinstall it.

-SQLBill

You 'probably' used WITH NORECOVERY when you did the first restore. That will leave the database in LOADING mode as it is waiting additional restores.

-SQLBill

To clarify, are you able to log into the 'bad' instance with Query Analyzer and the SA account?

-SQLBill

Are you using SQL Server 2005 or SQL Server 2000? current_timestamp only exists in SQL Server 2000.

If you are using SQL Server 2005, you might want to check your...

You don't give us a sample of the results, but I will bet it IS ordering the values correctly. Your [data] column is most likely a string type of data...

How are you running the script?

You could create the script as a stored procedure, then have it run by a job. In the job you can list who is the...

Some people don't want to reboot their servers....they may be production servers with other applications running. You have two options...

1. stop the services listed, apply the SP, restart the services

or

2....