SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Monday, July 22, 2013
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
›
Today when I was connecting my SQL server from some client system, connection established successfully with the server. However, then an er...
24 comments:
Monday, July 8, 2013
Cannot alter the user 'dbo'. (Microsoft SQL Server, Error: 15150)
›
Some times we may get the below error while updating the login from dbo to some other login from user mapping window. 1. I have database wh...
21 comments:
Monday, July 1, 2013
Get Login Session count, Session Mode, User Name, Machine name
›
sys.dm_exec_sessions SP s tores the login information about users like username, login time, machine name, authentication mode (Windows ...
Monday, June 24, 2013
Procedures / Commands used in Sql Server Jobs
›
It is very difficult to find a procedures / Commands used in SQL Server Jobs from the huge cluster of Jobs through SQL Server Management St...
Monday, June 17, 2013
Changing the Default Database
›
By default SQL Server loads master databse. Sometimes it is required to change the default database in SQL Server. Use below query to chag...
‹
›
Home
View web version