The Isnull method cannot be more efficient.  Anytime you have a function on a column (in a Where clause from Join clause), the query must scan the table and evaluate...

Is your SQL Server instance running under this updated Windows XP?  Or are you just running Enterprise Manager on XP connecting to SQL Server on a server?

If you are running...

I'm tired of lazy arrogant application developers who won't consider how to run with less permission than system administrator.  I just had a major blow up with an internal...

No, I had not thought of that.  I did that and it worked.  Thanks, Steve.

If it is any help, I also get this specifically when I click the link in the newsletter for the answering the QOD.  The page will come up "Please Login",...

Actually Steve, they have virtual images for almost all products, even Visual Studio.  https://partner.microsoft.com/US/40016111?PS=95000140  It is under the partner program, and you have to be a certified partner to get...

Yes, and I said it will usually work.

But not always. You do not have any guarantee that in between the execution of the Alter database statement (putting it in single...

Yes, that will usually work better.  But you still have to be prepare to lookup and kill a connection that might have snuck in. 

This was the problem with SQL...

But you are trying to save yourself a little work now (not creating these tables) and causing all your queries...

I believe that using a "IsDeleted" column is not usually a good solution to the issue of keeping "deleted" records.  It clutters up the "active" table, and usually requires too...

1. Use SP_Who to find the session ID of the active connection to the database
2. Use KILL <session id> to terminate the connection.
3. Then do the Alter Database command you tried.

Hope this helps

You don't specify what language you are using (.net or not? vb? asp?). 

• Assuming that you are using ADO (and not ADO.Net), you can use Seek method in combination of...

Regarding using this technique in an ASP environment, I would perform some additional testing.  I'm not sure how Context_info applies when using connection pooling, but either way would appear to...

You may want to check to see if there are disk quotas defined on the server.  In one instance at a client's server where autogrow failed, network admins had just...

There was a web version from Microsoft, specifically for managing MSDE versions. 

Updated: 11:48am:

See Web Data Administrator

http://www.microsoft.com/downloads/details.aspx?familyid=f0d03472-5e6c-459e-a6d8-6745a729c3c9&languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylang=en

It's not much there.  But it will let you create databases, create...