Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Visibility Expand / Collapse
Author
Message
Posted Tuesday, September 17, 2013 8:21 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:02 PM
Points: 998, Visits: 2,280
Very New one, thank you for the post, Steve.

I never knew, never used and not sure if I am ever going to use... but weird part is I got it right... after reading and staring at the options ... i thought (like all times.. in a class module when the procedure/function when created as "private" it is not visible in the instance of the class) this might me and picked the 3rd one.

Where is this option can be seen? it can be sql scripted or is this needs permission in general?


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1495525
Posted Tuesday, September 17, 2013 8:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:12 AM
Points: 7,791, Visits: 9,545
Raghavendra Mudugal (9/17/2013)
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)

Shouldn't that be "only.. 1 and 100 applies" ?


Tom
Post #1495534
Posted Tuesday, September 17, 2013 2:17 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 10:48 AM
Points: 4,126, Visits: 3,427
Nice one - thanks, Steve!
Post #1495667
Posted Tuesday, September 17, 2013 3:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 2, 2014 7:35 PM
Points: 64, Visits: 93
Picked the one that makes the most sense.
Post #1495696
Posted Thursday, September 26, 2013 3:23 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:50 PM
Points: 17,807, Visits: 15,727
L' Eomot Inversé (9/17/2013)
Koen Verbeeck (9/16/2013)
Nice one. Will probably never use it though

Oh, you might just get caught up with it quite by accident. It used to be true, and may still be true, that if the assembly was explicitly loaded by create assembly in SQL it would be visible( until changed), but if it was loaded implicitly because another assembly needed it it wouldl be marked invisible, so you wouldn't be able to call it directly until you changed it, and you wouldn't be able to change it until the other assembly goes away; so it was possible for an assembly to be invisible without you intending it to happen, and that could be a nuisance. But last time I looked at CLR was years ago, so some of that may have changed since. And I might be misremembering, as I never actually used this stuff, just read about it to see whether it was anything that might justify the cost of upgrading ourselves (and our customers) to SQL Server 2005.


+1




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1499081
Posted Tuesday, October 1, 2013 3:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 10, 2014 7:07 AM
Points: 3,545, Visits: 2,654
Good QOTD.
Post #1500322
Posted Thursday, October 10, 2013 7:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 3:24 AM
Points: 1,144, Visits: 299
used it 1 time about assembly for geometry type (ggogle map like)

forgotten it since

+1

but +1 for google (my friend) !
Post #1503551
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse