I thought this was a well-written and clear article which helped me better understand working with the CLR. I still haven't found a need to do any CLR programming...

That's exactly the solution I gave.

Whenever you are working with...

sqlbuddy123 (9/20/2010)

Deprecated in SQL 2005, replaced by SSIS, should not be used for new development, will be removed in a future version of SQL Server.

________________________________________

Gail Shaw

We walk in the...

Not to throw a curve in, but I'd recommend looking at Ola Hallengren's maintenance scripts which are provided for free and regularly updated at http://ola.hallengren.com/. Better than maintenance plans...

Why not attachthe trace file here, or just post the offending T-SQL Statement that you have found in the trace.

Here's a query that gets it from the default trace:

With cteObjectTypes AS

(

SELECT

TSV.trace_event_id,

TSV.subclass_name,

TSV.subclass_value

FROM

sys.trace_subclass_values AS TSV JOIN

sys.trace_columns AS TC ON

TSV.trace_column_id = TC.trace_column_id

WHERE

TC.[name] = 'ObjectType'

),

cteEventSubClasses AS

(

SELECT

TSV.trace_event_id,

TSV.subclass_name,

TSV.subclass_value

FROM

sys.trace_subclass_values AS TSV JOIN

sys.trace_columns AS TC ON

TSV.trace_column_id...

Can you post the error?

The security best practices would say that you would create a specific role that has the needed permissions and assign each of those users to that...

Seem like you need another CTE. Something like (since no data is provided this is untested):

;WITH SessionAlloc AS

(

SELECT

visit_id,

user_id,

...

My first question is, what are you doing with the data that you need all the temp tables? That's probably a lot of spill to disk that might be...

You have to be careful with ISNUMERIC because it doesn't mean that the value will CONVERT/CAST to a numeric data type. For example '+' returns 1, nut CAST('+' as...

Licensing has always confused me, but I have been informed recently that developer edition is not supposed to be used for multiple user connections. I don't know if that...

Have you considered doing your development using Windows XP Mode? Not the solution that you are looking for, but it could help you move forward for now.

Are you saying that you created an index in SQL Server and it took a full day to finish?

Have you validated that the variable, :nNextMenuConfigID is being incremented when you run the insert statement?

My guess would be your tape backup is happening at that time.