The database is not corrupt and is accessible  normally.

no there isn’t any existing db with the same name.

i had deleted tables which were user n type TT but don’t want...

Yea we went from SQL 2012 to SQL2017.

We cannot put our systems back to 110 since other product would be impacted.

Morever, forcing old query plan would be bad idea. With...

thank you
But using both the above methods i get rows only with "error" while i want rows above error and below error.

I can achieve this with cursor...

Thanks for the valuable inputs.

I have the script already, dealingwith 50+ db over 500gb size.
Its a quarterly restore yet! Just re- writing to extract the physical file...

Yea I've used FILELISTONLY and HEADERONLY  to get the information.
But I' m stuck at: The DB already exists on server and I have to place the data/log files at...

Thanks All.

Its sad that only hard coded date needs to be given. I was wandering of having a variable and scheduling a job so that I don't have to change...

Full_backup with copy_only is required for some other purpose.

and as for weekly full backup rather than daily, there are few overheads like space (we have 8 diff QA env, with...

[/quote]

How about creating the new column and filling it with the converted data, add the appropriate indexes, then convert the old column to a computed column? Your existing code...

even the renaming will not be allowed since SP are dependent.

We are looking at any Third party tool since the code will eventually promote to Production environment where its more...

When I try to drop old column it passes an error of dependent Stored procedure.

I can drop the index and recreate them however I do not want to the SP...

changing from nvarchar to int

How about if there is only db name in function? How will RG behave when there is failover etc?