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...

if you are using the GUI, you have an option to install a new instance (so not upgrating the existing instance of sql2000)

maybe just some CPR

split the updatequery in chunks so it does not lockout the whole of the table (unless you realy need the...

after you've added the roll to all existing user-db, also add it to model database.

that database is used (copied) to create every new db !