It Depends

Without more details of what you want to do, and your background, it's hard to suggest

Are you a Developer, a DBA person, etc...

It's possible I guess, except I actually don't know how to set a schedule to run when SQL stops

I have seen schedule or articles to run scripts when SQL starts

You...

You might have to use Linked Server, or use

INSERT INTO OPENDATASOURCE('MSDASQL','DSN=Server;Uid=user;Pwd=password').DB.dbo.TABLE

SELECT *

FROM Table

another reason why Microsoft should rename the TIMESTAMPE data type

any reason not to use 64 bits OS and SQL 2008?

I think you can use a Report Snapshot, and go back to them

Otherwise, I'd either CC the email report to another address for archive

or use File Subscription to save a...

I had to use Maint. scripts instead of Maint. Plans for my 7.0 upgraded databases (stayed on SQL 2005 server in 70 mode)

A blog on xp_delete_file

http://sqlblog.com/blogs/andy_leonard/archive/2009/03/11/xp-delete-file.aspx

declare @DeleteDate nvarchar(50)

declare @DeleteDateTime datetime

set @DeleteDateTime = DateAdd(hh, -24, GetDate())

set @DeleteDate = (Select Replace(Convert(nvarchar, @DeleteDateTime, 111), '/', '-') + 'T' + Convert(nvarchar, @DeleteDateTime, 108))

EXECUTE master.dbo.xp_delete_file 0,N'E:\WSSLogs',N'log',@DeleteDate,1

Studying and getting a DBA certification (like MCITP Database Administrator for SQL 2005/2008) is another way to show you want to become a DBA, seriously

I started out as SQL Developer...

Were those domain logins invalid?

I always set my newly created databases owner to 'sa'

To avoid issues like this, and also when someone leaves the company (AD account disabled), it won't...

the questions sure are getting .... @@

70-431

70-443

70-444

= MCITP SQL 2005 Database Administrator (IMO = MCDBA for 2000)

But look at the link provided

I can't think of quick easy solution

Merge Replication between 2 servers, with Tables under the Published articles

Use the "Email Subscription" (vs File subscription)

By the way, you need to setup SMTP in the SSRS Site Settings first before you'll see the option "Email"

Default is just File Subscription

Not entirely sure what you meant

Your job schedule is set to DAILY, and EVERY 5 MINUTES, between 12:00:00 AM and 11:59:59 PM ?

Or you could change the code to be ALL or parmeter

from cnotestocreate

where staffkey=@staffkey -- 1 record only

OR @staffkey IS NULL -- copies all records, if you pass NULL parameter