Developer Newsgroups: SQL Server Tools

Will Running SQL Profiler slow down performance of Production Serv

DB - 1 Sep 2007 7:06 PM - 2 messages

Will running SQL Profiler 2000 slow down the performance of my production server - even if I run it on a different box? The production server has many transactions occurring during the day and I am worried that profiling it will ...

gettting list of @@IDENTITY

pelegk1 - 1 Sep 2007 5:08 PM - 6 messages

i am sending to a SP values which insetred into a table (1 or more rows) how can i return from a stored procedure this list of ID's? thnaks i nadvance peleg ...

Re: How to disable automatic transaction in Management Studio?

Tibor Karaszi - 31 Aug 2007 6:28 AM - 1 message

In addition to the other posts, you can turn off "autocommit" in SSMS. Check under Tools, Options, Query Execution, SQL Server, ANSI, SET IMPLICIT TRANSACTIONS. ...