There are cases where you'd only want someone inserting data, not being able to read. For instance, if you have a device that's taking measurements, you'd want it to be...

If you know the format is always going to be -, yes, you can do it in a set-based way. You could do something along the lines of:

WHERE MyNumber =...

Installing it as a named instance shouldn't have mattered too much, but it does sound like something went flaky with the install somewhere. Can you connect via named pipes? Especially...

db_datawriter gives INSERT, UPDATE, DELETE implicitly on all tables and views.

db_datareader gives SELECT implicitly on all tables and views.

You may want to go back and check those other servers because...

The "text" on how to solve blocking problems... be aware there is a lot of data collected.

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

So you're at a command prompt, sitting in the directory, run the program and a command window flashes and is gone. Very, very odd.

As a simple test you can...

Take a look at CHARINDEX(). It can be used for just about any character or stream of characters.

What if you navigate to the directory where svrnetcn is located and run it again? Anything?

You can change the owner of the job in SQL Server Agent. That's what racosta is referring to. In EM >> Expand the server >> Expand Management >> Expand SQL...

Anything in the application event log?

Out of the box, no, SQL Server doesn't have the trusted concept. You can, however, build one using row-based security models.

SQL Server MVP Vyas Kondreddi has written up a...

What happens if you drop down to a command prompt and run it from there? Does it show an error?

Find out what TCP port it is listening on and see if you can connect to it by directly referencing the port.

Windows user or SQL Server user? Verify using say Profiler the user is indeed the one you've assigned permissions to. Also be sure to log off all connections with said...

Also keep in mind most servers are set to prioritize background services over applications. You can check by right-clicking on My Computer and choosing Properties | Advanced tab | Performance...