Peter is making some very good points there.

I would still run without /3gb, I wouldn't put extra memory in just yet, see how you get on without it.

We have some...

Don't know what happened there.

Could you try running your server without the 3GB option.

Douglas

Anne,

That procedure will certainly use a lot of memory.

/3GB is only required if you are using products such as exchange, it is not needed for SQL Server.

If you stop/start SQL,...

LiteSpeed from Imceda, would allow you to recover one individual table from the backup file, without recovering the whole database.

Regards

Douglas Chrystall

Imceda Software

http://www.imceda.com

Hi,

Your SQL Server Kernel memory is getting fragmented.

Can you tell me why you are using the 3GB option?

Regards

Douglas Chrystall

Imceda Software

http://www.imceda.com

Hi Andy,

Calls to COM objects can and do work extremely well. If you are using C++ make sure you deallocate and free your com resources systematically, otherwise you will cause...

Hi Markus,

Imceda SQL IDE has a very comprehensive Login, User and Role Feature, this may give you the functionality you are looking for.

http://www.imceda.com/Product.htm

Regards

Douglas Chrystall

Imceda Software

Hi Bill,

You should take a look at

Imceda's SQL IDE, it is pretty much becoming the defacto SQL Server IDE product and it has excellent integration into VSS. We also...

Take a look at SQL IDE by Imceda Software.

http://www.imceda.com/Product.htm

There is a Lite and Pro version.

Regards

Douglas