Viewing 15 posts - 44,446 through 44,460 (of 49,571 total)
You can set the max memory for SQL under the server properties. If you don't set that, SQL will take as much memory as it can.
September 18, 2008 at 4:39 am
Duplicate post. No replies to this thread please.
Replies to:
http://www.sqlservercentral.com/Forums/Topic571604-145-1.aspx
September 18, 2008 at 4:36 am
Chirag (9/18/2008)
September 18, 2008 at 2:13 am
Thanks James
That kind of comment is what makes it all worthwhile.
September 18, 2008 at 1:54 am
Have you looked in Books Online. There's a fair bit in there. Look under ALTER INDEX.
September 18, 2008 at 1:50 am
Check that the database you're running it in is in compatibility mode 90.
September 18, 2008 at 1:49 am
Duplicate post. No replies to this thread please
http://www.sqlservercentral.com/Forums/Topic571498-147-1.aspx
September 18, 2008 at 1:43 am
Please don't cross post. It just wastes people's time and fragments replies.
Answered here:
http://www.sqlservercentral.com/Forums/Topic570887-145-1.aspx
September 18, 2008 at 1:43 am
Then there must be something different about the databases that are on SQL 2000 and the databases that are on SQL 2005. The thing is, the error is saying there's...
September 18, 2008 at 1:34 am
I think you're going to have to restore it from a backup. SQL won't run properly without MSDB and, since it's a system database you can't just drop it.
I'd seen...
September 18, 2008 at 1:24 am
Stef (9/17/2008)
September 17, 2008 at 2:01 pm
September 17, 2008 at 2:00 pm
SQL 2005 requires a password to be entered during installation if mixed mode is selected. It doesn't set a default. There's no practical way of decrypting the stored passwords
September 17, 2008 at 1:59 pm
TRACEY (9/17/2008)
Thats good the index statistics check..getting names called
clust
NULL
clst
nc1
nc2
is it possible to get table also printed out.
Sure. Add o.name to the select clause
September 17, 2008 at 1:57 pm
You don't need to drop it before restoring, and I don't think it can be deleted.
Here's an msdn article on restoring MSDB
http://msdn.microsoft.com/en-us/library/ms190749(SQL.90).aspx
Before trying all that, try just running
RESTORE DATABASE...
September 17, 2008 at 1:53 pm
Viewing 15 posts - 44,446 through 44,460 (of 49,571 total)