You could put the database in single-user or restricted-user mode using database options (see BOL, Database Options and find State Options to see which would work best for your situation).

Don

Don't forget to check your client network utility (C:\WINDOWS\SYSTEM32\cliconfg.exe) to make certain the installation of SP2 didn't disable the network protocols.  At least TCP/IP should be opened and I'd open...

The advantage of getting the certs is that you demonstrate a willingness to learn everything and anything you need to learn for the job.  I agree with John, I wouldn't...

One issue there is that the apps probably have their passwords hardcoded somewhere, so changing the passwords in SQL Server would probably render the apps inoperative.  The apps themselves should...

I encountered a similar problem recently.  The solution was to stop SQL Server and delete the physical files (mdf & ldf) then restart SQL Server.  In this case, SQL Server...

A third option is to open the Access DB and link to the appropriate SQL Server tables then use queries to move the data.  This is especially useful if you...

If this is an existing MSDE installation you can go into the registry to key HKLM\Software\Microsoft\MSSQLServer\MSSQLServer (or the instance) and find LoginMode.  Change this to 2 then stop and restart...

Just to toss in another 2 cents, if anyone is using an XP machine as a server running MSDE (some of my clients do it in a Novell environment), they...

It is my understanding that SP2 disables the network protocols, too.  You will need to enable them on the server using svrnetcn.exe as well as enabling the ports on the...

Check the registry, HKLM\Software\Microsoft\MSSQLServer\MSSQLServer (or instance name).  Look at the data in the LoginMode.  If it is 2 you are using SQL Mixed Mode, otherwise you are using NT Authentication.

Don

Hi, Elsa.  You are looking for C:\WINDOWS\SYSTEM32\cliconfig.exe.  When you find it, check the Version tab on the properties.  That will tell you the version and most other info about the...

I don't know about earlier releases, but you CAN install MSDE Release A as either a default or name instance.  I do it all the time.  I don't know about the way...

Hello, all.  I don't know if this has anything to do with your experience or not, but here goes.  When I am in SQL Server Enterprise Manager and I leave...

Hi, guys.  Those are all great suggestions.  We had already installed MDAC 2.8 (but there's an idea - I need to check the registry entries to make sure they are...

Setting aside the typo, I answered None of the Above as being more correct than No row is inserted.  I read it twice looking for the trick, but concluded None...