There really isn't any way to stop the user from registering the server.

You could run a job that KILLs spids by host name (the machine name), but EM...

Error 17 is not a SQL Server error - it is probably an error in the OLEDB provider. Read this link and see if it applies to your situation:

http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx

Yup, much better.

As the others have mentioned, COUNT(*) will not return null.

It appears you want to return any value > 0 as 1.

So your SELECT statement can be simplified to:

Select CASE Count(*)...

What are the ranges of possible values, and how many decimal places are required?  You might be better off using the DECIMAL data type instead of float, which can lead...

I converted your query slightly to test it, and it works as designed. In fact, I forgot to change the server name YOURSERVER to one of my actual server names, and...

1. Please don't use the /b - that is not valid T-SQL. Look up "osql utility" in BOL for the syntax of EXIT(). 

2. Look at my earlier example. To...

If you use Firefox, get the Flashblock and Adblock extensions. The animation is a Flash object, which will appear as a VCR play button when using Flashblock. If you want...

Actually, try the example below. @stat will contain the final return value from the osql query (5 in this example, but your would replace that with @RetVal):

DECLARE @stat...

This format:

osql -S ... -Q "EXIT(declare @x int set @x=1 select 5)"

will set the errorlevel to 5.

Try and wrap your entire command with EXIT()

EXIT( <all of your SQL code...

I also find all moving/flashing ads very irritating and distracting. They make it more difficult to read the material of interest. I use Firefox with the Adblock and Flashblock extensions...

Are you trying to select the customer name with the most orders?

If so, here is another way:

SELECT TOP 1 temp.cname

  FROM (SELECT c.cname

             , Count(o.cno) AS total

         ...

I believe there was a Personal version that might work, but the standard edition cannot be installed on XP. As with all versions of SQL Server, most editions cannot be...

Actaully, Codd did create and describe the various normal forms. Ray Boyce worked for IBM to implement the theories as an actual relational database called System R. It was through...

As a follow up, when your are creating user id's in SQL Server, you are required to select the authentication mode.

If the server is setup for Windows Only, then each...