What I mean is when calling OPENDATASOURCE you have to specify a user id and password. What if the server you are trying to connect to has all logins based...

Continuing on with this topic, what do you do if you want to use Windows authentication with OPENDATASOURCE?

What about checking for the existance of a stored procedure?

Thanks for the input. If you read about the information_schema views in msdn, it makes it sound as if it wasnt supported until 2000 and I did not have a...

specifically, the version will be Mac OS versions. I am not sure if they will always be in a fixed format or not. The data I do have looks like...

What if the version can be any length

ie - xx.xx.xxx or xx.xx.xxx.xx

I think you wil want to create a string and then execute it like so:

DECLARE @strsql nvarchar(1000) -- however long it needs to be

Then make all your sql statments strings...

for date I think you want to use CONVERT(VARCHAR, [date_expression], 101) - this will give you mm/dd/yy;

for time CONVERT(VARCHAR, [date_expression], 108) - this will give you 00:00:00. Is this want...

Try this:

SELECT IDENTITY(int, 1,1) AS [ID], blah0, blah1, blah2 INTO xTable

FROM blah_table

This will create the table xTable with your result set and an identity column. You can then select from...

Yes it does now. I had no idead that you could 'get' a value with an update statement.

I have been playing with this and thought I understood. What i really dont understand is how do all the variables get set with an updated statement. It appears to...

I had to do something like this recently. I did it a little differently. Fist I formulated my sql query with an INSERT INTO xTable and inserted an identity column...

Ok, I get it now. Thanks for all the help.

I am entirely confused by the last posting. Can you explain a little better?

All I have at this point is the query. Some of the values return as NULL which need to be replaced with the preceding value. You mentioned saving the columns...