I have found that when I use more than one database in a stored procedure, I have to put SET NOCOUNT ON for each one.

USE TEMPDB

SET NOCOUNT ON

Code

USE MyDB

SET NOCOUNT...

Your query to find duplicate fistamp on the fi table is incorrect. You are looking on the fi table when you should be checking the sl table (look at your...

Yes.

Transaction log backup is of everything since the last backup of any type.

Differential backup is of everything since the last FULL backup.

Scenerio: Midnight - Full Backup, every 10 Minutes a...

If you are taking transaction log backups every 10 minutes and NOT using them immediately, what's the use of doing it that way?

I would change the backup method. You can...

Here are two articles to read on moving MSDB and MODEL. They talk about using Enterprise Manager, but the facts are the same.

http://support.microsoft.com/default.aspx?scid=KB;en-us;224071&

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

Basically, you need to set the...

First you MUST restore a full backup with the WITH NORECOVERY option. Then you restore each transaction log in order using WITH NORECOVERY on all but the last one.

example:

RESTORE DATABASE...

You were in the process of moving WHAT files? And how were you trying to move the files?

-SQLBill

That is interesting. I'll keep looking and see what I can find out about it. It might be KEYWORDs but if so they aren't listed that way.

-SQLBill

Where does the 'work' take place? I know in Crystal Reports the default is to pull all the data back to the client machine. You can change it to do...

Also, make sure the login the job uses has access to the file it's supposed to run.

Might also want to check the Windows Event Viewer Logs (application, security, system) for...

You are logged in as Administrator when you run it in QA. But how is it set to run as a job? (In Enterprise Manager, drill down to JOBS, find...

Does the user have SELECT access to HISTORY?

-SQLBill

I have MS SQL Server 2000 and Veritas Backup Exec (both 8.6 and 9).

My data is mission critical and my prefered method is to use SQL Server's BACKUP commands to...

Description is NOT a keyword.

For a list of keywords, refer to the BOL, use the Index tab, enter "Keywords, reserved for SQL Server".

-SQLBill

BOL=Books OnLine=MS SQL Server Help

Installed as part of...

I believe the problem is with your subSELECT:

SELECT Accounts.ProductCode FROM Accounts WHERE h.ID=Accounts.ID

h is never defined within the subSELECT.

-SQLBill