SQL Server Tools

Does anybody know how to trace all activity for a specific table, using Profiler? I want to be able to trace every single SELECT, INSERT, UPDATE and DELETE for a specific table. Thank you in advance! ...

Hi,   Right off the bat, I am brand new to using DTS. Using Enterprise Manager 8.0   I have a production db and a test db. I want to refresh several test tables for testing. I've written a package that gets each table from ...

Does anyone know of a tool or utility that you can run against a sql 2005 server that will measure the transactions per minute on a server. ...

I am running Enterprise Manager in SQL Server 2000 and attempting to do some table maintenance.  When I run a delete query that should delete approx. 600,000 rows, the query timesout and gives the following message "[Microsoft][ODBC SQL Server Driver] Timeout expired.", but ...

I am having some pecular problems with Enterprise Manager.  These problems have been occuring prior to our transition from SBS 2003 and after the transition. Now we have a domain controller, an Exchange server, and an application server that is hosting Great Plains.  We are using the sql database that ...

In SQL Server 2000, we were able to BCP out of a table-based function with a command like this: BCP Impresario.dbo.LFT_GL_POSTING(91) out c:\impftp\gl.txt -c -T -STESS3 The version of BCP.EXE that comes with SQL Server 2005 (2005.90.1399.0) ...

I have a T-SQL store procedure in SQL Server 2000 that bulk inserts a text file into a table. The code is like this: BULK INSERT FT_MASK FROM 'e:\interfa\input\Cot\ftp\mdir.txt' WITH (CODEPAGE='ACP') The problem that I found is when mdir.txt is empty (0 bytes). Randomly ...

I located the following titles and dates of courses being held in Chicago: 2071 Querying Microsoft SQL Server 2000 with Transact-SQL    04-05-07 2071 Querying Microsoft SQL Server 2000 with Transact-SQL    05-14-07 ...

Hi all, I just installed SQL 2005 Enterprise and I can not create a maintenance plan. The server throws an error of: TITLE: Microsoft SQL Server Management Studio ------------------------------ Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) ...

The SQL Documentation Tool creates comprehensive technical documentation for creates technical documentation for Microsoft SQL Server databases. This latest version has enhanced logging and detection of errors. Key features: The SQL Documentation Tool creates technical documentation for Microsoft SQL Server 7.0, 2000 and 2005 databases. Technical ...

Hello, I have collected data with PSSDiag, and run the traces through read80trace.  I have a few questions regarding the use of the RML files generated from read80trace when running the ostress.exe utility to simulate a workload.  I ...

Hello everyone, Is it possible (and if so, how?) to export the list job tasks (with status, last run, etc.) from SQL Server to a table (in the same SQL Server) so I can create a simple ASP file showing the results? ...