Disabling the AUTOCOMMIT option in MSSQLServer

Hello,

Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server
while executing the SQL queries via SQL ANALYZERbegin transaction|||On 8 Jun 2006 08:01:15 -0700, Uncle Sam wrote:

>Hello,
>Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server
>while executing the SQL queries via SQL ANALYZER

Hi Sam,

In Query Analyzer (for SQL Server 2000): Tools / Options / Connection
Properties / Set implicit_transactions to ON. This affects only new
connections.
Also in Query Analyzer: Query / Current coonnection pproperties / Set
implicit_transactions ON to affect the current connection.

In SQL Server Management Studio (for SQL Server 2005): Tools / Options /
Query Execution / SQL Server / ANSI / SET IMPLICIT_TRANSACTIONS ON (for
new connections), and Query / Query Options / Execution / ANSI / SET
IMPLICIT_TRANSACTIONS ON (for the current connection).

--
Hugo Kornelis, SQL Server MVP

Disable database diagram creation

I have a MSSQL 2000 SP4 server.
I need to disable ability to create database diagrams for users.
How can I do this?To create a diagram, they would need to be the database
owner or a member of the db_owner role (or a sysadmin).
Don't add them to those roles.
You can figure out the specific object permissions in the
following article - different issue than yours but it lists
the permissions.
http://support.microsoft.com/?id=327145
-Sue
On 24 Oct 2006 08:38:06 -0700, slousch@.gmail.com wrote:

>I have a MSSQL 2000 SP4 server.
>I need to disable ability to create database diagrams for users.
>How can I do this?|||User is not db_owner and not in sysadmin,
there are no permissions to public database role,
but he is still able to create diagrams.
I want to get "You do not have sufficient privileges to create the new
diagram." message,
when user trying to creaate diagram.
Sue Hoegemeier wrote:
> To create a diagram, they would need to be the database
> owner or a member of the db_owner role (or a sysadmin).
> Don't add them to those roles.
> You can figure out the specific object permissions in the
> following article - different issue than yours but it lists
> the permissions.
> http://support.microsoft.com/?id=327145
> -Sue|||Check the permissions on the objects listed in the article.
-Sue
On 25 Oct 2006 04:09:54 -0700, slousch@.gmail.com wrote:
[vbcol=seagreen]
>User is not db_owner and not in sysadmin,
>there are no permissions to public database role,
>but he is still able to create diagrams.
>I want to get "You do not have sufficient privileges to create the new
>diagram." message,
>when user trying to creaate diagram.
>Sue Hoegemeier wrote: