Re: SQL2005: Running TSQL commands in single-user mode

Mike (huttm@xxxxxxxxxxx) 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@xxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: Exclude Identity Columns to copy rows?
    ... generate the column list if you use Query Analyzer for SQL Server 2000. ... open up the object browser with F8, find the table you want to insert into, ... thing you have to do then is remove the identity column from the list. ... "Jim M" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Any good, free tools for writing simple stored procedures?
    ... I use SQL Server Query Analyzer most of the time. ... but it does have a debugger, object browser, scripting, graphical query ... from the object browser into the editing window. ...
    (microsoft.public.sqlserver)
  • Re: Invalid Object when two users with same named table
    ... > Because I can't see my posted message I'm repeating it. ... > At the top of Object Browser I can see 'NameOfServer'. ...
    (microsoft.public.sqlserver.programming)
  • Re: Delayed Code Execution?
    ... threaded timer, and I am now feeling that this is not the best ... Use SQL Server Service Broker queueing and do ... Dim objTimer As System.Threading.Timer ... I also noticed in the object browser that there's System.Timers ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to access SQL Server 2005 with Query Analyzer (SQL 2000)
    ... Query Analyzer does not fully support new SQL Server 2005 features. ... it does not recognize schema names in the Object Browser. ... > SQL Server databases use the concept of schemas. ...
    (microsoft.public.sqlserver.clients)