Also using mm/dd/yyyy as dateformat is risky since it could be dd/mm/yyyy. Safest way is to use yyyymmdd

Permissions needed (from the books online):

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are...

What servicepack does the Access97 have, SP2?

Hello,

Did you get an error message?.

Moving one database to another:

Possibility 1:

Detach database from source server, copy files to destination server, (attach databases back at sourceserver),attach database at destination server.

Possibility 2:

Backup...

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