nope, you wont be able to install standard on XP, but you could always install the developer edition (basically enterprise rebadged for development purposes).

That should then let you debug till...

Good question, i've not had a huge amount of experience with the sp_prepexec and sp_unprepare, although I have on occasion spent a great deal of time trying to troubleshoot a...

I've encountered problems like this before doing restores from EM, for some reason SQL seems to want you to keep the logical name of the file even though it allows...

By default the OS loads into the memory below 2GB, the /3GB switch tells it to load above that leaving the first 2GB for applications (SQL) to use fully.

Sorry if...

Are you talking about the 'inserted' and 'deleted' tables in a trigger? or did AJ's response answer your question for you?

Assuming it may take a while to upgrade to enterprise edition...

You could always turn on the /3GB switch in boot.ini which will tell the OS to load above the usual...

No problem whatsoever, i've only been doing this for 8 years so i'm still just learning myself

So it looks like you're trying to do this?

Update Table1

Set T1.[Name] = T2.[Name]

From Table1 as T1

Inner Join DB2.Table2 as T2 On T1.[Name] = T2.[Name]

It may not be exactly right (ie...

Having a quick look around this seems to indicate that you have external fragmentation in the extents.

I'm assuming that you have a clustered index on the table? because this doesn't...

Hi Iztok,

I don't have any info as to which interfaces are supported for this sort of thing, but I do have a work around for you.

Instead of backup up from...

Hi there,

To the best of my knowledge the changing of licenses only works one way, basically you can go from per processor to per seat (once), but not vice versa.

The...

Nice one Aunt Kathy

Hi Carl,

This is just my take on things but here goes.

1. I always run performance monitor on the SQL server that I want to monitor (except for when I decide...

Just to add another one to the pot, you can also use Double-Take which is similar to some of the others mentioned above.

I'd suggest that you get the AD issues...

I haven't seen this before but I would like to ask whether you are deleting all rows from the table or just a selection of them?

If it's all then you...