in order to restore the database which is already exits you need to check the mdf ,ldf and ndf (if any) check where is is storing and check the file...

please check if you have any proxy account and which is having account access

remove the configuration file parameter, if you use the configuration file it will have all the parameter you want to install. so wither you use configuration.ini or remove this file...

we cannot see the attach document , so attached the screen shot

you can use truncate table "tablename"

this statement will remove all the rows in the table.

you can change the sql server port via configuration manager

can you check what is the configuration.ini file has , please share

you are moving the data disk from one server to another server physically make sure this done properly.

i suggest to take the full backup of all your databases once the...

you need to run the following in order to see the advanced options

EXEC sp_configure 'Show Advanced Options',1

RECONFIGURE

why you need the stored procedure to delete your tables from your code you are deleting all the rows.

what you want to do please explain in detail so that...

hope this help to solve your problem

select stuff(stuff(SUBSTRING([phone number],3,10),4,0,'-'),8,0,'-') from tbl_sample

You can use the following query to format the phone number.

select [Phone Number],stuff(stuff(SUBSTRING([phone number],3,10),4,0,'-'),8,0,'-') [Formated Phone Number] from tbl_sample

if you need any more help let me know

error says table variable must declare can you share the full script will be easy to find where this missing to get the reference .

after you have created the vm have activated the OS. because after windows 2008 all the activation happening via online/phone. every time you provision even though your vm template is...

compare the IO statistic on the Guest and VM level and you can found where the problem is. very bad idea to keep it like this.