BenWard

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 264 total)

RE: Need to install C# dll which refers an Interop dll

Have you tried setting your database to trustworthy and registering the interop dll with permission_set = unsafe?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

June 21, 2012 at 3:52 am

#1503838
RE: I think I'm triggering a failsafe on a remote database...

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

June 18, 2012 at 6:01 am

#1502193
RE: How to Create a Corrupt SQL Server Database

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 4, 2012 at 3:21 am

#1483433
RE: why does sqlserver not like the value: 2 ? ? ?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 3, 2012 at 8:48 am

#1483081
RE: why does sqlserver not like the value: 2 ? ? ?

Cool cheers 🙂 I'll save that one in my useful scripts folder.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 3, 2012 at 8:39 am

#1483076
RE: why does sqlserver not like the value: 2 ? ? ?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 3, 2012 at 8:26 am

#1483065
RE: why does sqlserver not like the value: 2 ? ? ?

Just restarted SQL Services and it's working again.
Am I loosing my marbles?!
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 3, 2012 at 7:44 am

#1483028
RE: Run SQL Server Scripts using C#

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

April 27, 2012 at 5:15 am

#1480293
RE: quick question on securables

All the procedures in question are indeed part of the dbo schema.
this makes things much easier than I expected!
Thanks
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 29, 2012 at 8:46 am

#1453214
RE: quick question on securables

Oh wow that's pretty cool
Thanks mate.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 29, 2012 at 8:36 am

#1453205
RE: INSERT OUTPUT

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 2, 2012 at 2:28 am

#1441622
RE: INSERT OUTPUT

DATE is not a valid data type... ?
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 2, 2012 at 2:14 am

#1441604
RE: try/catch halting on error... am I missing something?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 1, 2012 at 6:39 am

#1441188
RE: try/catch halting on error... am I missing something?

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...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

February 1, 2012 at 5:05 am

#1441131
RE: Need to consolidate data from Multiple EXECs

sdownen05 (11/1/2011)
Sorry, folks, I didn't mean to cause a stir like this. However, I will learn from this and make sure I specify whether ir not it is for multiple...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 1, 2011 at 9:17 am

#1401690

Viewing 15 posts - 106 through 120 (of 264 total)