Have you checked the obvious...

1) Do you have UPDATE rights on the DB2 database.

2) Is your syntax DB2 compliant.  DB2 and SQL Server have a very similar SQL dialect, but...

I have just had a look at the DB2 for LUW SQL Reference manual and your query should work.

However, you need to be aware that DB2 running on the mainframe,...

A restore will apply your changes in the exact order in which they originally occurred.  If restore worked in any other way, it would not be possible to do point-in-time...

Your tempdb only grows because SQL needs the space.  Stop shrinking it!  Plan to have a tempdb of whatever size is needed to service your application (be it 1GB or...

My understanding is that once you have migrated your DTS to SSIS, it can run on SQL2005 in either 32-bit or 64-bit mode. 

This is the 64-bit edition of SQL Server, which runs on 64-bit hardware.  Both SQL2000 and SQL2005 have 64-bit editions

DTS does not work on 64-bit SQL2000 because Microsoft never ported...

The answer is: 'It depends'. 

If your table variable gets too big to hold in memory, SQL will automatically create a temporary table as backing storage.  If your SQL has no...

Why are you shrinking your database files?

If your normal work pattern means that a shrunk database will revert to its original size within a month, then you are actually harming...

The number of connection attempts could be amalicious attack.  Or it could be something like an in-house monitoring tool trying to check SQL Server health.

The suggestion about using Profiler to...

I was going to suggest the same as Yelena.  If the user is a member of more than 1 group, and each group has a different default database, then you can...

You will certainly need to modify some Microsoft stored procedures to do what you want to achieve.

I looked at doing something similar, but my site is not prepared to modify...

Try DELETE .... WHERE CURRENT OF ...cursor.  See Positioned Delete in BOL.  This will allow you to delete a single row from a set of tue duplicates. 

If you can...

You need to have permissions to start/stop the SQL services.  This can be done using a local security template or via a GPO.  Check with your infrastructure/security people to find...

My experience for 32-bit SQL Server is this:

1) The memory that SQL Server can address is dependant on Windows settings and SQL Server settings.  The default is that any edition of...

Your proposed upgrade strategy appears to be designed to cause an outage.

I would look for an alternative, such as testing it first!