I just had the same issue, Had to do lock pages in memory (918483).

Fixed the message i had

Thanks for the additonal information.

Thanks for replying. Is about to do the same here.

I guess i have to just move the model, master, afterwards..

As it all got installed on C....i tried to move...

Did you manage to get everything installed on D and nothing on C if so could you share.

This was on a restore from SQL 2000 to SQL 2005 everything was checked then few weeks later appeared the corruption.

This is the first time i seen corruption on a...

hi there i am changing all my NT Accounts to a new domain\username.

Do you have a script for SQL 2005 that would generate the creation.

So if i have olddomain\username that...

Just out of curosity is it best not to do reindex on master, model, msdb tables.

i know the reindex update statistics.

When do you think it is best to run the...

I found it, i had to drop all the indexes before i did a major conversion of the database, then recreated the indexes but did not put back the fill...

Put the SQL Profiler on and your capture every single piece of code they run select, insert update.

Quest Spotlight the first one they brought out was advised only run for small periods of time.

The latest one is the enterprise which is for 24 hours.

SQL Litespeed is generally...

Here are some here

http://www.sqio.com/

Click on the SQLIO i used this one.

I done this on Production and Test but at hours when no one around. You will need...

Get the company to invest in Quest Software probrably the best software i bought for SQL.

I can see the entire status of the database in a graphical display from CPU,...

What is embedded SQL.

Most of the developers will be testing their databases and applications.

Major ERP system is from outside companies that provide upgrades for the SQL 2005.

We will be testing...

Thanks for clarifying

I was looking at the statistics on a table.

Created one table

DECLARE @COUNT INT

SET @COUNT = 1

WHILE @COUNT <= 1000

begin

insert into CUSTOMER (CUSTOMER_ID, CUSTOMER_NAME)

VALUES (@COUNT, '12345678901234567890')

SET @COUNT = @COUNT + 1

END

Table...