SQL Server Security Archives - Page 41 of 47 - SQL Authority with Pinal Dave

SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks

May 21, 2007

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL injection is a technique for exploiting web applications that use client-supplied data in SQL queries, but without first stripping potentially harmful characters. Checking for SQL Injection vulnerabilities involves auditing your web applications and the best way to do it is by using automated SQL Injection Scanners. Security-Hacks.com compiled a…

SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples

May 18, 2007

Pinal Dave

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

SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger

Trigger events can be fired within another trigger action. One Trigger execution can trigger even on another table or same table. This trigger is called NESTED TRIGGER or RECURSIVE TRIGGER. Nested triggers SQL Server supports the nesting of triggers up to a maximum of 32 levels. Nesting means that when…

SQL SERVER – 2005 Enable CLR using T-SQL script

May 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CLR, SQL Advanced Option, SQL Scripts, SQL Server Security

Before doing any .Net coding in SQL Server you must enable the CLR. In SQL Server 2005, the CLR is OFF by default. This is done in an effort to limit security vulnerabilities. Following is the script which will enable CLR. EXEC sp_CONFIGURE 'show advanced options' , '1'; GO RECONFIGURE;…

SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName

May 4, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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

You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server. Error: The stored procedure required to complete this operation could not be found on…

SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1

April 30, 2007

Pinal Dave

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

SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server Security

While moving some of the script from SQL SERVER 2000 to SQL SERVER 2005 our migration team faced following error. Msg 3159, Level 16, State 1, Line 1 The tail of the log for the database “AdventureWorks” has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the…

SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query

April 30, 2007

Pinal Dave

SQL Tips and Tricks

SQL Cursor, SQL Scripts, SQL Server, SQL Server Security

A SET ROWCOUNT statement simply limits the number of records returned to the client during a single connection. As soon as the number of rows specified is found, SQL Server stops processing the query. The syntax looks like this:

SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks

SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples

SQL SERVER – 2005 Enable CLR using T-SQL script

SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName

SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’

SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1

SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query