Viewing 15 posts - 2,806 through 2,820 (of 9,643 total)
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...
September 21, 2010 at 6:08 am
yonatam (9/21/2010)
just got the solution in another place, it should have been:dbo.F_TBL_VALS_FROM_STRING(''' + @doorList + ''')
instead of
dbo.F_TBL_VALS_FROM_STRING(' + @doorList + ')
That's exactly the solution I gave.
Whenever you are working with...
September 21, 2010 at 4:59 am
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...
September 20, 2010 at 7:27 pm
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...
September 20, 2010 at 7:21 pm
Why not attachthe trace file here, or just post the offending T-SQL Statement that you have found in the trace.
September 20, 2010 at 7:08 pm
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...
September 20, 2010 at 7:06 pm
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...
September 20, 2010 at 7:01 pm
Seem like you need another CTE. Something like (since no data is provided this is untested):
;WITH SessionAlloc AS
(
SELECT
visit_id,
user_id,
...
September 20, 2010 at 6:44 pm
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...
September 20, 2010 at 6:34 pm
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...
September 20, 2010 at 6:27 pm
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...
September 20, 2010 at 5:27 pm
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.
September 20, 2010 at 5:24 pm
Are you saying that you created an index in SQL Server and it took a full day to finish?
September 20, 2010 at 5:09 pm
Have you validated that the variable, :nNextMenuConfigID is being incremented when you run the insert statement?
September 20, 2010 at 2:44 pm
My guess would be your tape backup is happening at that time.
September 20, 2010 at 2:37 pm
Viewing 15 posts - 2,806 through 2,820 (of 9,643 total)