Rob,

the query is fine and what your colleague told you is nonsense. I'm pretty sure that if you use Profiler and run a trace you will see the query completes...

Sorin,

DBCC TRACEON(1118) will turn on the traceflag for just the current

connection, whereas including the flag as a startup parameter will apply it

to ALL connections.

Anyway I'm not sure I would use...

About 5 months ago I bought a desktop with Vista Home Premium pre-installed. While I liked the new interface and some of the new features I soon run into problems with incompatible applications....

This "strange behaviour" is actually just as intended. The =* syntax has been deprecated a long time and in SQL 2005 only it's no longer supported.

To avoid problems like this...

You can stop a trace with the stored procedure sp_trace_setstatus.

In order to use it you first need to find the traceid of the blackbox trace.

Run "SELECT

Arvind,

unless you have some transaction log reader utility like LogExplorer you can't find the exact time. So you can either go with the trial and error method or restore the...

Kevin,

if you want to edit SQL 2000 DTS packages you need to install SQL Server 2000 DTS Designer Components which you can download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

BIDS can only edit...

Hello Paul,

Backup files don't contain any backup history. Backup history is contained in a table in msdb.

A full database backup is just a snapshot of the database a the time...

Sorry, but that's nonsens. You can restore a backup of a SQL 2000 database on any SQL 2000 server, no matter what service pack. If it's a system database you...

I rememebr ran into this error also once. What I remember it's not like you get the error every time, it can work without problem for a long time and...

Check out this article: http://support.microsoft.com/kb/889170

SP4 should solve your problem.

Markus

Even though you might find it from the first link, just to make sure the link about licensing multiple instances is here http://www.microsoft.com/sql/howtobuy/multipleinstances.mspx

Markus

Jack,

if you use a per CPU license when it makes no difference how many instances you have. If you use a per user/CAL license, when the users/CALs for all instances...

Hi Trigger,

as far as I know there's know replacement for xp_cmdshell. The reason why it's disabled is just as you guessed the security issues around usig it. In case you...

If you look at the full result of sp_spaceused you should see that data and Index_size have been growing whilt unused is getting smaller. The database itself won't grow, until...