I take it the user you specify does have permissions? (sorry I know thats a simple response)

Good advice

I run this activex script within a sql job (as the step before the backups) on a SQL 2000 box. Haven't tested on 2005 or 2008. You'll have to stick...

Actually - on the MS site for licensing FAQ -

Q. What is SQL Server 2008 Developer edition and how is it licensed?

A. SQL Server 2008 Developer edition is SQL...

I'll pass them the question! Thanks for the info :hehe:

Would I need 1 dev license for every developer accessing a Developer Edition server?

Also - does a SQL 2008 enterprise license cover you for Standard edition if you decide you...

Try .BAK rather than .bak. I had a similar weirdness based on that case. If this doesn't work, let me know as I have an activex script that I use...

If you literally meant deadlocks - thats a whole different story (monitor the locking).

If you meant freezing up - You may want to set a min server memory as well...

In that case a cursor wouldn't kill performance much as you are only using it to move through a handful of "divisions". Its when people use it to plough through...

sp_who2 - make a note of your process id

sp_lock x (x = process id)

This brings back a list of locks. Check the obj id's against sysobjects

There is probably a...

Before -

System cache required for windows process. Eats into SQL server Target memory (total memory follows with it) until SQL server has no memory left and the processes and queries...

Minaz Amin (7/8/2010)

---

If, Total Server Memory (KB) counter is less than the Target Server Memory (KB) counter, then this means that SQL Server has enough memory to run efficiently.

On...

If you are referring to the tempdb tip above, I personally have never explicitly set each tempdb data file to a CPU. Its just matching the numbers by creating 1...

We was getting that error - yep! I haven't checked for the error again, but monitoring the behaviour in perfmon. Will keep an eye on it.

Oh god I have the same issues with the hardware guys claiming a SAN doesn't need a data/log split because its a fast SAN. Why is it so hard to...