They had the tools out to keep the trial version patched out for beta testing, and they were supposed to make a final decision on what to do with them....

No. You can create a role called db_executor or something of that sort and then run jobs to continually update that role's permissions as new stored procedures are created. Put...

We took a look at Compaq's as we are a Compaq shop. The idea that Altiris has to be leveraged heavily in order to use their blade solutions isn't a...

Net send can be TCP directed to port 139. If you specify the hostname, the system wanting to send will try to resolve the name, establish a normal TCP connection,...

Thanks, Tim, for the catch on the connection string. I've edited the post accordingly. Just as an FYI to anyone who might post, if you post a question and use...

That's a good idea. I'll have to add it to the list of articles I need to write. Of course, if someone is a hardcore data warehousing DBA (I know...

UDP is on top of IP. It can cross subnetworks (recall SQL Slammer used UDP to port 1434 since it was an attack on the listener service) if it is...

There are some cases where you can't without some prior steps:

Full-text indexing - Add NT Authority\System and make it a sysadmin

Clustered Instance - Add the Cluster servic account and make...

Or Windows 2000/2003 Advanced Server. As Tim has said, you may install Personal Edition. Also, if you have an MSDN subscription of the appropriate level and you aren't going to...

mdhealy, I'd agree with you, but unfortunately, it's the reality of the situation. I've been in the position where I've said, "I would prefer you build your database this way..."...

Hi jrobertsteg,

Can you elaborate more on your concerns and perhaps discuss how you'd present it?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Be sure that when you install MS02-061, that should you install the HotFix that comes after it (dealing with a handle leak... article 317748), don't overwrite any files. It'll overwrite...

Must have tool? Caffeine, lots of it.

But seriously, I make heavy use of Query Analyzer and Profiler, though these are the standard tools that come in the box. I can't...

Alternately, if you're running all Win2K or higher systems for the client(s) (WinXP/2003), you can use IPSec policies to restrict what IP addresses may access the server. Keep in mind...

It would have basically the same effect as a cursor in a stored procedure. The difference is, the trigger fires every time the specified database operation (INSERT, UPDATE, or DELETE)...