Thanks Gary,

That's a lot to be going on with.It's amazing the info that comes up as the result of a simple post.

Cheers,

yogi.

magic,

I'm on vis studio 2003.Does this mean that you use the dbProject  as an actual DAL in your solution? as opposed to using a "classLibrary" file. At the moment, I have...

Cheers Gary,

Hmm..I haven't implemented a source control application yet.Something I have to look at.Do most people use Visual Source safe, or perhaps implement their own thru drawing up their...

Thanks folks, I can use the WITH TIES for the simple ones and the other approaches for more complex stuff...

It's always good to have...

cheers Frank,

All these wee things save a lot of time.

Thanks for the 2 options.

yogiberr

ok, a single sproc it is.

cheers,

yogi

Hi Frank.

Looks like I have most things covered.

Nice site.

Cheers,

yogiberr

thanks folks,

Merry Christmas from a rainy Scotland.

yogi.

Thanks folks, for taking the time.

Great script.

cheers,

yogi

I agree.

I think I'll stick to learning how to work the wheel before I try to reinvent it 🙂

cheers,

yogi.

sorry man,

it was a daft question.

cheers,

yogi

Thanks kokyan,

I'll try that..

yogi

Hi,

SUBSELECT

<code>

IF EXISTS(SELECT 1 FROM INSERTED

WHERE jobTypeId =

(SELECT jobTypeId

...

hi,

yes, it errors:

"the column prefix 'dbo' does not match with a table name or alias used in the query"

ta, yogi

Cheers,

I'll now start hacking my first 3 triggers!

ta, yogi.