Browse by Tags

SQL Server Auditing and Logging - SSIS Audit Transformation comes handy for you in database platform

Published 21 August 8 3:40 AM | SSQA.net

If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial...

Filed under: SOX, sql server, performance, ssis, audit, bids, pack, authentication, transact sql, transformation

Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.

Published 17 March 8 4:39 AM | SSQA.net

DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the...

Filed under: sql server, blocking, dmv, version, 2000, pack, 2005, tsql, errorr, tablels, incorrect syntax

How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008

Published 24 December 7 4:38 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL...

Filed under: sql server, microsoft, instance, kba, 2008, pack, 2005, ifilter, register

Table schema comparison and sometimes data too!

Published 9 July 7 5:11 AM | SSQA.net

Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish...

Filed under: sql server, performance, data, red-gate, compare, procedure, compact, pack