Hmm..  Do you have a newline at the end of the last line?  Columns are all nullable.  Our solution du jour is to tack a newline at the end which is...

 This may be consistent, the index that is not being used is not clustered.  If I have some time today I will try some changes to see if clustering the...

 Thanks for the reply..   I now see why the index is not used, although I still don't like it!

The suggestion did not use the index either.  Our solution for the...

 Thanks, unfortunately we are talking many tables and join conditions, so I do not want to post the DDL.  If I run each part of the union individually, it works...

Another consideration for those not using numeric, I would use char instead of varchar for such a small data type, especially if you are not storing international and the lengths...

I don't see this article as arguing for XML as a data management tool, in fact I see it as agreeing that XML is not a management tool, but a...

I have also had great success using SQL2000 XML support with xsl to generate HTML. We have replaced all of the old crystal stuff and maintenance is a...

So I was preparing some responses to your questions, and I noticed that there was not an index on the Amex table, so I added the index ( on...

Thanks, no, I am not using AWE, and many of the resources I have found have dealt with those problems, more specifically the 2nd error messages I was getting.

...

Interesting topic a few things...

Wouldn't it be nice if there was an encrypted data source option, or some tool that provides an easy way to store a user/password...

Thanks! That was it, I had to mark the checkbox labeled "Allow other SQL Servers to connect Remotely to this SQL Server using RPC" on the Connections tab of...

A much needed topic indeed, Did you have any problems with recompiling the code that calls the procs? It seems that by renaming the proc, you now have to go...

Well it may not be a default thing. It is on all of our servers ( I have inherited some lovely setups) and with a name like server I...

Thanks for the info.

So as far as user access, you would have to use a standard login to connect to the SQL server, since your web server would not...