Hey farrell - haven't "seen" you in these here parts for a long time....been busy?!?!

As for this post of yours - it's the strangest thing - how can you...

yes - do this in query analyzer using the t-sql statement "restore database etc....."

unc stands for "uniform naming convention" and provides a unique address on a local network..

you won't be able to do this via EM - use the unc to restore over the network..

restore database dbName
from disk = '\\serverName\shareName\dbBackup.bak'

you can create a procedure that uses sp_rename...something like this:

create procedure sp_ChangeColumnName
@table_name varchar(50),
@old_name varchar(50),
@new_name varchar(50)
as

declare @sql varchar(150)

set @sql = 'sp_rename "' + @table_name + '.' + @old_name + '",...

this should give you a list of all indexes and keys...

select table_name, column_name, constraint_name 
from information_schema.key_column_usage
order by table_name

IBM creates Operating Systems - MS-DOSn't!

Microsoft broke Volkswagen's world record: Volkswagen only made 22 million bugs!

"Microsoft's biggest and most dangerous contribution to the software industry may be the degree to...

My bad...I shouldn't have said "batches"....was in a hurry...

BUT...when I do an "if count(*) = 0 etc..." I get the "columns doesn't exist" error - whereas when I send 2...

Just to explain - my method wasn't supposed to be dynamic....

I was doing it in 2 separate batches...works for me...can't figure out why you continue getting the same error msg...

That is spot on! I would even go so far as to say that oftentimes service (& peopleskills) win over even experience and knowledge - I'm not saying that you...

"... maybe one day people won't always fall for the bait.... sadly I though think some people just cant get along...."

'swhat I was getting depressed about...but then nothing quite like...

Remember the interview article that Sean wrote and the ensuing furore it caused...there were many "christians" who were gravely offended and have since unsubscribed from this site based on that...

coming back full circle to "freedom of speech"..

So much for free speech...."Anger has been spreading over the 12 caricatures of the Prophet Muhammad that were first published in Denmark's Jyllands-Posten...

sowmiya - it may be too late at night for me to respond coherently - - but a couple of things in your...

Don't know what the rest of your code looks like but here's something google threw out that may help you...

arguments are of wrong type

Here's one way to do it...

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'RESULTS'
AND COLUMN_NAME = 'TOTAL_VOTES'
IF @@ROWCOUNT = 0
BEGIN
    ALTER TABLE [dbo].[RESULTS] ADD [TOTAL_VOTES] int not NULL...