Also, make sure that the sub-query returns only a single record since you are assigning it to a variable.

You can use spotlight from Quest.  It is a very good tool..the URL is given below:

http://www.quest.com/sql_server/

The "UPDLOCK" locking hint is used when doing a select for update i.e. when you are using pessimistic concurrency model and you want to make sure that no-one else can...

Have you taken a look at the deadlock output after turning on the deadlock trace flags: 1204, 1205 and 3605 ?

That will give you more information on what is going on...

We have our own home-grown SS2k database for this which maintains information about the servers, the databases, the applications etc..  We support Oracle, SQL Server and DB2-UDB and have lots of...

One more option could be to use a computed column which gets populated automatically using the UPPER function so that the values in that column would always be upper case. ...

Very nice solution Merrill.

Yes, there is - it also depends upon what that function on Oracle does.

An example (this uses the in-built function GREATEST from Oracle):

SELECT * FROM OPENQUERY (TESTCASE, 'SELECT GREATEST(7, 11)...

One thing that I wanted to mention about the approach from above - since it is based on the running total after the randomization is done - it looks for...

It can be done in a couple of ways...I am listing one of the ways to do this:

--Creating the actual table

CREATE TABLE TESTCASE (ID INT IDENTITY(1, 1) PRIMARY KEY, POINTS...

The above example will work if the database is on the same instance. If you want to extend this further and wish to query from a table from a...

That is the default port - you do not have to configure it for 1433.  Default installations of SQL Server monitor TCP port 1433 and UDP port 1434.  There are...

And why would you not want to use linked servers then ? You either have to make two connections (one to SQL and one to DB2) or if you...

You can also create a DTS package...make a connection DB2/AS400 and then use the in-built execute task to execute SQLs on DB2.