PARSENAME looks cool for IP ADDRESSES and for this particular case may be useful it is an example on how to use a simple function for uninteded purposes!

I would add to that to check for errors using ON ERROR RESUME NEXT and checking the ERR object to make sure you never loose the control!

you should have a final and an initial steps

The Initial should findout how many files in total and save that in a global variable.

The final should check for the the...

Select Cast (0.01*(Select Count(*) from table1 where YourCondition1)/(Select Count(*) from table2 where YourCondition2) as int )

I am glad you solved the problem even if I still could not figure out why it wasn't working?

SOrry for this late reply I am very busy 😉

XP_READMAIL is what you could use to read the body an the mail is sent by the SQL server AGENT Alert!

I...

I look closer to your query and you should

replace '' for " like in:

quote:

---

SELECT *

FROM OPENQUERY

(

ADSI, 'SELECT Name FROM...

You don't need to have SQL on the Comp0005 box.

If you are using Win Auth. Make sure the SQL server Account has the "Account can be trusted for delegation" checked...

even if you know it will be lauchend 10 times for the same alert it won't help running the job over and over.

One solution maybe create a table with the...

Try Osql

This is what BOL says about SET TRANSACTION ISOLATION LEVEL

quote:

---

Only one of the options (ISOLATION LEVELS) can be set at...

The Problem you are dealing here is call account delegation.

If you use NT Authentication to connect to your first box you have to use KERBEROS, make sure you set...

1- use odbcping from the clients and make sure the account can login.

2- Check Client Network Utility and Server network utilities to verify both are in synch

HTH

are you using Windows Authentication?

1- You should try SQL Authentication to connect to the SQL box.

2- Map the Sql User To the Account you authorized on the Linked Server Proprties

and...

- First Disable the Alert That Launched the job

- Then check the Delay between responses that your Alert is setup with (That may be your problem).

- Then Manually Stop the...