Of course, if your backup solution only writes to tape, and you forget to load the necessary tapes into the library, then your backups would fail for that evening.

it is still asking for a log file.  I think attaching a db w/o a log does not work, I have read past articles on it.

Jaya,

Triggers are usually very cpu intensive for the server, using the temp table is a much better solution for this, but keep on eye on your tempdb as the amount of your...

This sounds like homework...LOL, do I get an A or you if I give you the correct answers?

Jules

Donald,

If you have databases which are in the terabyte sizes, I would strongly suggest you buying SQL Litespeed.  It is one of the best and fastest database backup softwares in...

Suresh,

Sounds to me like your MDAC 2.8 file got corrupted.  Here is how this gets fixed:

go to regedit and delete the following entry:

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents

and reinstalling MDAC 2.8. - can be downloaded...

Lisa,

You can ask the dba to give you read access, can't imagine you having to do this task everytime you want to query this db especially if you want refreshed...

Yes Rudy, you are correct!

Jules

Mario,

Make sure you don't have table names which are duplicated.  By this, I am saying if a user logs in with his windows authenticated username and he is dbo, he...

Helen,

Usually when sql mail hangs, an error should come back, can you capture the error?  Please give more details.

Jules

Please refer to this article for dts portability

http://www.sqlservercentral.com/columnists/tdavid/moreportabledtspackages.asp

Jules

To answer Will's question about the root drive, you can backup the entire server using some very reliable backup programs, we use CA Brightstor for our development environment and Galaxy...

LOL, Fortune 100 is the downsized version of Fortune 500.  The other 400 are being outsourced.

On the serious side, you can and should archive that db to tape and store...

Adrain,

When you execute the package manually, it uses your account (the one you use to log into your desktop/laptop).  When you schedule it to run, it uses the service account from...

Ian,

Looking back at past articles on this site, found an article that you might be interested in where you can disable foreign keys for snapshot replication.  Here is the link: