How to use the new function fn_get_sql() ?

This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query

Cycling Those Error Logs

Have you ever tried to open the current error log in Enterprise Manager only to have it seize up and hang? Has that annoyed you? It certainly annoyed Steve Jones and he decided to do something about it. A little techinque for helping to manage the size of those logs and prevent the "not responding" message from appearing in Task Manager.

Blogs

Getting Started on AWS RDS

By

I’m expanding my skill set into AWS in a big way. So, one of...

Daily Coping 1 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting Up GitHub Desktop (formerly GitHub for Windows)

By

When I started using Git, I first download GitHub for Windows. I went searching,...

Read the latest Blogs

Forums

Best Tools For Marketing Of Your Content

By alexrory4650

While no content marketing tool can supplant a strong system and skilled people, having...

How do I reattach my databases?

By Doctor Who 2

Yesterday I went through the process of replacing an old, failing hard drive, out...

Cloud Adoption 2020

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Adoption 2020

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers