I am on default Instance

Yes i did after i checked mark that option

Hi

I am working on same error and have check mark the "Replace tokens for all job responses to alert".

but still when getting same error " WMI(SQLInstance) not...

Backup all user Database

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

DECLARE @fileDate VARCHAR(20)...

Awesome I added your script with SP and works fine.

Just one concern about to use xp_cmdshell in production servers is good?

Hi

How i can get all remote servers IP add and host name ? you have any updated script?

You can find here the newer one

http://www.sqlservercentral.com/scripts/sp_who2/72823/

Very helpful information....

I always read that use about trace flag but didn't find info about how to check it's output.

Did you able to solve this error?

let me know kindly please?

the reason i am asking because when i went for exam 70-448 there was a 55 questions and i was told by and hoping for 40 ques only.

Congratulations Emmiejames...Can you tell us how many question they ask now in this exam?

very helpful..

great effort..keep it up

thanks for helpful replies...

and wonderful book written on sql plans..thanks for share..

I like the format of this exam ,It covers diff exams from windows server also . that why i am interested to go for this exam.

anyway thanks for...

Thanks for nice video Link very helpfull..

I am looking for MCDBA certification path with SQL Server 2008 Certification. I did pass MCTS SQL 2008 . so to be MCDBA...