sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view...
2013-03-11
3,782 reads
The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx
Returns information about the connections established...
2013-03-05
1,464 reads
How can I check what all SQL server features and version are installed on my Machine ?
It’s a frequently asked...
2013-02-25
1,524 reads
The 11thcumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft...
2013-02-19
993 reads
The 5th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-02-19
1,911 reads
The 6thcumulative update release for SQL Server 2012 is now available. Cumulative Update 6 contains all the hotfixes released since...
2013-02-19
827 reads
Issue :-
One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending...
2013-02-14
749 reads
It seems to be a simple & easy thing to connect Perfmon to a remote server.
GO TO RUN > Perfmon > Right Click...
2013-02-14
1,211 reads
Today, We discuss How to get list of all available parameter of .EXE file OR How to find list of...
2013-02-13
4,531 reads
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.
But Sometimes...
2013-02-11
1,760 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers