Copy and Paste multiple-line text directly in results pane

In SQL2005, I was trying to copy multiple-line text from notepad and paste it into SQL results pane to modify the data directly. But I could only write the first line into the database.

I used to do this in SQL7. It worked fine. Now we just converted the system to SQL2005. This functionality seems to be gone. Is that true? Can somebody confirm this or give out the solution of this issue?

Thanks.

Nobody answers? Please ...

Thanks.

Copy and Paste multiple-line text directly in results pane

In SQL2005, I was trying to copy multiple-line text from notepad and paste it into SQL results pane to modify the data directly. But I could only write the first line into the database.

I used to do this in SQL7. It worked fine. Now we just converted the system to SQL2005. This functionality seems to be gone. Is that true? Can somebody confirm this or give out the solution of this issue?

Thanks.

Nobody answers? Please ...

Thanks.

copy a job

Hi,
I need to copy a job to the same istance of Microsoft SQL 2000 (SP4). I'd
like to rename it modify some parameters and re-schedule the database.
I can't find nothing for copy or duplicate the job.. any help? by Enterprise
Manager and Transact-SQL?
Thank's
AndreaRight-click the job, select All Tasks > Generate SQL script. Specify a
filename and click OK.
This generates a script which you can modify and then run to create a
new job.
David Portas
SQL Server MVP
--

copy a job

Hi,
I need to copy a job to the same istance of Microsoft SQL 2000 (SP4). I'd
like to rename it modify some parameters and re-schedule the database.
I can't find nothing for copy or duplicate the job.. any help? by Enterprise
Manager and Transact-SQL?
Thank's
Andrea
Right-click the job, select All Tasks > Generate SQL script. Specify a
filename and click OK.
This generates a script which you can modify and then run to create a
new job.
David Portas
SQL Server MVP

copy a job

Hi,
I need to copy a job to the same istance of Microsoft SQL 2000 (SP4). I'd
like to rename it modify some parameters and re-schedule the database.
I can't find nothing for copy or duplicate the job.. any help? by Enterprise
Manager and Transact-SQL?
Thank's
AndreaRight-click the job, select All Tasks > Generate SQL script. Specify a
filename and click OK.
This generates a script which you can modify and then run to create a
new job.
--
David Portas
SQL Server MVP
--