Microsoft has a DLL help database which identifies all DLLs by version and applicability.  Check it out at http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp&fp=1

SET NOCOUNT ON Worked!  I figured it to be something simple but couldn't see the resulution even though I struggled with it.  Thanks to Mike Vessey.

Steve King

I knew the posted code had a problem but I made multiple attempts to get it functional prior to posting the question.  BOL was a source I accessed but frequently...

The 10000 limit may be an Access limit which I need to work around.  There is no Top 10000 in the T-SQL statement shown below although I've put the TOP...

The obvious solution to the above problem is:

SET ROWCOUNT = 0

Except that the sp is loading data to a local table on the same server from a different database.  The BOL...

Thanks for the responses.  I've implemented the following script based on some of the answers.  This script outputs exactly what I need and I generally use it in...

Thanks.  That recommended T-SQL script does a great job.  I'll create another script based on it to display the text.

I used the OPENDATASOURCE successfully in the query analyzer and saved a view.  When I try to open the view the following error is presented.  I have also received the...

A couple things I failed to mention earlier. First, I use an ADO object for the connection and stop the processing to use the debugger. When I check...

This also applies to identifying lower case alpha character like l, o that are supposed to be numeric. Selected depending on case. Since SQL Server is not case...

Thanks Mark,

I believe that's just what I could use. It's the obvious solution that I should have recognized; -- but didn't.

Steve

Since this is importing data from an external source I need to perform multiple checks to determine whether the data should be merged into the tables. How would one...

Here is an alternative function which uses the stored procedure name as a parameter and creates and ADO recordset. The recordset can then be assigned the the report...

After searching BOL for a solution I came up with this after correcting the example code and testing it in the query analyzer:

DECLARE @usr char(30)

SET @usr = user

SELECT 'The current...

I'll use profiler to see what is occuring. After reading my narrative I have decided it wasn't clear that I'm referring to separate tables. One where I can...