You can make the migration more likely to be successful by using the Data Migration Assistant before you start.  If you're migrating to SQL Server 2016 or later (and if...

Yes, it can do.  Check the login's properties to see whether that's configured to happen.

John

I can't see why not, but you may need to make a couple of tweaks.  Alternatively, just use SQL Audit instead of Extended Events.

John

Please see this topic for how to do the manual intervention you mentioned as being necessary for Extended Events.

John

Yes, a stored procedure can return multiple result sets.  However, you may find that that is not very useful, since you can't do anything with the results, such as inserting...

What do you mean by "pass"?  All the solutions posted so far read the table only once.  Why is it so important to reduce the number of lines of code...

Thanks, everybody, for your feedback.  I don't know how I managed to have the same answer twice, and it's six weeks now since I submitted the question.  I probably copied...

Only you can know that.  You have your solution and several others provided by contributors to this thread.  Have you compared the execution plans or done some load testing to...

What did you already try?  I would try splitting the string and selecting the element you require.

John

Indeed, or multiplying everything by -1 may also work, although I haven't actually tested it.

SELECT t.*
FROM #t AS t
CROSS APPLY (
SELECTCASE
WHEN @decBeginStation > @decEndStation THEN -1
ELSE 1
END...

• This reply was modified 5 years, 8 months ago by John Mitchell-245523. Reason: Corrected typo

You don't need a licence if you're just going to fire it up, script some stuff out and tear it down without ever using it for production.  Finding the installation...

You can't restore a backup of master to a different version of SQL Server.  I would advise you to build a temporary SQL Server 2005 server, restore master on that,...

What happens if you import it the same way you would any other file?  If you need the individual values in the XML separated into their own columns, import into...

If you change @a to @a-1 and B to B+1 as in this snippet, you don't get the overlaps.

...
CTE2  as 
(

select  @a - 1 as...

A SQL Server Agent job runs automatically, not interactively, so where are you expecting the value to show?  If you want to record it in a table, just use an...