SQL Server Security Archives - Page 44 of 46 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling

April 11, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security

SQL Server 2005 offers a more robust set of tools for handling errors than in previous versions of SQL Server. Deadlocks, which are virtually impossible to handle at the database level in SQL Server 2000, can now be handled with ease. By taking advantage of these new features, you can…

SQL SERVER – 2005 – Silent Installation – Unattended Installation

April 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

Silent SQL Server 2005 Installation is possible in two steps. 1) Creating an .ini file The SQL Server CD contains a template file called template.ini . Based on that create another required .ini file which includes a single [Options] section containing multiple parameters, each relating to a different feature or…

SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX

April 8, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Server Security, SQL Utility

We can use either CHARINDEX or PATINDEX to search in TEXT field in SQL SERVER. The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. Both functions take two arguments. With PATINDEX, you must include percent signs before and after the pattern, unless you are looking…

SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1

April 6, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

DBA, SQL Download, SQL Error Messages, SQL Server DBCC, SQL Server Security

I have received this error many times on different servers in my careers. There is no single fix for this Error. Server: Msg 7391, Level 16, State 1, Line 1 can happen due to many reasons. I have used various of this reasons with few of my servers. Please refer…

SQL SERVER – Fix: HResult 0x274D, SQLCMD Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired

April 4, 2007

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Security, sqlcmd

While Working with SQLCMD in SQL Server 2005 I encountered following error. Let us learn in this blog post how we can solve Fix: HResult 0x274D, Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired.

SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.

April 1, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL TempDB

If you ever find your TEmpDB to be full and if you want to move TempDB, you will find this blog post very helpful.

Here is the error message which may come across.

Event ID: 17052
Description: The LOG FILE FOR DATABASE ‘tempdb’ IS FULL.
Back up the TRANSACTION LOG FOR the DATABASE TO free
Up SOME LOG SPACE

SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON

March 28, 2007

Pinal Dave

SQL

SQL Download, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

This error occurs when the user has attempted to insert a row containing a specific identity value into a table that contains an identity column. Run following commands according to your SQL Statement. Let us learn about the IDENTITY_INSERT.