i found some interesting stuff about service queues not having a unique GUID over here:

http://stackoverflow.com/questions/1127404/service-broker-with-sql-server-2005-messages-stuck-in-queue

I know i've had a situation a couple of times where the service just doesn't seem...

I believe you are incorrect; the default state would be INACTIVE unless you query the queue at teh exact moment you are actually sending an email.

all four of my servers...

there's a very complete, once again free Canadian postal database here:

http://www.populardata.com/downloads.html

here's a free copy of mine; it's the CREATE TABLE and INSERT INTO statements i've psoted here on SSC a few times.

it is based on a formatted version of this...

well, you can sue CTE's instead of temp tables, but i'm not sure how much simpler that is..it is the same query, different format.

DECLARE @KeyDoc int;

WITH freesiteaccess

AS

(

SELECT DISTINCT x0_0.keydoc,...

awesome linky Patrick, thank you! 😀

Fear Naught (3/23/2012)

---

This is an interesting point. I, as a relative beginner of SQL Server and self taught, was under the illusion that a trigger fired for each row...

rpnew (3/22/2012)

---

I have a requirement to store the address for an object in two separate tables -- one for State and one for City. There should also be a parent,...

take a look at this example;

what you are asking is possible by getting the data using XML;

Select Row_Number() Over(Order By is_linked, name) % 2 As [TRRow],

...

i would agree; an error in the trigger could prevent data from being inserted;

cross-database data migration does not belong in a trigger.

an outside process could error out, but the next...

any command with a FROM must have a SELECT...

so that's the error you are getting.

To do what you want, I'd probably use EXISTS:

something like htis, maybe?

IF EXISTS(SELECT 1 from inserted...

thamil_md (3/22/2012)

---

Hi,

I have a column named 'SQLs' in Table A and the column 'SQLs' has SQL statements as data, like this:

select '21/03/2012' as date_modif_create, 'tblAddressesGP' as table_name, count(*) as total_rows_modified_updated...

take a look at this books online item about using native mode to avoid dataconversions...it's just a -N flag, but it's important to understand, it might be what is affecting...

best practice is to never shrink the databases, unless you know a one time ETL process ro something expanded a database.

the thing to do now, i think is to look...

absolutely no value or logical reason Eugene, you are right, other than it was what I thought the OP was asking for...a model that included try catch and features an...