It's on both sides. There will always be bugs in code, so blaming MS for writing bad code isn't really right. Everyone has bugs and MS released a patch for...

You can set a default database for each login. They will be able to see the other databases, but not access them, so I'm not sure what your concern is.

If...

MSDE is in house, but a custom strange install. The installer fails for SP2, so we just copied over the DLL. Doesn't seem to be a way to verify it...

Apologies, apologies. I have the network and infrastructure responsibilities for the site and we are working on it. We ordered a server and I spoke with FedEx this am (Fri,...

We had some weird MSDE installations that would not patch. Wouldn't install SP2. We had an MS engineer on site and they said that for the Worm, you can just...

Set server to manual and reboot or stop the server. Replace the DLL with one from the last SP and then restart. This registers on server startup. Stopping the server...

I follow something similar and Antares has great advice.

We exclude the mdf, ldf, AND ndf files. We then run backups (full and diff) to the local disk. These are backed...

Use DTS. I'd load into a staging table and then use T-SQL to do the work, but call it from DTS.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Is this SQL 2000?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Thanks for the complement. Actually I may have an opening in Denver soon.

New equipment is tough. One thing I've really become annoyed at with Compaq/HP is the...

Also, in the registry (classes_root|Installer) will be the product Ids, under each of these is the product name. You will see SQL Server Desktop Engine listed there.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

The SQL Service logs into the NT Domain (or machine) like any other user. Local system is a special account on all Windows servers. It can only access resources on...

Not sure and it's been awhile since I worked with 65. Usually this is some name resolution issue. Have you tried logging in as the SQL Service account and sending...

My first reaction is yes, you are lazy if you got hit. This patch has been out for some time, and there isn't a good excuse for not patching your...

If it's ad hoc, DTS. Regularly, use BCP.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net