Hey daveriya!

What are you looking excatly can you be more specific?

When you say handling update to SQL Server using CDC, its all about auditing the table are you looking for...

There won't be performance addon by seperating Insert and Update trigger as both will run on initiation of specific action. If one transaction running the insert operation you cannot run...

Yes I did that is why i made my statement bold in my post. Even when I am trying to use Network Services / Local System account its throwing the...

Audit triggers are basically an unavoided way of hadling the audit right from earlier versions of SQL Server. There are always pros and cons from performance point of view when...

YOu can use the CASE statement to get the column based data.

you can leaverage the dynamic management view to check the inactive users.

ORACLE & Microsoft SQL Server are certianly two different platforms, specificaly rivals 😛 (jk).

Everyone can direct you on specific database system. Both are user-friendly, both are easy to learn. I...

probably you should frame your question in more explanatory way.

How to post forum questions[/url]. -

EXISTS operator only works with single SELECT statement. In your case it will work as mentioned below..

if exists(select * from t1) or exists(select * from t2)

begin

select 'xxx'

end

Here is the another code snippest to write Server Side Trace

http://abhijitmore.wordpress.com/2010/03/11/creating-custom-trace/

Well, there is no such differentiation between returning the XML as OUTPUT or in SELECT, it won't make any difference in OUTPUT size. It 2 GB max in either case.

Here...

Thanks I got the solution earlier.

nope I am finding out the ways we can beat the Operators.

Indeed I agree with you Gail, there is no meaning is testing the query w/o data. Thats my bad.

and Thanks for adding sample data, I'll appreciate it.

Okay! now my question...

Can you elaborate more what exactly yu are trying to do?