It's buried in the ALTER TABLE command and can be hard to find.

For all of them:

ALTER TABLE tablename

DISABLE TRIGGER ALL

For a specific trigger:

ALTER TABLE tablename

DISABLE TRIGGER triggername

Ok. First let me try and clarify some of the confusion and then we'll tackle the real problem at hand. SQL Mail and SQL Server Agent Mail are separate and...

If it's communicating across a firewall, there are likely some ports that'll need to be opened. You'll need to know what port SQL Server is listening on and you can...

Different collation schemes can typically be handled at the database level so it's usually not an issue. Some reasons why you could want multiple instances:

- You have a cluster and...

I faced this issue when I was implementing a "heartbeat check" on our SQL Servers. Pinging is great. Service may show as up. But can you actually log in? What...

If the server is compromised by an attacker who manages to get local administrator rights, the data is already compromised even with BUILTIN\Administrators removed.

Attack Vector 1:

Stop SQL Server service....

SELECT

Account Acct,

Amount Dramt,

NULL Cramt

FROM [TableName]

WHERE Account = 'Dr'

UNION ALL

SELECT

Account Acct,

NULL Dramt,

Amount Cramt

FROM [TableName]

WHERE Account = 'Cr'

A stored procedure is more than just a precompiled SQL statement (and it's not ever fully compiled in the traditional programming sense). Here are two things that make a stored...

Removing BUILTIN\Administrators follows the principle of least privilege and is generally a good idea. However, there are some prepatory steps that must be accomplished or you could be left with...

This sounds like a development process in production, which is generally frowned upon. From a change control perspective you're looking at a developer having the potential of putting in a...

Bits can be in an index but they generally shouldn't be. The reason bit shouldn't be in an index is you only have 2 values (3 including null). For an...

Why not simply require the permissions are set by whatever process is executing the CREATE PROC[edure] statement when the stored procedure is created? Most change control procedures do this to...

If you are using DNS, have your administrator put a CNAME pointing the old name to the new name. If you have WINS, have your network admin insert a static...

Glad to be of help.

You said it is a windows account. If that's the case, it may be getting permissions through a Windows group. You would only see the group's mappings. You would not...