Brian probably has the best idea. Didn't even think about the brute force attack, although I did almost mention reading the SQL Server Error Log via a job.

Lowell (8/7/2009)

---

Jack Corbett (8/7/2009)

---

Do you have database mail setup? Have you set up the alert system to use database mail? Lastly, how did you setup the alert? ...

Do you have database mail setup? Have you set up the alert system to use database mail? Lastly, how did you setup the alert? I setup one...

Did you verify that the Named Pipes provider is enabled using the SQL Server Surface Area Configuration manager?

I contracted as a report writer for a company that had similar requirements. They had different report folders for each client and used "linked" reports. The linked reports...

SQL Server 2005 only has 2 date types, smalldatetime and datetime, both of which store date and time. By default if you do not enter a time then you...

See this article for information about full-text indexing.

Michelle Ufford aka sqlfool has an excellent script[/url] on her blog that handles index maintenance.

Well, for SSC you can add the articles to your briefcase.

I use google bookmarks[/url]. Then you can have them in your google toolbar (if you use it) or...

Please read the article linked in my signature line. If you post more information someone will probably be able to help. With the limited information you have provided...

If you are restoring the setting is being applied from the database backup. In reality you shouldn't have autoclose on for any database. You'll have to change the...

Did you read the BOL entry that contained the example you posted? It explicitly states (emphasis is mine):

CHECK constraints reject values that evaluate to FALSE. Because null values evaluate...

I wouldn't use SSIS for this. This is one of those instances where I'd use a loop. Can you provide table structures and some more info as to...

What are you trying to accomplish using ole automation?

Are you running SQL Server 2000 or 2005/2008? If 2005/2008 then you should look into using the SQLCLR instead...

Because you are using the Excel/Jet driver you need to make sure you use the 32-bit version of dtexec to run the package. On 64-bit installs SQL Server Agent...

Nothing shameless about it. Good articles, regardless of who wrote them are good...