I didn't see on which version of SQL Server belongs this question, I concentrate on the code and sure that miss the correct answer couz in declaration of the variable...

Sure that you should have backup valid file (if you test the restoring these db when you take the backup)!

And also some other things like "Overwrite the existing database", ...

You can find many applications that can do intellisense for SQL Server 2005 even for SQL Serve 2000! - But sure that you should buy it!

😎

Thanks for the people who are posting the solutions and it might be ok, but if you want the best solution for you problem ...see my signature!

No! Without tables structure and some sample data you don't get the correct answer, anyway you should follow the rules to post the problem and it is describe in my...

For the Null values try to use ISNULL if you can do something so for better solution read my sig !

more info here: http://msdn.microsoft.com/en-us/library/ms184325.aspx

wow what about sys objects! in the question doesn't mention about user or system objects so for that reason the question include also the system objects - and sure that...

...or you can do Import/Export from one database to another database!

Nice code here Rob, you used some functions and joins and seems very nice alternative and somebody sure that will learn something else for the same thing!

Ok for you information about UNION!

UNION - select distinct values or better to say removes duplicate values

UNION ALL - select all values available and much faster than UNION!

So, if you...

I don't know which environment you are running (Production or Test - Development) but seems that you should uninstall and reinstall again you SQL Server!

Consider this as the last thing...

scott macleman (6/19/2009)

---

I dont think that will work - allow an example with more realistic data

Name Mark Position

Smith 76 ...

It would be better if you post the structure of your tables and some sample data - the result set that you want to see... and I'm sure that somebody...

Steve Jones - Editor (6/18/2009)

---

I voted MVP, because I think it has more recognition, and it's more likely you can attain it. Both require hard work, but the MCA requires...

After you read for the sp_rename try this:

SELECT 'EXEC sp_rename

@objname = ''' + TABLE_NAME + '.' + COLUMN_NAME + ''',

@newname = LOWER(''' + COLUMN_NAME + '''),

@objtype =...