The user is in the domain Admin group, so yes, they are also a member of the local admin group

Andrew

I have tried that. Still the same error

Thanks

Andrew

Thanks

I was thinking about the sysobjects table.

SQL 2005 has the items named appropriately, where SQL 2000 was not as much

Thanks

Andrew SQLDBA

That would mean that you as an AD User, can only be a member of one group. You need a table that lists all the Group Names, and then an...

Thanks Everyone

I think this was so simple that I could not think clearly about it.

I had the concatenation part correct, I was thinking that the update would be more complicated....

That just doesn't make sense. You want to add new records, of the same information, to each table?

That sounds like your database needs to be redesigned. You should never have...

Thanks

That was perfect, just what I needed

Have a good one

Andrew

Thanks

I will give this a try.

We use the same comment section at the top of the procedure. I have been using that comment block since about 4.2

Thanks for your help...

Thanks for your input on this. Do you know what table that I can query to see the settings? I would like to try and see what some of the...

That is fine, but do I change? I cannot go thru everything about that database making modifications.

Thanks

Andrew SQLDBA

They said they do not know. There are actually 7 databases that support this one app. None of the others have this problem. I can modify that setting on all...

Why would you ever want to use an old ODBC connection to communicate with a modern day OLEDB / ADO database? You should never use ODBC to connect to...

That is what I thought also. I have tried to explain that to the company that wrote this aweful piece of software. I wish that the Exec's would have had...

It is much easier to create a user in SQL for this specific task. Use SQL Authentication. Trying to use Windows Auth in a web environment is difficult. I am...

Can you elaborate on that just a little bit? Maybe a simple code sample?

Thanks

Andrew