First things first. Run the following to see the status of the CLR hosting:

SELECT *

FROM sys.dm_clr_properties;

You will see something like the following if all is...

sql_lock (3/26/2010)

---

Steve, sorry to hijack this posts... But if you have 15 minute logs backups and P2P replication could it lead to lost transations when the backup takes place and...

It might be. Turn intellisense off and see if it goes away?

Is it causing a problem?

Why would you use a CLR trigger here? A T-SQL trigger seems a better idea.

Or upgrade to 2008 and use Change Data Capture.

I don't want to sound harsh, but this is a...

Kingston Dhasian (3/26/2010)

---

SELECT ROUND( -0.6401, 0 )

The above statement gives me an error saying An error occurred while executing batch. Error message is: Arithmetic Overflow. I get the error for...

No worries.

You can't. Used to be able to, a long time ago, but no longer.

If you really need to remove something, edit the post,...

Quatrei.X (3/26/2010)

---

btw guys, how do you know if someone replied to you in a forum or posted something in the same forum you posted? I mean do you have any...

Thank you, Arjun.

I...

Hey everyone, you probably won't believe this, but the following performs pretty well too. Two milliseconds elapsed for the 151 row generating sample data. Nested recursive CTEs wrapped...

Nugby (3/25/2010)

---

Had thought this thread would be closed now but I'm thinking I should edit the original post in case anyone else has a crack at it. Thanks for looking...

Very scary.

Just thought of a much better option than using EMPTYFILE: use the CREATE INDEX ... WITH (DROP_EXISTING = ON) ... ON {new filegroup} syntax. This will move the data...