It looks like the Extended events for tracing are a new addition in 2012, does the following link help? http://msdn.microsoft.com/en-us/library/ff878264.aspx

Dave

Peter,

Lynn is saying after you've done the UNION you can encapsulate that query within a CTE (Common table expression) http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx.

I think this is what you want

WITH AllViews AS

(

SELECT DATEADD(dd, 0,...

This will do what the OP requested, but highly unlikely it matches the real requirement, poor specification = poor solution:crying:.

select SUBSTRING(Column1,1,2) as col1

,SUBSTRING(Column1,4,2) as...

Maybe the OP wants to use something like the MERGE statement http://msdn.microsoft.com/en-us/library/bb510625(v=sql.100).aspx

Dave

You have declared a variable called @MyCount, but your Dynamic SQL is using a variable called @MtCount.

Dave

The link you provided is pretty old and some of the links are no longer active. OBA is an acronym I'm not familiar with, but I did find this

http://blogs.msdn.com/b/steve_fox/archive/2008/04/15/create-your-first-oba-part-1.aspx

it's the...

What is preventing you from running this (DBCC CHECKDB)?

Is it you have no maintenace window, or something else?

Dave

Gail,

Yes you're right.

I'm pretty lazy with my expressions. With English being my first language I should check the real meanings of the expressions I use (especially in an...

Gail,

I do agree that encrypting passwords is not the right way to go. However, I do think that the term encryption can be misused (probably by me as much as...

I run DBCC CHECKDB on a daily basis. The datadases I'm responsible for aren't big and we have a large maintenace window.

Dave

Jeff,

Are you Tom Kyte (one of Oracle's employees) in disguise???? I used to work for a company that consumed Oracle data and so I searched for Oracle specific solutions. One...

I did gasp when I read "Passwords shouldn't be encrypted". However, I needn't have, what I think Gail was saying is that passwords must never be stored in plain text,...

I don't really understand the question, but you can use it in any environment.

Dave

Is

delete from a from ... valid?

If it is, in my defence I currently only query data (I'm currently only a consumer of data, not a maintainer)

It is valid....

You can add my vote to seeing imarran’s hierarchy solution using views.

Chuck has stated, in an earlier posting in this thread, that he is supporting SQL Server 2000 databases (amongst...