We have auto close turned on on desktop, development only copies of data. XP knocks the memory down to 7.5 meg when not in use. The connection time...

Jensk2: My hat is off to you. Not only do you find the best of all methods, you are able (and willing) to find the chapter and verse...

I needed the "next" number, not the current one, so I did some testing on Jensk2's adaptation of Antares' one line idea (see below).

if you ever need the new...

With regard to point a) (memory always around 900MB), that's what you would expect with 1 Gig of ram. SQL will use all you give it, and generally use...

I found my answer this afternoon through sheer exploring and experimentation. This isn't for the faint of heart, it involves editing a MS supplied system stored procedure.

Don't everyone answer at once!

Student of SQL and Golf, Master of Neither

Me too. Seems like it's failing during times when CPU usage is high. Often at lunch and around 4 when a lot of our customers are running updates...

I just want you to know Steve, that when you need another employee, I am available at that couple of thousand a day you quoted. Heck, I'd even go...

Since Allen's excellent post several days ago, we've been killling sqlmaint.exe from the NT Task Manager a couple of times a day. I'm still quite thankful for that bit...

Allen, you are a gentleman and a scholar. Just for the sake of caution, I stopped SQL Server Agent first, then killed the sqlmaint.exe task in Task Manager, then...

We simply never grant any rights to the public role for any object in any database in the first place. We set up sensible roles for different levels of...

Please don't screw up a valuable resource.

I have used this forum regularly since I found it. It has a better wealth of "how to" and "why" posts and articles...

Sounds to me after reviewing all the posts, that the smartest strategy would be to have at least one Login (use SA or name one MasterLogin???) defaulted to the Master...

I highly recommend getting MDAC Ver 2.7 if you distribute files to your customers that they access SQL with. In addition to the previously noted vulnerability that affects versions...

We upgraded our MDAC to 2.7 many months ago. (We develop third party software and we have to be using and distributing the newest versions of drivers before our customers...