another thought.

download a trialversion of redgate's SQL Refactor  Maybe it can help out.

maybe try ...

SELECT * FROM Table1

WHERE Description COLLATE SQL_Latin1_General_CP850_CS_AS 

    LIKE '%[a-z]' COLLATE SQL_Latin1_General_CP850_CS_AS

- open the query in query analyser and check for the estimated execution plan.

- how accurate are your statistics ?

(sp_updatestats / dbcc updateusage(0) with count_rows)

Then number of rows are...

- advised is to use the (small of needed) datetime format because of datatype and engine-handling.

- So in stead of querying CONVERT(VARCHAR(30),TRANS_DATE,101)>(@REPORTDATE) just use

    TRANS_DATE> convert(datetime,@REPORTDATE, 101)

The reason for...

actualy the engines are the same (msde has got some restrictions).

Concider it like running two instances of sqlserver. (cpu/memory/...)

maybe SQL Server Health and History Tool (SQLH2) utility from MS can help you out. (http://www.microsoft.com/downloads/details.aspx?familyid=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en)

FYI MS has this app called "SQL Server Migration Assistant for Oracle V3.0" http://www.microsoft.com/downloads/details.aspx?FamilyId=0E06A04C-D0C3-4F31-B201-FBE7C25F32FB&displaylang=en

Maybe this can also convert to sql2000

another thought ...

At freeze time, is it only the sqlserver instance that's frozen or is the whole server frozen ?

it's a pitty, but you'll need RDC or so.

this script also gives you the parameters.

exec master..xp_instance_regenumvalues N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'

You can configure a trace to run in background and wait for the issue to occur.

this script starts a script for a certain time and creates tracefiles of max 50Mb...

How about the service account name itself ?

We're testing service account names structured like e.g. SQL.DB.Servername.Instancename

This works except for Reporting server.

What are orther issues that point on using special...

Nice solution.

I've been using spc_random_password of Written by Narayana Vyas Kondreddi http://vyaskn.tripod.com  (Stored procedure to generate...

This happens when using a sql-user. Not with Windows authentication.

at "freeze" time ...

- are there backups running ?

- are rebuilds going on ?

- did you use sqlprofiler to capture the load

- how about deadlock situations (are startupparameters -T1204 and...

Open up Sql server configuration mananget.

Connect to your sqlserver-server.

rightclick your wanted sqlserver service, go to the advanced tab and check the startup propetries. The sqlerrorlogfile is specified with the -e...