Yes, CLR has a substantial number of limitations and it is very hard to tell if a custom or 3rd party DLL will work with SQLCLR, unless it has been...

WayneS (6/3/2009)

---

SQL Server Magazine just published an article by Itzik Ben-Gan where under certain conditions, a cursor-based approach scales out better than a set based one. I'm curious as to...

Yep, my bad on that one. Thanks for covering for me David!

Do you have Logging turned on? What does it say is happening?

sql server developer (6/3/2009)

---

Hi thanks for your reply.

IsNull() function in MS access checks whether the values is null or not.

But I want it in a way that if it...

I agree with Jack, the outer exception is pretty generic in this case, can you get the inner exception also? As Jack suggests, you may need to handle it explicitly...

Glad I could help.

Sorry, but No, I will not. Please go back and...

You can't reference a column's value outside of a query, your "IF dtOrder.." statement has no rowset to reference the column to. Try this instead:

CREATE TRIGGER trigger_PMS

ON ...

"First time" after what? What do you do that resets it?

Try the ISNULL() function instead.

The problem is that the error is being caused by some one or more of the rows that are filtered out by the other WHERE clauses. When you convert...

The only built-in alternative is Windows Scheduler, which works, but has considerably less than SQL Agent.

What I run into at many of my customers is whats known as an "Enterprise...

You were close. Try this instead:

DECLARE @SqlString VARCHAR(MAX)

SELECT @SqlString = 'ALTER TABLE ['

+ su.name + '].['

+ OBJECT_NAME(su.object_id) + ']'

+ CHAR(10) + 'ADD UniName VARCHAR(50) NOT NULL'

FROM...

I think that it depends on your Deployment and Maintenance scenarios.

As Greg mentioned, I prefer files so that I can more easily use VSS with them.

If you are deploying to...