I made a simple procedure some time ago which does what you are looking for.

ALTER    PROCEDURE sp_Unzip (@SourceDir VARCHAR(100), @DestinationDir VARCHAR(100), @ZipFile VARCHAR(100))

AS

-- DECLARE @SourceDir VARCHAR(100), @DestinationDir VARCHAR(100), @ZipFile VARCHAR(100)

--...

BOL is very clear about this...

CREATE PROCEDURE au_info2

   @lastname varchar(30) = 'bla'

AS

this sets 'bla' as the default for @lastname. When executing it looks like this...

execute au_info2 @lastname = 'blabla'

now...

What I did for one of my projects, was create a SP which is started from an insert trigger.

This SP then creates a new unique job using newid() as the...

Why not just use a tool called DTS Backup??

For more info check...http://www.sqldts.com/default.aspx?242

Read BOL first...if you have anymore question after reading BOL, just ask.

There are various ways of doing this. One of which is as follows

1. create 2 SQL connections, one to each server

2. create a "data transformation task between the 2 servers

3....

All,

The problem has been solved by storing the data into a table using NEWID() as the table name. The stored procedure the creates a job (also using newid() as the...

Try this.

http://www.sqldev.net/xp/xpsmtp.htm

It's SMTP based so you don't need the server agent to have a mail account.

see if this works....

1. store data into excel sheet with temp name

2. copy the excel file to a file with the correct name via an activex task using fso

3. send...

what aboout this...

declare @rowcount tinyint

declare @row tinyint

select blablabla this returns your 5 records or whatever the number maybe

@@rowcount will tell you how many rows were affected by your previous statement,...

Why not store the 1million correct records into some table and truncate the ori table and insert the 1million back??

Have you looked at the RedGate tools??

http://www.red-gate.com/

I use them all the time and make things a lot easier.

Good luck.

Cheers,

Rob