Viewing 15 posts - 106 through 120 (of 263 total)
Have you tried setting your database to trustworthy and registering the interop dll with permission_set = unsafe?
June 21, 2012 at 3:52 am
OK this is really strange.
If I run this:
SELECT dbo.MyClrFunction(sDateField)
FROM #myTempTable
it works fine on 18000 rows.
If I run this:
UPDATE #myTempTable
SET sDateField2 = dbo.MyClrFunction(sDateField)
FROM #myTempTable
I get the errors and have to drop...
June 18, 2012 at 6:01 am
Thanks - this would be a nice test for a practical interview if hiring for a DBA. Corrupt a bunch of things in advance and show the interviewee the DBCC...
May 4, 2012 at 3:21 am
Thanks Robin thats a good tip.
DB is 21GB and indexes are all up to date. I think it was some kind of lock error rather than a performance issue. Restarting...
May 3, 2012 at 8:48 am
Cool cheers 🙂 I'll save that one in my useful scripts folder.
May 3, 2012 at 8:39 am
Hi Robin,
Yea it fails each time.
Can't see anything in the event logs at all but I noticed that this:
http://support.microsoft.com/kb/2679255
Is awaiting installation on the server.
Don't know if that might be...
May 3, 2012 at 8:26 am
Just restarted SQL Services and it's working again.
Am I loosing my marbles?!
May 3, 2012 at 7:44 am
I for one am an Analyst Programmer with some SQL responsibilities on top, not a full on DBA.
This kind of thing is useful to me if I'm writing a application...
April 27, 2012 at 5:15 am
All the procedures in question are indeed part of the dbo schema.
this makes things much easier than I expected!
Thanks
February 29, 2012 at 8:46 am
Oh wow that's pretty cool
Thanks mate.
February 29, 2012 at 8:36 am
Ah cool. As expected it worked fine on 2k5 when I set the data type to DATETIME
Looks like a really useful funtion. I shall be using it a lot...
February 2, 2012 at 2:28 am
thanks david, that looks like it's going to be the easiest way of sorting it out. except when I try to create the stored procedure to call... that wil fail...
February 1, 2012 at 6:39 am
Yeah I guess but I hate Dynamic SQL. there has got to be a better way of doing this - are there any hints you can add to stop it...
February 1, 2012 at 5:05 am
sdownen05 (11/1/2011)
November 1, 2011 at 9:17 am
Viewing 15 posts - 106 through 120 (of 263 total)