Last_Batch in Master..Sysprocesses

Rating:

(0)

Brian Moran

SQL Server Magazine

InstantDoc ID #44847

What does it mean when I see a value of 1900-01-01 00:00:00.000 in master..sysprocesses' last_batch column?

The last_batch name is misleading. The term batch in SQL Server refers to a batch of SQL statements that's sent to the server and is received by either the SQL listener or the remote procedure call (RPC) listener. The first type has a SQL:BatchCompleted event class in SQL Server Profiler, whereas the second type has a RPC:BatchCompleted event class. However, SQL Server Bo...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations
A White Papers by expressor software

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

Field level security

I need to secure certain fields, Name, SSN, for example, in a table's rows. I know about SQL encryption, but is there another way to secure the indiv...