Is there any chance you can use MTS, because if you can, you can set up MTS impersonation. The users get access to the code in the package from...

This will work a little better:

USE TEMPDB

BEGIN TRAN

GO

CREATE TABLE MY_TABLE(

THE_VALUE_A CHAR(1),

THE_VALUE_B CHAR(1),

CONSTRAINT CHK_A_AND_B 

CHECK (NOT(THE_VALUE_A IS NOT NULL AND THE_VALUE_B IS NULL)))



GO

/* insert ok */

INSERT INTO...

Am in agreement with the previous two. Backup to disks first. Backup those backups to tape.

If you use transaction logs, one quirk I have found is that...

If you can set up this domain account with an email, it is easy to set up the SQL email system to notify when jobs are complete etc. I...

You could do the restore to the production system but with a different database name. This is hardly ideal, because you will have to be very careful.

I...

I agree. I would script the job onto development. If successful, then script to production. There are a number of stored procedures that must be used to...

You can use a join statement in a delete, and in this case this statement would have done the trick:

DELETE FROM ol

FROM Orders o

JOIN OrderLines ol

ON...

quote:

---

FROM Precertification INNER JOIN

PrecertificationDiagnosis ON Precertification.idsPrecertification = PrecertificationDiagnosis.idsPrecertification INNER JOIN

PrecertificationService ON Precertification.idsPrecertification = PrecertificationService.idsPrecertification INNER JOIN

CommentsPrecertification ON Precertification.idsPrecertification = CommentsPrecertification.PrecertificationIdx

---

Es gefaellt mir, dass die Erklaering Ihnen Hilfreich war.

Ich habe Deutsch seit neun Jahre in der Schule gelernt. Zwei Woche lang als ich funfzehn war, habe ich mit einer...

Weil Sie aus Deuschland sind, denke ich, dass Sie Deutsch koennen ("oe" bedeuted ein "o" mit einem umlaut).

If you don't understand German, please go to the paragraphs below.

Das Woert "cute"...

We always use RI. I can't imagine not using it.

We have a third-party application that doesn't use it. We have a lot of problems with it from performance...

By the book you do have to detach the databases to be able to reattach them, but so far I have always been able to attach a database even if...

By rebuilding the master, you can set the appropriate permissions to allow you to attach the databases. Unfortunately you will also need to recreate anything else stored in the...

Yes, you can delete NT Authentication logins that have been deleted from the domain, because even if they were recreated in the domain, they would have different spid and so...

Thanks Rita,

I checked another thread and have found that just because I couldn't restore master doesn't mean the same limitation applies to user databases.

I'll be trying to attach the master...