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.

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed.

Same problem here.

Database Maintenance Plans are all failing to run and return the above error...

We had the same problem as Ross was having. Stopping the replication and rebuilding the transactional replication for the single table didn't work.

At first I tried running the sp_repldone with...

I mean hey.... No Backup?

I'd fix that "hole" pretty fast.

Try this one for starters.

Has some other great SQL Tools.

http://www.red-gate.com/SQL_Compare.htm

🙂