Duplicate post, please post/see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12047&FORUM_ID=8&CAT_ID=1&Topic_Title=sql+server+agent+alerts&Forum_Title=T%2DSQL

This is the TSQL used in my job to perform the Differential backup of all my databases to tape except distribution, master, model and tempdb.

ALso I change my tape out...

I agree make sure you are using SET DATEFIRST to set the first day. However if you still have troubles then consider creating a sliding process to slide the dates...

Or create the table as suggested and use an SP to get the next value and replace for the next caller to keep the sequence up.

Ex.

CREATE PROCEDURE ip_NextKeyVal

@val int OUTPUT

AS

SET...

Look at sp_MS_marksystemobject in the master DB. It can mark it system again but be carefull you might impact server stability doing this and potentially a later HotFix or SP...

I have not seen this but after the SP4 install I suggest make sure you DBCC DBREINDEX, sp_updatestats and DBCC UPDATEUSAGE to ensure the data is in line with any...

I know of no way as you have to open the file to read the contents.

Also, use DBCC SHIRNKDB or DBCC SHRINKFILE to cut out any excess space not in use.

quote:

---

Ah! Problem is me, me thinks. Sometimes it's difficult to explain what u have and what u want to someone else but...

Can you post the coe for both and the related execution plans (Use SET SHOWPLAN_TEXT ON). Just want to compare.

I don't have Quicken but did you happen to install after SQL Server?

Check the Registry and see if the SQL Guid looks ok. Here is what mine looks like

Thanks that information is helpfull. Can you give me more like on the Products, please? Do each have a unique PK number? And so the Expected output is

A 0

B 1

C...

Since you are ignoring NULLS then this I think is what you are looking for is something like this.

SELECT

(CASE WHEN ProdA = 1 THEN 'A' ELSE...

DId you happen to install the "SQL Critical Update" utility (more info at http://support.microsoft.com/?kbid=814372). This is the tool I recall folks saying was causing issues just like you are reporting.

More...

You can create multiple backup files and restore from those files (see BOL for BACKUP DATABASE, Note: I have seen issues with multiple backup files to DISK where the sizes...