Viewing 15 posts - 3,316 through 3,330 (of 6,105 total)
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
October 7, 2004 at 11:52 am
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...
October 7, 2004 at 11:48 am
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...
October 7, 2004 at 11:35 am
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...
October 7, 2004 at 11:29 am
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...
October 7, 2004 at 2:07 am
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....
October 7, 2004 at 2:01 am
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'
October 7, 2004 at 1:48 am
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...
October 7, 2004 at 1:40 am
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...
October 7, 2004 at 1:25 am
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...
October 6, 2004 at 3:54 pm
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...
October 6, 2004 at 3:46 pm
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...
October 6, 2004 at 3:33 pm
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...
October 6, 2004 at 3:25 pm
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...
October 6, 2004 at 10:22 am
Viewing 15 posts - 3,316 through 3,330 (of 6,105 total)