Also, if someone has administrative rights to the box and if they know much about SQL Server, they can get access to the data without too much trouble. Therefore...

I'm trying to set up a process similar to what Steve describes. Until a service pack is tested with the existing install base, it's impossible to say if there...

Look out Robert, looks like you're getting in the same situation I'm in... you write an article that produces thought and there are clamors for a follow-up! It's a great...

http://www.sqlservercentral.com/forum/reviews.asp?CAT_ID=7&FORUM_ID=59&TOPIC_ID=2637&type=2&article=614

Here's my thoughts... when scientific papers are prepared for review or for publication, a short abstract (100-150 words usually) is prepared and attached, sort of the same way a cover...

The BUILTIN\Administrators group is the same as the local Administrators group for the server. Basically, whatever rights (sysadmin by default) that group has, anyone with Administrative rights to the...

For my developers who are reticent to dive into Books Online (including on MSDN) but are willing to go a web page, I now have a resource.

I thoroughly enjoyed this article. If I remember right, in Henderson's book The Guru's Guide to Transact-SQL he runs into the end of year issue as well with the...

We've seen this error on occasion with SQL Server 2000 (SP1) but while it occurs with SQLMail, it's an ODBC error. For our environment it occurs so infrequently (twice...

The series will cover the new features. However, as we discuss each part, I'll be mentioning common problems and issues that I've seen. The two issues mentioned in...

Binary sort order is not the default, but under SQL 2K, you can do that at the database level.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Since it's free, it won't hurt to give MS a call. If there is a real issue with the patch, they'll notice it that much faster. The RDP...

Your best bet is to implement a process like what Steve has suggested. Use a trigger or a stored procedure to insert a record into a table indicating that...

Considering this bulletin came out today, I am not sure how many people have had a chance to apply it. I'm going to probably take a look at it...

quote:

---

Problem is the Trigger hangs waiting for the VBS script to complete.

I would really like the trigger to call the VBS file...

Most of our servers are SQL 7 but we do have some SQL 2000 in the mix and we use maintenance plans quite heavily for basic backup and maintenance schemes....