SQL Server Tools

I've recorded a SQL Profiler trace file. When I replay it selecting "in the order they were traced", everything starts fine, but when it reachs  8%,  the profiler freeze. The interface doesn't respond. I can't even stop the replay. ...

It seems the Log File Viewer is not included with SQL Express w/Advanced Services, or at least I have not found how to view the log files using anything other than Notepad.  I'm having a hard time believing they didn't ...

Hi, I've added the TransactionId column to the tracer file in SQL Profiler, but the column just have data when a transaction is starting or finishing. How do I map a TransactionId  to a SQL statement? Is it something ...

I always seem to run into trouble installing SQL Mgmt Studio.  This time I have a box running x64 Win2K3.  I did not have another SQL x64 license, so installed the 32bit version.  I have SQL 2005 on all sorts ...

I'm looking for some suggestions & strategies I should take when backing up a mirrored database. Ideally I just want to backup the principal, but how do I create a maintenance plan that is aware of the failover partner? ...

I have a question about SSIS Notification services.  If this is not the correct - ng, please let me know which one to use. I have an SQL2k database with a number of actionable dates, e.g. due dates. expiration dates and so forth. ...

Using the Microsoft SQLCMD utility (on SQL Server 2005 Standard Edition), I can run the .sql script I created from a Windows command prompt, passing to it a variable name for the database I am creating: sqlcmd -i c:\createdbandtables.sql -v db=newdbname ...

I have created several triggers on a DBbut they do not show up under server\databases\MyDB\Programmability\Database Triggers If I use the following sql command I can list them in results: Use MyDB SELECT * FROM sys.triggers All of the triggers were created using SQL similar to this: ...

Hey guys,   Does anyone know any available tool which can be used to view the impact on database and stored procs when some changes have been made on the database. For example, changing the name of a column in a ...

Is there a utility to read the transaction logs for SQL Server 2000? What about SQL Server 2005?  I need to review the transaction logs for two of my databases to see if/when some table columns were altered from 'null' to 'not ...

Ladies, gentlemen, Upscene Productions is proud to announce the next major version of the popular database development tool: " Database Workbench Pro 3.0 " New Feature Highlights ------------------------------------- - Conceptual and Physical Data Model Diagramming - ADO/ODBC Explorer (run queries against any ADO/ODBC datasource) ...