Anyone had any luck fixing this? I'm on SQL 2008 R2 Express trying to access 2005 and 2000 machines and I'm getting the same message as the OP.

Cheers

Has anyone had any luck with this? We've done this on one of our servers by accident and wanted to downgrade to SQL Standard Edition. Are there any 'easy' ways...

Last time I tested the Litespeed object level restore it took about the same amount of time as a full restore so i haven't bother with it since, anyone used...

This isn't something uncommon, I'd be surprised if you could find a DBA that hasn't had to restore bits of data people have deleted. Possible ways to speed up the...

I'm having the same problem trying to use a linked server from a 64bit SQL2005 Server SP2 to a 32bit SQL2000 server SP3.

I've tried running the instcat.sql file which...

This is a bit of an old message but I was getting the same error after recently migrating to SQL2005 x64. It's apparently a problem to do with caching of...

Couple of points, why don't you run update usage? Then you'll have the right results. Also using a COUNT(*) isn't as bad as most poeple say, MS have actually build...

It's because you're using NVARCHAR, an NVARCHAR(50) actually consumes 100 bytes rather than 50 which is why you're topping the 8060 limit.

The Average Disk Queue actually depends on the number of disks you have, as long as it is under (2 * the number of disks in the array) you should be...

Restoring based on Recovery Mode

Simple - Restore to your last full backup

Bulk Logged - Restore to your last Transaction Log

Full - Restore to a point in time

I've got a few DTS packages that use global variables in the way mentioned above.

DTSGlobalVariables("GBL_LastSuccessfulRun").Value = CSTR(CurrentDateTime)

  Set oPkg = DTSGlobalVariables.Parent 

  oPkg.SaveToSQLServer "SERVERNAME", , , DTSSQLStgFlag_UseTrustedConnection

It's pretty straightforward and I...

Have you just enabled AWE in the SQL config or have you added AWE to the Boot.ini file and restarted the machine?

Have you enabled AWE? Enterprise Edition won't use more than 2GB of RAM by default, you need to alter the Boot.ini for it to utilise more memory.

Couldn't you just INSERT a value into a table on the server and then pull the results back from there?

Why not INSERT the transaction numbers you want to retrieve into a #Temp or @Table first and avoid the dynamic sql and then select the records from the main table...