You can defined a linked server on ServerA that refers to ServerB, then you can use it more easily than the rowset functions.  Whatever login credentials you need for ServerB...

The syntactic flexibility added by SET ANSI_NULLS OFF is very limited.  This setting apparently only affects col = NULL or col = @var (where @var is NULL).  I could not find any context where...

Are you using the Edit menu item of Object Browser in Query Analyzer?  It doesn't really open the procedure for editing, it's just a shortcut for Script to New Window as Alter.  The generated...

Anyone who's really, really nostalgic about Forbidden Planet can buy their own life size Robbie the Robot from Hammacher Schlemmer for Christmas.  Only $49,999.95.  (Not a joke).  Sadly it seems...

How about Short Circuit?  Not on my Favorites list, but it certainly has computers and geeks.  And a babe (well, almost a babe).

It's hard to beat Desk Set for "cheesy tech".  Huge wall of lights for the processor, big spinning tape drives (with no tape on the reels if you look closely),...

"Add linked tables" will add tables (not currently in the diagram) that are linked to diagram tables.  It doesn't control whether the links appear or not.

If two tables in the...

The diagrams in SQL Server directly reflect database structures, it's not simply a tool for making pretty pictures.  The links in the diagram ARE foreign keys in the database.  If you add...

The links in the SQL Server diagram tool are always one-to-many.  The links are all foreign keys, and the field(s) referred to by a FOREIGN KEY constraint must have a...

You mean there's a book on a procedural approach to SQL Queries?  Something like "Cursors for Dummies"?

A replication subscriber is not a hot spare ready to take over if the production system goes down.

The biggest issue is if you have any tables with identity fields, they won't...

2001 (1968)  Has to be on top of the list.  The Matrix and Terminator weren't really about computers, they were about special effects.  I liked I Robot, Wargames was not bad.

Some others that...

Maybe I should rephrase my statement.  I don't see how someone with no knowledge of your hardware, application, or server load could possibly make an informed statement about the speed...

I think it may be easier to do this in steps.

   Identify who will receive the rounded value

   Insert payment records for all other parties based on multiplying by share...

I rarely operate directly from the server console, but if I am it's likely to be in the middle of a crisis.  If I need BOL and can't find it,...