I'm sorry, but I don't understand what you're trying to do. Why do you think you need to use a variable, and why do you set a value for...

I don't understand your question. What is ALL ERRORS? If you want to capture failed logins, do as I suggested. Are you saying you need to capture...

I think you're looking for the Audit Login Failed event, under Security.

John

Yes, I am, and to be honest, I'd be surprised if I saw what you're seeing. I wish I knew how you do it!

John

I've taken the liberty of tweaking so that it doesn't get fooled by non-alpha characters.

Code is posted as an attachment since it timed out when I tried to post in-line.

John

I get the same results for both examples. I can't see how putting in a GO will make any difference.

John

Vijay

Does your database have a case-sensitive collation?

John

Are you sure Example 1 works? This is what I get:

Value Seq

1011

1011

1021

1021

1021

1022

1031

1041

1041

1041

John

"It won't work" is a little vague. Please post any error messages you get, or show how the results you get differ from those you expect. Table DDL...

When you say you couldn't find anything in SQLAGENT.OUT, do you mean you couldn't find SQLAGENT.OUT at all? If that's the case, the reason it's failing to start is...

This should help:

http://msdn.microsoft.com/en-us/library/ms174979.aspx

Let us know if there's anything in particular that you don't understand.

John

If this is a one-off, you can create the function in tempdb. Or...

If you want to join to the results of a table valued function, use CROSS APPLY or OUTER APPLY. Please post DDL, sample data, results and expected results if...

Please can we have a CREATE TABLE statement for Table1, sample data in the form of INSERT statements, and what results you expect to see.

Thanks

John

You could wait for Jason to come back to you... in the meantime, have you tried my solution?

John