Check BOL topic "CAST and CONVERT (Transact-SQL) " for all conversion info...

You don't need to use outlook for database mail...

See the database mail setup article...

http://www.sqlservercentral.com/columnists/cBunch/introtodatabasemailinsql2005.asp

OpenRowSource and OpenRowSet in SQL Server 2000

http://www.databasejournal.com/features/mssql/article.php/10894_3331881_3

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

How to: Validate Data at the Subscriber (Replication Transact-SQL Programming) 

http://msdn2.microsoft.com/en-us/library/ms147366.aspx

You have to generate the ';' seperated list ...here is example...

declare

@i varchar(1000)

select

@i =

I was under the impression that he is using snapshot...

Thanks...

I tested it on my machine... it is working fine.. output is as follows...

Service Started.

Msg 22003, Level 1, State 0

(0 row(s) affected)

Under what login SQLagent is configured?

I didn't get your first question but the second question answer is ..

In Object Explorer, connect to an instance of SQL Server 2005 and then expand that instance

Expand Databases and then...

What do you mean by replication procedure?

SQL server has its own replication and the procedure will be created when you configure the replication...

For auto increment counter look IDENTITY topic in BOL...

OR

if you want manual use the query to get the max+1 value...

select @val = max(id)+1 from tabl...

Try exec xp_servicecontrol 'start' 'sqlserveragent'

Check the system table sysmaintplan_subplans and delete if any data related to your job exists in that table...

SELECT s.subplan_id

,s.subplan_name

,s.subplan_description

,s.plan_id

,s.job_id

,s.schedule_id

,j.name

FROM msdb.dbo.sysmaintplan_subplans s

LEFT OUTER...

Snapshot replication is snapshot at a single point so when it runs it will populate the all data it got in snapshot or it will fail...

Check BOL topic "Validating Replicated...

Right click in dts pacakge white pane/click properties/general tab ... at the bottom of the tab..

Change "Limit the maximum number of tasks executed in parallel" to 1 where as default...

INT is reserve word but not @int...when you add @ sign to a word it will be treated as local variable ... I think your application is the problem...

Is the...