Friday, September 3, 2010

Introduction to Auditing in sql server versions !@!

›
I have talked in depth about how auditing is possible with sql server 2008.I shall now talk about how auditing happens in sql server 2000 an...
Wednesday, September 1, 2010

How to backup server principals in an instance ?

›
There are 2 scripts that microsoft has come up with inorder to backup sql server principals.I suppose it has different scripts for various s...

Exporting Data from SQL Server to Excel ....

›
There are different ways with which we can achive this ...Few of them to mention are as follows : 1) BCP ( Bulk Copy Program )-This ships wi...

How to make bcp utility to append to a file ? ( Scheduling Tasks )

›
1) Create path to hold the running scripts here in our example C:\testlab\s2 2) Create a batch script by name memory_in_use.bat Co...
Monday, August 30, 2010

Auditing user actions ( DML ) on a table !

›
Please find below the scripts that I have created to implement solution for logging DML user actions(Insert,Update and Delete) on a particul...
Saturday, August 21, 2010

How to find the port no of a particular sql server instance !

›
Script-1 ------------- For default instance use below code : DECLARE @tcp_port nvarchar(5) EXEC xp_regread @rootkey = ‘HKEY_LOCAL_MACH...
Friday, August 20, 2010

Script to backup users in a db along with their db roles in Sql Server 2000 !

›
if exists(select * from tempdb.dbo.sysobjects where name like '#users%') drop table #users create table #users ( uname nvarchar(150)...