Triggers are not an option to log SELECT statements.

Be careful with C2 auditing. Once turned on, it needs to write its audit records. If the partition that it...

Have a look at "Project Real". This is a demonstration project developed using SQL 2005 with white papers, code and sample data. The project is intended to demonstrate...

When adding columns to a published table, you will need to use sp_repladdcolumn. ALTER TABLE...ADD COLUMN will not work because replication does not notice changes done this way.

For...

You have a few choices here depending on what tools and money you have and also whether people connect to SQL using a shared login or individual logins.

If there is...

I believe that the official position from MS is that SQL Server 2000 is not supported for Win 2003 unless SP3 or later is installed.

I would strongly recommend...

The following might bive you what you are after

Declare mycursor Cursor for Select 'Print ' + convert (varchar, spid) + '

dbcc inputbuffer ( ' + convert (varchar , spid )...

Have a look in BOL at sp_add_jobstep. In particular, the description of the values you may use for @command includes a table that lists a number of tokens that...

As another option to consider, the reason that the cursor was used in the example that started this thread was that the interface to usp_generate_purchase_order accepted one record at...

In Enterprise Manager, right click on "Data Transformation Services" and click "open package...".

Once you have opened your package, save as "SQL Server".

I assume that Oracle is giving you some for of unique transaction identifier. SQL Server doesn't have this but you might be able to do it yourself (if you...

You can save the package as either a structured stored file or as a Visual Basic file and then check it in to VSS.

If you save it as a structure...

One reason that temporary tables are quicker than table variables is because SQL Server may take advantage of parallelism in the generated query for temp table. Hence, if you...

The first thing I would check is whether there is a firewall blocking you. Windows 2003 has a fire wall and the normal approach is to start with most...

The problem you are experiencing is fairly common when importing from Excel. The problem occurs because the OLE/DB provider for Excel scans the first few rows of a spreadsheet...

From memory, when you try to connect to a sql instance (including the default instance) by name, a request is sent to UDP port 1434 on the server. The...