simple script, but should give you the results...

select name,

database_id,

user_access_desc,

state_desc,

(CASE is_in_standby WHEN '0' THEN 'NO' ELSE 'YES' END) as Is_in_standby,

GETDATE() as time_stamp

from sys.databases

SQLSeTTeR (7/1/2010)

---

My production SQL server restarted itself last night. Any ideas on where I can get some more information regarding the below error message?

SQL Server must shut down in...

I really don't think it's such a major transition, there are a few extra features, discontinued features, but the biggest difference in versions are in BI.

Do the training to get...

SHUTDOWN WITH NOWAIT

dy265 (6/30/2010)

---

I am using the sp_dropserver and sp_addserver command but I really don't understand what it really does other than dropping a server and define a server, like if these...

Server, or SQL Server?

You can...

This is an undocumented script like SP_MSForEachTable...

Try:

exec sp_msforeachdb @command1='ALTER DATABASE ? SET AUTO_UPDATE_STATISTICS ON'

Good tricky one...thank you

I agree Steve, that 2nd England goal should have been awarded...but overall, the German's were much better.

England's defense was non existent, attacking lacked aggression.....

Basically, Germany still outplayed them.

Yes, definitely a good career choice.

MS SQL will always be in demand, it's an excellent product, easy to manage, and capable of doing great things. (no, MS didn't pay me...

Here is a good script...credits to the authors...

/****************************************************************************************

NAME:DATABASE I/O STATISTICS

BY:MARK JONES

DATE:19-02-2008

PURPOSE: Provides useful statistics about Database I/O requests. Uses the function

::fn_virtualfilestats to retreieve all the database file statistics includeing

...

SQL will allocate as much memory as needed/available.

Configure your maximum memory allocation within SQL, leaving adequate memory for the OS and other services.

On a 16gb server, I'd configure SQL to...

on both sides? (source & destination?)

You still didn't provide any sort of error messages...

Schadenfreude-Mei (6/23/2010)

---

CirquedeSQLeil (6/22/2010)

---

GilaMonster (6/22/2010)

---

What a surprise. Not.

At least we didn't lose every match...

At which sort of step are your packages failing?

Using any authentication within these specific packages?

As what are you running these packages under the agent?

Error messages?