I'd say that would be good.

How mutch is SQLserver actualy using (task manager) ?

If sqlserver has not enough memory, it has to swap and _that_ may be what's strangling you.

In...

SSIS/Bi-dev studio :

- now they can build packages in a way programers should be used to, debug them and implement them into SSIS like one would implement a program.

-...

-- 1204 Returns the type of lock participating in the deadlock and the current command affect by the deadlock.

-- 1205 Returns more detailed information about the command being executed...

- don't forget to mention the scripting capabilities of SSMS / SMO.

- solution-oriented (cfr VS2005) script libraries

- enhanced (out of the box) templates

- XML datatype and XML-schema-binding !

- XML-docs for...

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