use SQL2005 SSMS and you'll find it very usefull.

copy/past keeps the colors

the SQL-prefixed ones are collations used by sql2k.

Aparently MS did some optimisations for unicode handling with the new collations.

- Only performance factor i read about is for...

there is a chance someone else will get into the db during the time that you switch sessions !

Executing the alter and restore in a single batch avoids this risk...

just to add to John Rowan's reply :

- With alter database, only new created objects will use the new collation ! Existing...

perform in a single batch :

ALTER DATABASE yourdb Set RESTRICTED_USER , READ_only WITH ROLLBACK IMMEDIATE

Restore database yourdb from .....

Was there a backup job running at the time of crach ?

Check the backup job for errors (e.g. filecontention /directorycontention of the backupfiles may cause a servercrash with sql7)

From sql2000 books online :

Calling User-Defined Functions

When calling a scalar user-defined function, you must supply at least a two-part name:

SELECT *, MyUser.MyScalarFunction()FROM MyTable

Table-valued functions can be called by using a...

Is there a view with the same name ?

Objectnames must be unique within a schema.

some do it checking how many clients at a certain point in time are connected to the server and comparing that number to parameter-value stored in the db or registry.

This...

First of all you'll need a full db backup !

After that, you can perform T-log backups. Keep in mind you'll need the set (logbackup1, logbu2,...) to be able to restore...

the transactionlog wil only shrink if the active block is at the beginning of the trx-log file !

So you may have to repeat this sequence until you succeed !

-- getest...

- can you connect to your access db using the 64-bit odbc ?

%SystemRoot%\system32\odbcad32.exe

- can you connect to your access db using the 32-bit odbc ?

C:\WINDOWS\SysWOW64\odbcad32.exe

btw I also noticed the copy...

- are you connected as sysadmin / dbo / tablecreator ?

- which schema did you specify ?

Because also some (??) production applications were suffering this unavailability, I faileover the instance and everithing worked back just fine !.

After reboot of the node ( because all instances of...

you can also use ##-temptables (#-temptb = local temp tb, ##-temptb = global temp tb).

You can create normal tables in tempdb, but I wouldn't advise to use it because when...