As has already been hit upon, if presenting examples, it's easier to give a person a bit of code to copy, paste, and execute rather than give a list of...

Probably one of the easiest ways is by using NetMon or some similar network sniffer package. NetMon and Sniffer Pro can both understand and translate TDS packets (Tabular Data...

In addition to what Andy has said, there is some additional guidance in Books Online. Though I'm going to agree with Steve that unless there's a hard and fast...

In SQL Server 7, it depends where the active portion of the log is. If it's towards the end, there won't be much shrinkage. In SQL Server 2000,...

There are 3 million records in the table, but:

a) How often does "data movement" happen?

b) How many rows are affected?

c) What is the average duration?

I've run into this problem at...

You'll need to look very closely at your terms and agreements. In many cases they have clauses that waive all liability. A couple of our clients had this...

8.00.194 SQL Server 2000 RTM

8.00.384 SQL Server 2000 SP1

8.00.532 SQL Server 2000 SP2

K. Brian Kelley

bkelley@sqlservercentral.com

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

Run a SELECT @@VERSION to verify. What you may need to do is reapply the service pack. One thing that did change between the various SP versions is...

If you need to know the MAC address of the SQL Server box, connect to it using Query Analyzer. Then run the query, putting in the name of the...

The log files are there for your own protection, so it's generally not a good idea to turn logging off. With respect to dealing with the log files, you...

Neither does mine, but that's not a big deal. Just drop from the AND on... Try this:

SELECT DISTINCT net_address 

FROM sysprocesses

WHERE hostname = '[Your computer...

Here are the versions that I have:

SQL Server 7 RTM (7.00.623) - File Version 1998.11.13.0

SQL Server 7 SP1 (7.00.699) - File Version 1999.5.15.0 (I think this one is right)

SQL...

The following works:

DECLARE @Table sysname

SET @Table = 'Customers'
EXEC('Use Northwind; SELECT * FROM ' + @Table)
But I admit I've...
 

DBCC SHRINKDATABASE and DBCCSHRINKFILE will shring the data files, but may not necessarily shrink the log files, because the active portion of the log may be at the end of...

They didn't come from Visual Studio Service Pack 5. They aren't in the file list. Both versions are running the same service pack? Did you install the...