|
|
Posted by Erland Sommarskog on 12/21/07 22:29
Mike (huttm@yahoo.co.uk) writes:
> I used Management Studio to connect; but when you go in you mustn't
> connect straight away as the object browser maintains a SQL connection
> (no idea why it needs to).
Well, if it did not have that connection, how do you think it would
be able to display the contents of databases etc?
If you don't want the Object Explorer on startup, you can change that
under Tools->Option, on the General page.
> 2007-12-21 11:49:40.37 spid9s Could not create tempdb. You may
> not have enough disk space available. Free additional disk space by
> deleting other files on the tempdb drive and then restart SQL Server.
> Check for additional errors in the event log that may indicate why the
> tempdb files could not be initialized.
That doesn't look good. When in single-user mode, have you verified
that the path for tempdb is good?
Also, if you moved the files to the new place, make sure that they are
not read-only for the service account for SQL Server? You could try
deleting the files - SQL Server will recreate them anyway.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|