Viewing 15 posts - 36,931 through 36,945 (of 49,566 total)
Hidden and not directly queryable. None of the system tables in sql 2005 or above are directly queryable.
Why do you want to know?
August 21, 2009 at 5:06 am
The error's not saying that the database is in single user mode, it's saying that the server is in single user mode.
So someone has started SQL with the -m switch...
August 21, 2009 at 1:49 am
Auto shrink should never be on, not on a dev server even.
Auto close can be of use for databases that are very, very seldom accessed, but it's a very...
August 21, 2009 at 1:47 am
Local system is essentially local administrator. Full permissions on the local machine. Network service is a resticted account that has enough permissions to communicate over the network, run as a...
August 20, 2009 at 2:29 pm
With only 180 or so rows, you've very likely got under 8 pages in that index. Very small indexes do show fragmentation after rebuilds, it has to do with how...
August 20, 2009 at 2:24 pm
A quick google search shows that wmiprvse.exe is not part of SQL Server and is unrelated to SQL server. You're probably better off asking this on a general windows administration...
August 20, 2009 at 2:11 pm
Does the account that SQL Express is running under have write permissions to the mdf file? Is it on read-only storage?
August 20, 2009 at 2:05 pm
Depends what kind of parameter sniffing problems you have.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
August 20, 2009 at 11:06 am
To do a many-to-many relationship in SQL you need to create an intermediary table.
August 20, 2009 at 11:04 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic774397-145-1.aspx
August 20, 2009 at 11:02 am
Want to apologise to the developers? 😉
August 20, 2009 at 9:47 am
Get to the config shown in image 2, drag object explorer as shown in this screenshot
August 20, 2009 at 9:35 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic774264-5-1.aspx
August 20, 2009 at 9:09 am
ALTER DATABASE <Database Name> SET ONLINE
As for how it got offline, someone took it offline either by issuing a ALTER DATABASE statement or by selecting Tasks-Take offline from the context...
August 20, 2009 at 8:46 am
You mean like this? (see attachments) If not, describe what the layout should look like please.
What are you trying and what's management studio doing when you try?
August 20, 2009 at 8:39 am
Viewing 15 posts - 36,931 through 36,945 (of 49,566 total)