see http://www.microsoft.com/sql/howtobuy/faq.asp

If you have a per processor licence it doesn't matter how many connections.  If you have Server plus device CAL then you need 100 CALS, one for each user, ...

Does this make sense?:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/err2031.asp

If not be more specific as to what's going on, how are you connecting and from what - a VB app, access, Excel etc.  Is this...

From a syntax point of view try:

 SELECT @item_no= ITEMNO,  @item_customization_code =SUBSTRING(FLAGS,1,2)

                  FROM dbo.msg_queue

                  WHERE EDPNO = @edpno

This is defiantly one of those "certification type" questions Chris mentioned. I guess because the question said "that he just mistakenly completed a price update" we are to assume the...

Phil you aren't reading carefully.  Nowhere does it say effect means "to bring about or execute"  Here's what the web page actually says:

tr.v. ef·fect·ed, ef·fect·ing, ef·fects

1. To bring into existence....

Sorry milz.  According to the very source you cited (dictionary.com) effect is a transitive verb only in the form tr.v. ef·fect·ed, ef·fect·ing, ef·fects .  This is not the same as...

Sorry Grammer Nazi,  the word effect is a noun.  If you are going to poke fun at grammer, please be correct.  You can't say something effects something else.  That creates a...

Since you posted on a SQL Server 2005 forum I assumed you were interested in how to do this on 2005.  If you don't already know how to do this...

SQL Server 2005 includes security enhancements such as database encryption, secure default settings, password policy enforcement, fine grained permissions control, and an enhanced security model.SQL Server 2005 includes security enhancements...

The question is fine.  The answers should include more than Yes or No.  For example

• Yes if Ordering by Ordinal position
• Yes if Including TOP
• Yes if View only includes One Table
• Views...

see http://support.microsoft.com/default.aspx?scid=kb;EN-US;319951

Here's a method I use when I want to copy userid and passwords from one server to another.  You may need to resync Databse users after but this is fairly...

Something to think about..  Are you sure you want to restore master on another server?  What would this give you?  You probably want to restore/copy your databases.  You MAY want...

Thanks for the help. 

Apparently Microsoft may have forgotten to increase the build number between SP3 and SP3a.  For furthur discussion see

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=48&messageid=122785

If you install MS01-031 the build number goes to 8.00.818.