I'm a little late getting into Extended Events but the code provided by Jonathan is great. I needed to trace some deadlock events on a SQL 2008 SP1 server...

Could you re-post the question in a manner which makes the desired result a little more clear. It looks like some of the results rows have commas and some...

The table being inserted into is empty, so no pages have been allocated to the table As for the data being order in the order of the clustered index,...

Sunny,

Maybe I don't understand your question, are you sure you want to use BCP for migration? How about creating a backup the current version of the database and restore...

Yes, its possible. Try suser_name() instead of user_name.

Example:

select

user_name() [user_name]

,suser_name() [suser_name]

Depending on what kind of information you need sp_depends presents a good amount of information on what is being used in a procedure and to some degree how it is...

Does the drive that SQL Server backing up to fail over with the SQL Cluster instance? Is there an existing physical drive on the new node with the same...

David,

No sorry I don't have know of any good doc's on how to do this, I normally turn to Books Online for this kind of thing. Snapshot Replication is...

David,

Is real-time access to the production data a requirement? If not how about snapshot replication? Or how about database mirroring with a database snapshot every few hours/days? ...

I had the exact same need. Here is the code I wrote based on the 2008 R2 command sp_trace_setevent

/**********************************************************************

*Created by:sfibich

*Created on:4/8/2011

*ScriptName:trace.traceEventIDDesc.sql

*Pupose:this creates a table named eventIDDesc in the trace...

The plan is to allow users access to a set of stored procedures and other database objects that they will use to execute all game play. A front end...

I have to agree with David, IMEX=1 is a much easier solution and we use this at where I work with excel for a number of different packages. The...

Sorry about any scripting issues, I ran a test in my development environment before posting. I thought I cleared everything out and built it from scratch but I must...

OpenQuery is a good way to go as well but this requires that this method is opened up to more than just the sysadmin role, something that we may not...

Good article, I would have liked to seen the exploration of a linked server in a openrowset subquery where you can have the where clause logic run on the remote...