I used to have the problem that if someone logged in and had no permission on the database, that they were moved to the default database without noticing. This...

I have never seen this, but maybe I know a workaround.

The logfile says it is installing the perfomance counters. What happens if you do not select those?

For what...

The plan counts actual days. I does not care if it had do something on a certain day.

You can not.

But there are workarounds of course.

1: Make a backup of the full database, restore it to a new database and just use the one table.

2: bcp or DTS...

I never tried, so you will have to test.

But I ran dependency walker on bcp and the only DLL, that was not part of the OS was c:\winnt\system32\sqlunirl.dll

There might be...

I you work on a stand alone machine, trust does not apply and neither does the domain\username format. The domain is the machine name.

What happens is you try to...

I am not sure but error 33 might mean that the file is in use. Can it be that some program is trying to backup the .bak file to...

Use a maintenance plan.

The maintenance plan backups add date and time to the file.

I assume you mean the following error:

Error 945

Database '%.*ls' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details

and...

Are you using a Domain account from a domain which does not include your machine and does not trust your machine. In that case the account can not be...

Look in the STEVENW.ULTIPRO_USG.PRV script. You will probably find it in the C:\Program Files\Microsoft SQL Server\80\Tools directory. I guess you will find an error on line 1447. ...

Great article.

Can you tell what to do with the resultset of dbcc sqlperf(waitstats)

I saw that it is accumulative, so you have to take the up time into account.

But what is...

If you let the backup log to file, the file logs every next 10% of the backup made.

There is no performance reason to split into may databases per se. If your tables are very big it might be usefull to split the tables (and put them...

I never saw this error before. In general the number of locks in SQLServer is dynamic.

Here to look at the locks and maybe change it with sp_configure.

Locks in...