The error message you have reported would indicate that along with "moving the server" the security policy has changed, or a dependency of the CLR procedure is missing. If...

No, I was referring to using Windows Explorer to view the filesystem, and if you view the folder where your dumping logs to, if you have 20,000 odd files in...

I've used the same method of dropping TLogs to the file system and having a script maintain the folders to keep a rolling 5 days of logs.

Three things I've discovered...

The links to UPDATE are to the UPDATE() function, not the UPDATE statement syntax, which is 1 line above in the index. 🙂

Matt Miller (3/13/2008)

---

If you want to go for new - take a look at the OUTPUT clause for an insert statement. You shove the records in without the unique...

The need to return the EntityRef identity value from the Entity table to insert into the Address and EntityCustomAttribute table. As FK's they cannot be null, and the Key...

I would like to keep an open mind on this but until someone can demonstrate a straight-forward example of cursors being necessary (except for the case that I cited above)...

As the previous posters have said, you need to provide more information (DDL, sample data or at least row count in each table, complete SP) to receive any reasonable help.

You...

I would try and get rid of the order by, so you don't need to use dynamic sql, and instead let the application perform the sort based on user selection...

yes it does.

amending the above example slightly.

create table tutu (fid int constraint ix_tutu_fid primary key nonclustered )

sp_helpindex tutu

-- ix_tutu_fid nonclustered, unique, primary key located on PRIMARY

create unique clustered index...

So a "rowtype" marker is what I said before, that there should be some defining flag/feature or if you like value or attribute that indicates that this row has different...

And how do you know that the format has changed rather than just failed a validation, without some defining flag/feature to indicate a different type of record?

That depends (as per everything).

When you have logical files within a physical file, or if you prefer, batches...

having had to do this in the past you have two choices.

Use all the pads and trims and various other things your trying to avoid doing or

build a separate application...

The technical paper on Clustering indicates that this is possible due to the obvious reasoning of TCP communications occurs on an IP and Port level. As Virtual SQL instances...