Did you create a login on the server and give it access to the database(s)?

Is the instance using Windows Authentication or Mixed Authentication (SQL Server and Windows)?

-SQLBill

I don't use ADO so I can't help you with that.

About SQL Server programming, I suggest making the BOL your friend. It's very helpful with syntax.

BOL = Books OnLine...

Julian,

Good point, I am aware of that. Your pointing it out showed me that in my original post, I forgot to add:

Windows Authentication is not an option for these users....

Basically....nothing.

They both do the job. However, with a maintenance plan YOU, the DBA, really don't know what's happening. You have just told SQL Server - backup my database(s) and log(s)...

SQL Server Operator Precedence list:

Go to Books OnLine, use the index tab and enter Operator Precedence, then scroll to the bottom (Section titled Operator Precedence.)

-SQLBill

I'm a bit confused...

Why does your UPDATE statement have a FROM? A FROM in and UPDATE means you are retrieving data from that table to put into another table. That's...

Is it really rounding down? Integers don't have decimal places so:

1.23 as an integer will be 1

it just drops the decimals.

Suggestion: CONVERT or CAST the integers to DECIMAL, then find...

Brian,

I don't use ASP, where can I learn more about programming with ASP?

That might be an option, but I'll have to pass it by my security people. Applications have to...

they're apart of the domain admins group

Check that the login BUILTIN/ADMINISTRATORS exists on the test SQL Server.

Your error message isn't readable.

-SQLBill

Yes the above returns the correct response, but it's in parenthesis.

The order of operators (for math) is:

Multipy, divide, add, subtract

So, let's break down the math:

57714 + 345 - 17 *...

2) If the databases are protected by passwords, why would giving me access to my own tables be a security threat?

I presume that 'they' own the server? However...

Ed,

Thank you for your input. My program won't allow setting of permissions. That's my job. I just want to allow regular users to change their passwords from a remote location.

Good...

I don't believe it's a 'bug', I believe it's intended to be that way. Normally a 'standby' server isn't being used. It's updated in case the primary server crashes or...

Possibility:

When you get the results from a query, they have to be stored somewhere so they can be displayed. They are not being displayed directly from the database. Maybe your...

It does point you to the correct line. However, how Microsoft counts lines and you count lines may be different.

For example, how many lines are each of these:

SELECT col1, col2,...