Can I disable the automatic transaction in SQL Server Management
Studio?  i.e. I want to commit myself instead of having it
automatically commited by Studio.
Thanks

I see the following TextData in Profiler for the SQL:BatchCompleted event.
AFAIK this is not T-SQL. Can anyone explain the origin:
insert bulk mytable("col1" int,"col2" binary(10),"col3"
varbinary(7000),"traderMember" char(4) COLLATE ...

We use Trackit for our helpdesk software. The new version uses SQL 2005
Express. I recently installed SQL 2005 Management Studio from our Tech Net
cd's so I would have the capability to use the jobs under the Agent to run
backups. Does anyone know why the SQL agent doesn't show ...

Is there a way to paste in a multi-line string into a text field when the table
is open in 2005 Management Studio?
It only seems to take the 1st line.
--

I need to find a way to invoke a bunch of SPs from a windows XP box that
will need the least amount of software install and configure. I'll be more
than happy
with sqlcmd, but it seems like it has it own dependencies.

per the suggestions in this thread:
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sq
lserver.server&mid=16318b4f-9fe0-466e-abca-3cc11713266d,
I'd like to request that some mechanism (short of restarting sql server) be
presented for resetting the ...

I have a server that contains server level DDL  Triggers (create, drop DB
etc).  I am not able to see them with SSMS.  I have seen screen shots that
show them in the "Management" folder of SSMS.  I can list them via "select *
from sys.server_triggers".  Any idea why I am not able ...

I have a table like that:
Create table myTable
( Name varchar,
  Description Text )

We are trying to redistribute SQL Express, and we'd like the dtswiz.exe to
be there.  Is there a small DTS Utilities installer somewhere?  So far I can
only find SQL Express (36M), Mgmt Studio Express (43M), and then SQL Express
with Advanced Services (234M) and SQL Express ...

I am getting a "Tuning process exited unexpectedly." error from DTA.  I'm
running Microsoft SQL Server 2005 - 9.00.3042.00 (X64) so I don't think that
KB 917131 applies.  This happens when running DTA from my client machine and
when running it on the server.

ADO.NET is designed as a disconnected model, such that all records are
returned to the client when a query is executed.  However, that could
take up quite a bit of memory.  When I measure the memory consumption
of Management Studio vs. my application, it seems to me that they ...

Will SQL Server 2008 continue to support applications written in
SQL-DMO?  Yes, I know that none of the new features are available via
DMO, but I just want to know if DMO will still connect and work with
legacy features.  And if so, will there be yet another "backward

Has anyone used this program?  "DMT SQL Block Monitor 1.9"
Is it any good?  Are there other programs like it?
Thanks

Is it possible to use SQL Server 2005 Express's tools to connect to a SQL
Server 2000 server and exchange data? I've poked around and don't see any way
to setup the connection, but I'm hoping that I've just overlooked something.
Thanks,

i would like to know if there is a way to 'step through sql server t-sql
commands'
using one of the sql server 200 tools, sql server managment studio, or
viusal studio .net 2005 professtional version? If so can you give me