Darren,

Thanks for your explanations. I am in the process of installing RTM.

I would add #7 to Greg's list:

7. Issue a statement that send an email.

I use Database Mail and for some reason it works. I am using a statement like...

I checked all four answers in SQL Server 2000 BOL Only the correct answer has a comment that it may be obsolete in future versions. It is in SQL Server 2005 BOL...

I answered correctly, but what happened to the old good backups? The original files should be on the backup tapes.

I do agree that to click Edit is much easier,...

Lisa,

How did it happened?

To fix: there was a post several days ago. See discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=246152

"Dropped sp_spaceused

Posted 12/22/2005 5:58:00 AM"

There is a good advice by Brian.

Hi,

What do you mean:

1. Do you wnat SQL Server Errors to be logged to a table from within SQL?

OR

2 Do you wnat error messages from the front end to be...

Karim,

There are some other restrictions on what is or what is not logged with Bulked-Logged model. I would read the article on Bulk-logged a couple of times and decide if...

I think your application may check the statements that are sent to the database. If the Delete keyword is detected then an insert statement is going towards you custom Audit...

Steve,

This is wonderful!

Happy New Year!

It is my understanding ( and interpretation by the most of books) that

1. You have Full Recovery = Transaction Logging before the bulk load (BCP and Bulk Insert). So you...

Happy Holidays to Everyone!

Mike, thanks for your good wishes! I already got some chocolate, a candle, a box of cookies - this is at work. I still did not finish...

Hi,

I know someone who works with MySQL client towards SQL Server database, but he will be available after the Holidays. You may send me a message on /after Jan 3...

I posted an example of the trace that uses sp_trace_ procedures when answering someone' else's question here several days ago. The script is commented, so it is easy to modify...

Brian,

local-site-domain-OU -OU inside OU is applicable to everything EXCEPT account policies that are only at the Domain level for Domain logins. Logins local to the server like MyServer\MyLogin according to...

Hi,

Why do you do it from a QA if you are on the server? Can you do BCP from the command prompt? Are you getting any messages when you run...