My worst DBA Whoops was when I had copied a productive database to the training environment and somehow forgoten to check the documents share directory in the settings table of...

Hi Steve

Hope I got this right. So you basically use a statement like this:

select top 5

o.orderid

, o.customerid

, CONVERT(char(10), o.requireddate, 101) as converteddate

from orders o

order by requireddate desc

Which will result in the...

Hi Jamie

Your script does list the internal ID, but not the ID used in the Jobs section of EM.

Regards

hot2use

The correct syntax is:

osql -SWIP-7ADLZFDZW -E -dmaster -Q"sp_msforeachdb @command1='print ?'"

Double quotes around the SQL command line query and single quotes around the @command input.

Regards

hot2use

Even if you are using a Select CD you stil need to decide which licensing version you want to use. And this normaly is reflected when querying serverproperty(licencetype).

I've got a...

Sorry, I forgot to write that autostatistics were already turned on.

Here the results for the sp_dboption on the database itself:

The following options are set:     ...

BOL states that if you don't specify the index in the DBCC SHOWCONTIG command, that it then uses the base index to report results. Your first example queries...

Well logically, after looking at my sysperfinfo table, I'd say that your sysperfinfo table is ok. You might not have enough permissions to insert new counters, alerts, etc.

Dumbass me... Should have known better:

"If you can't find it online, search for it in BOL".

Thanks for pointing me in the right direction again.