ditto

How about an article on how to detect potential problems like an audit trigger that concatenates stuff together and stuffs it in a text field, potentially causing an error if...

Check again, aren't the 12 "rows" actually a list of your columns?

Thanks for all the fish!

The trick was dropping the server before trying to add it as "local".  I had been trying to add it as local without first dropping it,...

This can be due to many things.  Infrequent (non-existant?) log backups, large transactions (DTS?), etc.  Essentially the cure is usually to backup the log file, which will then allow the log...

From my observations the sp:recompile trace shows automatic recompiles only.  Thus if you were to add or remove indexes that would be used by a query, you will see the...

Not sure if it is SP4 or not, but after installing it in our lab, we noticed that our Win2K cluster now "hangs" on SQL Server start when using Move...

I have made extensive use of XML and XSLT in an international data exchange network.  All the data was and is stored in relational databases, as it should be.  But...

The following query will return all the table names and column names with the seed and increment values.

SELECT left (so.name, 30),

left (sc.name,...

Try the "syscolumns" table. The column "autoval" will show the identity seed and increment values as the 2nd and 3rd 8 digit groups from the right.

Hmmm,

Obviously you don't play Russian Roulette, as anyone who does and uses a "magazine" always loses if there is even one round in it.

Not sure of impact of "C + 2 data", but it sounds like what you'll probably want to do is set up continuous transactional replication publications on each...

Don't know about pre-7 versions, but SQL Server 7 / 2K both support updates via transactional replication. I.e. they either send actual SQL UPDATE statements or call custom stored...

I know you can skip selected errors in SQL 2K, i.e. "On the -SkipErrors property you can put 20598.", but is there anything similar I can do for SQL 7?...

Never mind!  Should have done search of forum first.  Found previous post with reply for fix.   Thanks!