Who2 wants to process sp_who2 ?

SP_who2 has become a very handy tool for administrator, DBAs developers or all who are the All-In-One role) to get information from the processes table and get the appropriate information by just issuing this command form the command line. Easy if you have <100 connections and go simply through the data by scrolling and getting…

1

TDS Protocol Versions meet client stacks

A colleague (Cornel Sukalla) asked me what the protocol_version in sys.dm_exec_connections is all about. From the output it seems that its an INT presenting the version for the protocol used by the client. With some research and having in mind that those cryptic numbers are only another presentation of the “right” value; I came across…

1

Get all system databases of a server

The easiest way for querying all system databases of a server is to assume that databases create by a user come with a database_id >= 5 in sys.databases. But the problem is that distribution databsaes will not be kept into this consideration. Therefore SMO does the following behind the scenes (bioled down to the relevants facts)…

1

Changing the Login / Authentication Mode programmtically via SMO

Here are some instructions how to change the Login / authentication mode via Code. It just uses plain SMO capabilites:     After this you will have to make sure that the Service is restarted, if you want this to do via SMO look at the following sample. You need to know the ServiceName your…

2

Obfuscation is not a security feature – Spoofing the APP_NAME

  SQL Server 2005 introduced an interesting and long demanded feature, the LOGON triggers. First only defined via server event triggers, it has become more and more popular in same scenarios to prevent users with a certain machine environment accessing the server. I saw that implemented in forums as denying special users the access during…

2