|
-
August 12th, 2010, 01:40 PM
#2
Re: connect to SQL server 2005 with more then 1 user?
Try this:
ALTER DATABASE yourDatabase
SET SINGLE_USER
GO
EXEC sp_dbcmptlevel develop, 90;
GO
ALTER DATABASE develop
SET MULTI_USER
GO
I haven't tried this with Express but it works for Enterprise. First try just using the Second go block. If that doesn't go well then try the whole block.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|