Just what I needed, thanks.

do a search on Google for MsDtsSrvr.ini.xml you need to configure each instance.

Andrew

This is how I collect it, might work for you:

DECLARE

@value VARCHAR(64),

@key VARCHAR(512)

set @key = 'HARDWARE\DESCRIPTION\System\BIOS\';

EXEC master..xp_regread...

Presumably if the password in sys.syslogins is null then it hasn't been changed, and if not it has?

Also what is the password policy set to, wouldnt the corerect setting here...

was anything running on the OS that would have used up the 1 gig you have left for it, I have seen a sql instance running that had a non...

Scott,

Thanks for the reply. I saw this when I was doing a shrink, I was just curious as to what it was, I had an idea it was an internal...

I tell my family, and others, i make sure lists are available, I use a gym membership list as an example.

My first gig as a DBA I had many...

you mention having to update views, udf and procs after the table rename, why is this required?

andrew

Just wondering if you are suffering from power management settings as described in this post:

http://www.brentozar.com/archive/2010/10/sql-server-on-powersaving-cpus-not-so-fast/

On upgrades to new servers we noticed the clock speed was throttled and the...

I got this from the interwebs, can't remember where, just used it for a complex SSAS DB backup routine that had to stall cube build jobs if a SASS DB...

I believe I saw a powershell script that did it as well, can't remember if it was for packages stored in sql or not. Push comes to shove maybe you...

Where do you have the packages stored, if it is in SQL server you can update the binary data in sysssispackages, I had to do it for a migration of...

dont know where my head was, figured this out:-)

If it is a test server why not install another SQL instance, start it with the appropriate start up params to be bale to restore the master DB and restore...

we like to store our ssis packages in msdb and have SQL look after the security. To set this up so everything still works on a failover we edit the...