another nice ref regarding impact of shrink operations :

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

there are serveral ways to shutdown sqlserver:

- service manager

- TSQL : Shutdown

- net stop sqlserver

- EM rightclick servername / stop

They all shutdown sqlserver.

If there are open transactions going on (They...

... Is it necessary to maintain the production relationships in the first place ...

- maybe not the actual FK's , but certainly keep the FK-indexes because They will speed up queries...

- 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

-...