Sql Server : Login Failure Alerts – meaning of different error messages from Operating System

Posted by Sqltimes
On June 28, 2014
0 Comments

A few months ago, we put in more layers of monitors on our production database servers. One such improvement is based on logins. Both OS logins and Sql Server logins. On any given regular day, not many people log into production servers (OS – login); May be 1 or 2 in a day. So, it […]

Posted by Sqltimes
On June 21, 2014
0 Comments

Quick one today: Sometimes, during troubleshooting, PRINT commands come very handy in traversing the progress of procedure (or any batch of SQL code) execution. When you have a large amount of code with hundreds of of lines of code, you might end up with many PRINT statements capturing the status. The result might end up […]

Posted by Sqltimes
On June 14, 2014
0 Comments

Quick one today: Again today, I ran into another interesting error message. In our lab environment, playing with one of our customer databases, I ran into this interesting error. Msg 1833, Level 16, State 2, Line 5 File 'filename' cannot be reused until after the next BACKUP LOG operation. If the database is participating in […]

Posted by Sqltimes
On June 11, 2014
0 Comments

Quick one today: Sometimes on new machines, that have Sql Server installed, I check to make sure if anyone is listening on port 1433. By default, Sql Server listens on port 1433 for incoming connection requests over TCP/IP protocol. Sql also listens on port 1434 fo DAC, for that is for a later post. Also, […]

Posted by Sqltimes
On June 7, 2014
0 Comments

Quick one today: Ran into an interesting error message today. On one of our lab servers, I was making some changes to test a deployment and I was running FULL database backup and adding/removing some data files on the same database. Boom !! I got this error. Msg 3023, Level 16, State 2, Line 1 […]

Posted by Sqltimes
On June 4, 2014
0 Comments

Quick one today: In our lab, we have a lot of Sql Server Developer Edition software installed. For the most part, for these Sql Instances, we do not expect any external connections to come in. But once in a while we need them to be available for external connections. That is where we run into […]

Sql Server : Login Failure Alerts – meaning of different error messages from Operating System

Sql Server: Include or print new line and carriage return using CHAR(13) + CHAR(10)

Sql Server: Is anyone listening on port 1433

Sql Server Error Message: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed

SQL Server Developer Edition – TCP/IP Protocol is Disabled by Default