Any select query with aggerate function requires a GROUP By clause with columns list to be grouped on.

Use .NET App for parsing this xml file into a DataSet hen you can use this Dataset for saving in SQL

It wont allow entry with the date less than 23/05/2013 as we are checking max departure date in the procedure

DECLARE @OutPara

EXEC @OutPara = dbo.Proc Parameter

ReIndex all the Indexes from the Databases.

EXEC sp_msforeachtable @COMMAND1="PRINT '?' DBCC DBREINDEX('?','',80)"

GO

Update all Statistics from the Database.

EXEC SP_UPDATESTATS

GO

sqlnaive (5/23/2013)

---

Why not try three different triggers rather than using one ?

If you insist on making just one trigger based on all events, here is what you can do inside...

why I suggested this because the file missing error showing that it searching for .net framework 2.0 file and folder.. am Not Sure.. you can give a try and check,

Instead of triggers you can use OUTPUT Parameter, Like Below.

--- For Insert ---

INSERT INTO TableName

OUTPUT INSERTED.* INTO ToTableName

VALUES

---

--- For Update ---

UPDATE TableName SET ColumnToupdate

OUTPUT deleted.* INTO ToUpdTableName

---

--- For Delete...

chandan_jha18 (5/23/2013)

---

Thanks Bhaskar. Will try this option once to see how it works. I have a question though. Lets say that the replication is running for 1 subscriber and I...

Try Replacing 'NULL' WITH NULL (i.e. Removing Single quotes from NULL value), and there are some problem in the value list pass by you.

Try connecting Snapshot agent using Sql Server User Credential.

Try installing .Net Framework 2.0 the error shows the file missing for v2.0

Phil Parkin (5/23/2013)

---

Your statement:

Is plainly wrong - I proved it in code. And now...

chandan_jha18 (5/23/2013)

---

Bhaskar.Shetty (5/23/2013)

---

Another option other then suggested above would be, Initilizing the subscriber from backup, this saves a lot of time of applying snapshot to subscriber,

The intial snapshot apply...

Phil Parkin (5/23/2013)

---

Before making blanket statements like this, I find that it...