Just FYI, I test the case of objects owned by a renamed user and here was the results. The owner name changed automatically. If any of the owned objects specify...

You response to anyone coming to your desk is:

"I am looking into it." or "Give it a moment, it got blasted for reports."

The problem I always found from the developer stand point is that we understand how it should work and tend to not find the errors because we don't throw curve...

I believe it will require you to use the 16 client, I don't know for sure if the 32bit client supports otherwise and cannot get any answer from the guys...

I don't think Steve meant the MDAC components but the ones from SQL itself. Usually found under C:\Program Files\Microsoft SQL Server\80\Tools\Binn or some variant are the files (custtask.dll, dtspkg.dll, and...

Have you applied SP1 or SP2? If not I would suggest applying, there were several fixes related to Agent in SP1 and there was also a similar message to the...

Thanks I never saw that SP, gotta try it next time, will save me oh so much hassel.

You could do it dynamically by building a the SQL string in a variable object concatinating the names in the way you want and then executing the variable.

Ex.

DECLARE @SQLStr AS...

Just think of all the poor DBAs who know SQL being told now they will have to support VB, PERL, C(all versions), COBOL or any other language. Imagine the job...

As I said I did not test that need. But when you add a database to another server where it did not exist before if you have any user logins...

I am doing fine with the 8+clients but I have had several datatype issues I had to handle by doing a to_char or to_num when pulling.

That's ok.

From my understanding there is no way. I have tried that again today just to be sure. However if you find a way let us know for sure.

So let me make sure, you want to have a link on your SQL Server to the Oracle DB, not the other way around?

I did a test restore from a SQL 7 Server to 2000 and had almost no trouble (only server differences in file structure I had to account for). You most...