select name, state_desc from sysdatabases

not a very descriptive post, but...

try using "." as your server name, just a dot.

and make sure SQL Services are running....

select @@version

union

select current_user+' '+'as'+' ' +system_user

something like this?

try:

http://www.connectionstrings.com/

make use of a table, with a 0 and 1 value, with date.

each time the job has started, it writes a date and value of 1 in the table.

configure the...

The sequence requires an older log to be restored first and then the newer one.

update stats on your tempdb after shrink.

use tempdb

go

exec sp_updatestats

and what was it?

it's always good practice to explain the solution, whenever we can't assist you, that way, we learn as well.

script out the keys, NC Indexes, etc and add them to the bottom of your script (create table script)

Do a repair on your SQL 2000 installation.

with regards to? using it as a source/destination? please give more detail.

Yes, because there aren't any.

have your statement look at everything > than....

SELECT [Yesterday] = DATEADD(DAY, -1, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP));

duplicate post.

I'm using SQL 2005 Express, and scripting the dbo.backupFile table on msdb, scripts out everything, columns, keys, indexes etc.

USE [msdb]

GO

/****** Object: Table [dbo].[backupfile] Script Date: 04/15/2010...