ok, thank you veru much

"The problem is if you rebuild your on a regular basis it will be slower if you keep shrinking the log file as it will have to grow with each...

I have been testing and you can not....

e.g:

I have made a backup from a SQL Server 2000 database and restore it on a SQL Server 2005 engine.

I didn't changed the...

I just call you master because of your knowledge.

But i will start to call you, for your name.

Thank you very much for all your help,

Pedro

sorry didn't undestud your point?

what did you mean?

tks,

Pedro

p.s - my question was :

Did anything changed in terms of Bulk insert from SQL server 2000...

Ok master,

One last check please, to validate if this part is correct:

My script (to convert the DB from 2000 to 2005) will include this two cursors:

use db_name

go

set nocount on...

yes, that part of statistics i understud after you explained.

But in this case, what i was asking was another thing:

e.g:

if i do a comand like :

...

ok master,

But in this case, what i was asking was, what types of objects have statistics and i have to update?

Shoud i update statistics for all the...

Ok master Gail,

In that case i will just use the command like this:

UPDATE STATISTICS table_name WITH FULLSCAN

Should i update only tables statistics? or should i update every table and...

Thank you very much for reply master.

I have seen your recomendations and i want to apply all to my script that will convert the databases to SQL Server 2005.

As to...

yap, i know.

Auto_shrink has no advantages.

But what i need to know is if there are any differences between a database that as auto_shrink in SQL Server 2000 and a database...

can someone help please?

thank you very much

this :

EXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90

resolved the question.

thank you

ok, i will trie to use this tool to see the SPN.

I have made the query below in the query window and the result returned was:

select auth_scheme from sys.dm_exec_connections...

I have configutared using CM. for SQL Server 2005

For SQL Server 2000 i dind't because the services of this named instance are not in the CM