Generally, you would assign someone to one role. Specifically, the roles "datareader" and "denydatareader" counter each other.

Even better is to create a new role, and assign the specific permissions...

Another thing I'd test is performance. I don't know how big your table is now, but operate under the assumption that it will grow to be much larger (businesses...

Glad to hear. Make sure to test the extremes. The script I gave you isn't very NULL resistant, so if you've got any nullable columns, test putting a...

You don't save, you need to hit execute. BEFORE YOU DO THAT, confirm that you are on a development, test, or sandbox instance. This script could potentially delete...

Something like this:

CREATE TRIGGER trgCheckForStatusTrue ON Table1

FOR INSERT UPDATE

AS

INSERT INTO Table2

SELECT Table1.* FROM Inserted

LEFT JOIN Table1 ON Inserted.ID = Table1.ID

...

What do you copy then? Do you copy all three rows?

You've said move and copy and I'm not sure which you mean. When Status is TRUE, does the data still reside in table1, and copied to table 2, or...

It depends on your needs. Using agent means it will operate on a schedule. If you wanted to go through and do this, say once a day or...

Have you thought about using replication? It seems like that's what you're trying to do...

You have a BEGIN in your stored procedure code, but no END. That is probably your error.

One of the problems with dynammic SQL is that it can sometimes be...

Sure, it may be possible, but why would you?

What he's saying is the only reason he can think of to do that is because a teacher challenged you with it....

sku370870 (8/24/2010)

---

Is the trigger below correctly written? The reason I ask is that when I look in the Audit tables I often see what look like duplicated entries.

ALTER TRIGGER [dbo].[trgTAAdditionalWork]...

You're in debug mode. If you go to Debug > Start Debugging from the toolbar, it switches to debug mode. As soon as you do that, the command...

Failed inserts perhaps? Consider the following code:

CREATE TABLE ##test (

ID INT IDENTITY(1,1),

TestValue NVARCHAR(50) NOT NULL

)

GO

INSERT INTO ##Test (TestValue) VALUES ('Test')

GO

INSERT INTO ##Test (TestValue) VALUES (NULL)

GO

INSERT...

The biggest benefit is more RAM. 32-bit caps out at 4G of RAM (but there are ways of getting around that, kind of). 64-bit caps out much higher....