DON'T DO IT ! At least not with a trigger !

What if "the other instance" goes in maintenance, your "primary" instance will nolonger work because that trigger will fail !

If...

- disabling tcp\ip for that instance may get you to it !

- follow "Moving the MSDB database" in this KB-art : http://support.microsoft.com/kb/224071

- this may also help out: http://www.sqlservercentral.com/articles/Administration/2605/

2 x yes

Check out "The Art of XSD" by Jacob Sebastian in the Books section of SSC !

did you check Books online (BOL) topic "Starting and Restarting Services" ?

http://msdn.microsoft.com/en-us/library/ms190917.aspx

to early for homework 😉

it are table aliasses.

a pointing to syscolumns

b pointing to sysobjects

They are only valid for that specific sql statement.

Books online (bol) has more info. http://msdn.microsoft.com/en-us/library/ms187455%28SQL.90%29.aspx

btw I always...

You cannot have multiple logins pointing to dbo !

In most cases, we have 'sa' mapped to dbo.

sp_changedbowner @loginame = 'sa' ,@map = 'true'

User 'sa' is never used by applications and...

- what kind of trace file are you refering to ?

(If sqlserver trace files, which events does your trace capure ?)

- you could implement a DDL-trigger to keep track...

helpmhost (8/24/2009)

---

I tried again today. We have the auto-shrink property set as well, so today the Initial size of the data file was significantly less. I also added a second...

Check the security settings if your package AND of your IIS.

If the package is configured to use SQLAuthentication (SQLusername and password), it should run fine if your IIS has the...

Keep in mind that if auto update statistics is on (on by default) there will be other incentives (usage driven) that cause this auto update process to update the statistics.

there are couple of SSC articles and scripts that should get you started :

http://www.sqlservercentral.com/scripts/31857/

http://www.sqlservercentral.com/scripts/Rebuild+Index/65933/

http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/

http://www.sqlservercentral.com/articles/Administration/createmaintenancejobwithaclickwithoutusingawizard/1102/

Just search SSC on "rebuild index" and the search result will show # of results.

You can use...

- With x64 you should always set your max memory config for each instance or they may eat up all your memory !

- Are the 3 SQLServer instances the only...

Indeed ... some times we overlook the obvious. :hehe: ( been there .. done that 😀 )

Happy mirroring 😉

Lower the autogrowth number of MB !

Seems to me your OS is having...