We overdid the separation a few years ago and tend to integrate databases back into larger ones (from 35 to 3) except data from foreign sources. The main reason is...

Also thanks for the sqlprompt bundle. Enjoying the site everyday.

It is still a tricky matter since administrator's can do everything. (shutting down service,...)

My current solution:

*Sqlserver run under an administrator account "blabla" different than "administrator"

*Blabla added it to the sql...

The computername wasn't renamed in the past?

The securitydescriptors in master can be out of sync with a restored database. If you look in a database the login for a certain user is Null instead of user...

I...

sorry, a bit in a hurry.

check if your scripts fetches all data and are not holding transactions.

You might check this one out

http://www.sql-server-performance.com/deadlocks.asp

Because cursors indicate a row-by-row (if this row contains ... then I'm not interested) logic whilst sql server is optimized for set-based logic (give me all that have the value...

Odd error.

What happens if you run the select at line 53?

DECLARE @dbname sysname

SET @dbname=NULL

select name, suser_sname(sid), convert(nvarchar(11), crdate),

dbid, cmptlevel from master.dbo.sysdatabases

where (@dbname is null or name = @dbname)

Which...

Try to have the application/situation run at a machine for monitoring its performance against a known setup.

http://www.sql-server-performance.com/gv_baselining_tips.asp.

also check this out:

http://www.sql-server-performance.com/sql_server_performance_audit3.asp

nobody?

Also a great change from SP3 to SP4 is that the datatypes have to match in order to use an index.

*found the link

http://support.microsoft.com/default.aspx/kb/899976

Haven't used analysis yet. Have you rebooted the machine(s)?

I can be because of parallel processing/fetching.

Have you also downloaded the analysis service pack 4? It comes in a separate package.

see

SQL2000.AS-KB884525-SP4-x86-ENU.EXE (analysis service pack)

and

SQL2000-KB884525-SP4-x86-ENU.EXE (sql server service pack)

at

http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

Have you tried starting sql server from the command line

with the

-dmaster_data_file_path

-lmaster_log_file_path

-eerror_log_path

parameters ?

example :

sqlserver.exe -dC:\MyNewDBLocation\master.mdf -lC:\MyNewLogLocation\master.ldf -eC:\MyNewErrorLocation\ERRORLOG

Since L & E seems to be unavailable (see event viewer)