I guess it would be useful if you had publications available in a very large environment and didn't know exactly what server a particular publication was on... but even this...

You won't cause recompilations in the stored procedures if you use sp_executesql. However, as dj_meier indicates, you may get recompiles on the dynamic SQL itself unless it's a parameterized query....

MS DTC will need to be configured for cluster support before you install the first SQL Server instance. Therefore it'll be located in the Cluster Group (quorum). After you have...

3-part naming convention:

Database.owner.object

Such as Northwind.dbo.Customers

If you don't specify an owner or a database plus owner, it looks in the current database first for an object owned by the user and...

Look at the articles on Dynamic SQL by Robert Marda on this site:

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

Also take a look at MVP Vyas Kondreddi's article on SQL Server security. He talks a bit about...

Look at the Memory Manager object for each instance in Performance Monitor (perfmon). The Total Server Memory (KB) counter should tell you how much memory is being used. These numbers...

This should be the same in both SQL Server 7 and 2000. It's because of the way SQL Server looks for stored procedures that start with sp_... first in the...

SOUNDEX() is relatively simplistic. You may look at Ken Henderson's improved comparison in his book The Guru's Guide to Transact SQL. Also, Full Text Indexing does have some ability to...

Is the backup to a local drive then copy to a remote drive not an option? This would ensure a failure on the network doesn't prevent your backup from running.

K....

Basically, it looks like the firewall is right... you need to open port 1433 into your internal network. The question is, do you need to allow all network traffic back...

It shows up in the trace itself but I'll be honest in saying that it requires a LOT of activity. The case I can cite was a trace that dumped...

The cache hit ratio could also be low due to stored procedure recompiles. Case in point: a SQL Server with 2.5 GB of memory only using about 1.4 GB with...

If you are going to save trace results, saving to a trace file is considered fastest. At some later point you can take a trace file and convert to a...

Also check out Brian Knight's step-by-step article:

http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

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

How about simply modifying sp_password? You could insert logic to keep track of when a login's password was changed in a separate table. Then have a job run nightly that...