yes.

from the article -

It is important to note that...

mreizik (12/13/2010)

---

Great post,

is there any downgrade in performance when turning on the trace ?

Is it okey to use it in in system that use heavily on SQL db lets say...

alxdean (12/13/2010)

---

Although this is a very nice way of getting extra info from the error log instead of just sending out a notification message, I do not understand why you...

nice article Craig. one litttle thing you left out though;

you have to really enjoy working with the technology. as Confucius said, "Choose a job you love, and you will never...

Steve Jones - SSC Editor (12/8/2010)

---

well here you go then;

answer a question with a question i guess...

do you have deticated testers OR business analysis that require a TEST instance to actually test code in?

here is what we do;

DEV server...

i have run into these type of issues before. COTS products and 3rd party vendors are always the culprits.

the only thing i ever demanded was that for those types of...

nice question. thanks pramod singla

yet another GREAT spackle article. (Polyfilla for the people on the other side of the pond) 😛

thanks Jeff.

it may be related to the user defined in your linked server not having permissions.

does this work?

select * from openquery([ORCNOTNS],'select * from all_objects')

did you try sp_who2 ?

run sql server configuration manager and verify that the server is running.

agreed. they gave you the option to install SSMS on the newer versions, but not the Agent.

Hi cppp,

whatever account is running the VB Script will require access to your database DBA.

So, if you followed the instructions, that means your SQL Server agent account is running the...