I still get it daily (maybe late, but 5 times a week IIRC).

Check out the "&" section in the books online.  If you need more information search for bitwise operations.

This shows how to check for existence of the procedure, how to delete it, create syntaxe.  Input and output parameters, return value, calling method and the nocount option :

USE...

Can we see the final result.. maybe we can improve it?!

ALTER DATABASE >DbName> SET SINGLE_USER | RESTRICTED_USER | MULTI_USER

Single_user is for one 1 connection

multi-user is to let everyone in

restricted is only for the sa group.

Sorry I forgot to post the link I wanted you to read .

http://www.aspfaq.com/etiquette.asp?id=5006

Quoting one member of this forum (sorry forgot your name) :

"When in doubt : test, test, test"

Both trigger types could do this.  I would probabely use the instead of insert (just a hunce). 

Once you validated the new data in the instead of trigger, you have...

Could you please read this article.  It'll show you the best possible way to ask a question in forums like this one.  That will also let us give you the...

How about not having to use a second variable to remember the connection string... or if you don't have access to the global connection string, but have access to the...

This is the most complete answer I ever saw to this problem.

Let us know if you need more help :

http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html

Is this even related to this question??

I think you may be better off starting a new thread if it's not.  that'll give you a much better chance of getting an...

Not sure that this is the case.  But I think that if you pass a connection in parameter, then the smo will NOT create a new connection.  But instead, will...

I'm assuming you are getting an truncate error.

Have you tried using varchar(10) instead of varchar(7)?

That's one way of doing it... but I don't think it'll solve your problem :

USE pubs

DECLARE @var1 VARCHAR(12)

DECLARE @var2 VARCHAR(30)

SET ROWCOUNT 10

SELECT @var1 = au_id, @var2 = au_lname FROM...