- First I would go for an extra sp_updatestats and dbcc UPDATEUSAGE (0)

- Do you also have a clustering index ?

- wich version of sqlserver are you using ?

-...

Great

by the way : http://www.geocities.com/SouthBeach/Lagoon/9819/acronyms.html 

AFAIK = as far as I know

When you install sql7 there is a window for the charcterset/sort order/collation selection.

There are checkboxes to set case-insensitive,...

Check out http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsql7/html/sql7install.asp

Maybe this reply is a bit late

I'm using logparser to import print-event-logs to a sql-table.

Once imported, a transfer-script to the proper table is...

AFAIK in SQL7 this calls for a reinstall / rebuildmaster at least. 

_and_ recreate all userdb and import all data again  

I cannot help with PB

This reply was meanth to be supportive for you to get approval for the app-maintenance-effort. 

just my 2Ct

Rule no 1 in _any_ RDBMS : tell your system what you know ! If you know it's an integer, don't declare a decimal , if you know...

this should get you on track :

    'script de database

    Dim oDatabase As SQLDMO.Database2

    Set...

What kind of diskdefinitions do you have ?

san / nas / other ?

did you take a look at

- http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

- http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp

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

my 2ct

- did you stop and restart sqlagent _after_ you enabled the (first) alert ?

- also add traceflag 3605 for more deadlockinfo in the sqlservereventlog.

- you could go for N(var)char solutions and avoid collation issues.

- if you're using a database per collation, _all_ interdb stuff has to perform collation translation to be compatible. Check...

great way to proove there is always more than one way to skin a kat

"...create table link (

    recno int identity not null,

    recno1 int not null,

    recno2 int not null,

    objectno varchar(255),

    :

    :

    :

    modified_date datetime null constraint [df_link_modified_date] default...

If they remain at the same path, there should be no issue if your sqlserver is at exactly the same version/sp/hf...

Just perform the rename-server procedure :

-- (http://www.databasejournal.com/scripts/article.php/1496451)

Create proc uspRenameServer...

If you've installed with the same drivemappings/locations, there should be no problems, if you move all db-files to these locations (as they were at the "old" server).

Otherwize, you may have...