- there are # articles at SSC and sql-server-performance.com

- Keep in mind you need to determine criteria for databases to be hosted in an instance.

e.g.

- how/when will you be...

maybe this script can help you a bit :

I used it to convert primary keys to be clustered.

So just exclude the drop/create primary key part and off you go...

maybe this can help a bit ...

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

... forgve me ...

No problem. The goal of this usergroup is to help each other

AFAIK they do behave the same for sql7 and...

aha, the mystics of dbcc opentran

We learn every day ....

"Learn to play ..... play to learn"

the sqlserver logfile is used with active chunks.

The log-file(s) can only be shrinked up to the point where the active chunk ends. It that is the beginning of the logfile,...

fortunatly it happened on servers that could be rebooted at least every weekend, so if the problem occured, we planned a reboot asap.

Is this on a clustered server ? (xp_sendmail is not supported on a cluster)

We've also had this kind of issues with xp_sendmail and are now using smtp-mail (check Gert Drapers...

you may need to repeat the procedure until it shrinks.

 http://www.support.microsoft.com/kb/256650

-- select db_name()

-- select * from sysfiles

USE     Your_Database_Name              -- This is the name of the database for which the log...

upgrade ??

according to bol sys.sysfulltextcatalogs is for backward compatibility only.

Did you check sys.fulltext_catalogs ?

just to add ...

if you're using parameters in your (dynamic) queries, make sure they match the datatype and length of the corresponding columns in the tables !

- first of all run the SQL server 2005 upgrade advisor (the is an article on it at SQL Server 2005 Upgrade Advisor&nbsp

-...

I always use  DBCC updateusage ('myDatabase')   with count_rows

and I run sp_updatestats afterward.

1) what kind of problems did you experience ? (did you sql-backup the old db and restore it at the new server ?

2) Users are restored if you restored masterdb....

the 8.00.818 is

you can upgrade from sp3 and sp4.

There shouldn't be an...