Would be easier if we could see the SQL code and table definitions (with indexes).

We would love to see the results...?

I agree with Kent and Michael: Auditing is usually considered to be an operational feature, not a functional one, and thus I would prefer to implement it using Operational...

I believe that this is an option of the published Articles. You will have to change it in each Article's definition, or change the Article defaults and then drop...

That said, here is how I would do something like this:

Select Room

From Rooms R

WHERE Not Exists (Select * from ReservationRooms RR

Where R.Room = RR.ResRoom

And CHECKINDATE < @DATEOUT

...

If you are really "looping" then a Tally table can help you to get rid of that Loop. If so, then please post the whole SQL procedure, not just...

GilaMonster (5/27/2008)

---

Try building up your strings and placing them in variables then passing those variables to sp_executesql. I seem to recall that concatenating bits of string in the call to...

Things to look for: foreign keys with ON DELETE CASCADE, and Insert/Update triggers that are executing Deletes.

piojilla (12/28/2005)

---

A snapshot agent has failed, the associated error message being:

The process could not create file \\{UNC-file}

After an initial set-up of replication the 'UNC-file' will be something like '\\{server-name}...

w.lengenfelder (5/27/2008)

---

Second: in your last query at

-- ValidRequestOnQueueFlag

Case when exists

...

That seems likely.

In my opinion, yes, it is...

Heh. You're fast Gail. :laugh:

GilaMonster (5/27/2008)

---

The best is one I got as a PM (and promptly deleted) It was sent on friday, asked a question, gave some data and them the poster said he...

I have to admit, over the years I have consistently found this to be the single most frustrating aspect of SQL Server, bar none. I cannot even begin to...