"Freedom of speech is important because it allows you to easily see who are your enemies.  If a state prevents freedom of speech it cannot see who are its enemies,...

You can do this easily in Enterprise Manager.  Open the dialogue to cerate a new login, and type BUILTIN\ADMINISTRATOR for the user name.

If you are using SQL 2005 you can use recursive SQL to generate your data.

The 'DB2 SQL Cookbook' has some interesting examples of this that would work OK in SQL...

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...