That's what I thought.. Thanks so much for your input.

Thanks. I'll heed to your advice!

Yes.

Hi Jason,

I got it situated now. I was probably doing the wrong thing. Thanks for your help 🙂

I get this errors while trying to restore to the new database:

"Restore failed for sqlserver 'Servername"

"System.data.sqlclient.sqlerror: The backup set holds abackup of a database other than the existing 'newdatabase' database"

Please...

Backing up the current database and restoring it to the new database?

Thanks guys. I took the database offline and brought it back online below are the steps I followed:

STEP1: identify the db status:

use master

select databaseproperty(‘db_name’,'isShutdown’)

Most of them it would return 1...

I wouldn't want to do that either. I guess they'll just have to do the modification on the report. I appreciate your efforts. SSC rocks!!!!

Hi Lowell,

That's exactly what I'm trying to do add a calculated column to create the desired version and leave the original integer data untouched but i don't to Alter any...

Thanks you guys are great. Your information are helpful

Thanks for your response. Actually this Unique Ids are not integers, they are just numbers already generated for every employee in my organization. So, they wanted leading zeros included for...

Thanks

Thanks guys. It worked. Appreciate it

I have some data currently in my table and I want to flush them and add a new set of data. So I thought setting the Primary key to zero...

Thanks you so much. It worked!! I appreciate your effort.