Jason Shadonix (3/26/2009)

RBarryYoung (3/26/2009)

I have tested it...

That's two "clunkers" in the last 2 weeks. I answered the question correctly, from a SQL 2000 standpoint, and was told it...

Just a hunch based on what your expected output is but category ID is 11, 12 and 13 not 1, Maybe where left(categoryId, 1) = 1 is what you're trying...

Should be getdate() not [date]

Select case when (leavedate is null)

then datediff (day,enterdate,getdate())

else datediff (day,enterdate,leavedate)

end as 'totaldays'

from reservations

You'll need to make the obvious database/mdf/ldf/path name changes. Look up restore database in BOL for more options.

RESTORE DATABASE [LIVE1]

FROM DISK = 'C:\Backup\LIVE.bak'

WITH...

see your other post:

http://www.sqlservercentral.com/Forums/Topic681196-5-1.aspx

There are a few "demo" alerts that come with SQL server 2000, these being two of them. Mine are enabled so they will fire if a threshold has been reached,...

One thing I would suggest - email on failure only. You'd be surprised how de-sensitized you will become to the influx of emails, especially if 99.9% are successes. If the...

There is no proper planning for this type of task. It should be used on rare occasions where a...

On the SQL server machine, right-click on my computer and select "Manage". Expand shared folders and click on "Open Files". Search for your file name to determine who has a...

Please don't tell us you haven't had a backup in nearly 6 months???? And is so, what took so long to find a resolution?

Can you locate the script that's generating the backups? You cannot do a differential via a maintenance plan so there has to be a script somewhere. One of the backup...

And, obviously, be sure you have a full, clean backup before starting. It should be a pretty straight forward process but you never know.

I realized that...

Based on your sample data, wouldn't you use quote separated or am I missing something? Using the import wizard, I believe it's the first or second screen after you select...