SELECT replace(replace(Address,',',''),'#','') AS Address FROM <TABLE_NAME>

Execute following query in query analyser & select opction "result to file" & you will get what you want.

SELECT +'INSERT INTO <TABLE_NAME> VALUES ('+ cast(Column1_NAME as varchar),cast(Column2_NAME...

There is no such script for this, but you can still achieve it be running the trace on the server enabling insert update event on the required db.

Another way of getting your required output with my own example.

Run the below query in single batch.

--------------------------------------------------------

create table #ps_t1 (sno int identity(1,1) , sname Varchar(10))

GO

insert into #ps_t1 values ('ra')...

Alex,

What i feel here is using temp tables in DTS is the best option as it will be faster as well as automate solution which is your requirement here. You can save...

Check if the id by which you are acessing sql server has dbo access on the server.

For bringing db to its normal state you may need to restore the db from latest db backup.

Even if their may be other options, db restore is always recommended.

Check if some other job is running at the same time when backup is running, because this may hold backup operation till it gets completed.

Backup job comes...

Set query timeout property to unlimited & try to run you creat job script again.

-------------------------------

Prakash

System administrator (sa) is a special login provided for backward compatibility. By default, it is assigned to the sysadmin fixed server role and cannot be changed.

Login "sa" cannot be dropped...