Try assigning the value of Employee_PK_ID to a variable in your first select statement.

Then in the where clause of the update statement, have:

[font="Courier New"]WHERE @Employee_PK_ID_variable = tbl_EmployeeWageRates.Employee_PK_ID[/font]

As it is currently...

SQL accounts (in SQL 2005) can be locked out if you are enforcing password policies & password expiration (only applicable if you have installed on Windows Server 2003).

When connecting to...

Please don't cross-post. I replied to this in another area.

Check out link below in BOL for GRANT syntax. You can restrict it to columns if you really want.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm

Has he actually stated that he wants to run a Backup Exec SQL Agent? From what you've written, he just wants to do what you want him to -...

If you must backup the log with truncate_only, make sure you immediately do a full database backup. Otherwise you risk losing any data since the last backup if the...

Since you know what the filename is going to be, you could construct the restore statement with that in mind & use EXEC or sp_executesql:

[font="Courier New"]DECLARE @BackupFile varchar(100),

...

It won't matter who you are logged in as - when SQL Server runs a backup/restore command, it uses the credentials of the account the SQL Server service is started...

Yep, that was one of our biggest hurdles - sorting out the account references, because they weren't consistent between the documents.

MS obviously need to do more blind testing - hand...

Just watch out for removing things like Management Tools. I removed an instance (think it was 2000, not 2005) on a multi-instance server and was left with the other...

What Matt said. At my last job, (with an outsourcer), I had to know about Legato, Tivoli, ARCserve & Backup Exec agents. And restoring from them can be...

Like the error implies, there is no xp_create_subdir in SQL 2000.

You're pretty much asking for trouble trying to get SQL 2005 maintenance plans working with 2000 servers, especially given how...

In lieu of a trigger, have you considered scripting the restore process, including post-restore steps of creating the user you require? If it is a regular occurrence, maybe implement...

There are the Microsoft TechNet Virtual Labs. I think you need to have a subscription to TechNet to be able to use them. The URL is here if...

I had a similar issue with our SharePoint setup. Only I managed to catch it before it went into production. Took one look at the GUID in the...