Hey Gila

Yes, I do the same, but I indicate such and surround the fake table name with tags to give a visual indicator.

ie....

<TableName>.<ColumnName>

Andrew SQLDBA

Hey Sean

You are exactly correct. I should have offered some explanation like you did. I like the way you explained why and gave a nice example.

Andrew SQLDBA

I mean this in a nice way.

That is a horrible naming convention that you have. Please change that mess. How in the world do you have any idea what is...

I have to say this, and I mean it is a nice way.

That is just horrible naming convention for your database objects.

Please change all that. truly the worst ever.

Andrew SQLDBA

Thank You Everyone

All your suggestions and samples worked perfectly.

Andrew SQLDBA

Thank You very much,

That is perfect, does exactly what is needed.

Greatly appreciate it

Thanks again

Andrew SQLDBA

Thank You Mister Magoo

That worked perfectly

Thanks for the suggestions everyone, just way overkill for what was actually needed.

Andrew SQLDBA

For one thing, I do not have a Tally table setup on the server in which I am working.

So, are there any other ways of doing this without a tally...

I was actually looking for something else. That really did not help.

Andrew SQLDBA

Thank You to everyone

I have been working with TabLockX, wrapped in a transaction. And I changed the code to perform everything all together. Seems to do the trick

Thanks again to...

I am working with that now. But if I just query the two tables, I am getting a huge number of rows back, when I know there are only two...

You can try renaming the database database

EXEC sp_renamedb 'oldName', 'newName'

Or you can detach it and attach it again, giving it a new name and a new location on the...

I see now, that entire path statement is your database name. You do not name the database as a path statement to a file. SQL does not work that way....

A couple things.

First

You should Never, Ever use the SysAdmin account for any app/website to database connections. That is for a SysAdmin only.

Second

What is your front-end app? That connection string...

Thank You Everyone

I needed a query to select the correct script that included all the table names for a particular database, and change the owner to a different schema. I...