Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, September 16, 2016 10:22 AM
Points: 1,574, Visits: 2,958
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:39 PM
Points: 9,700, Visits: 11,744
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 5,331, Visits: 4,503
Nice one - thanks, Steve!
Post #1495667
Posted Tuesday, September 17, 2013 3:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, January 20, 2016 3:54 PM
Points: 82, Visits: 126
Picked the one that makes the most sense.
Post #1495696
Posted Thursday, September 26, 2013 3:23 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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: Monday, May 23, 2016 5:31 AM
Points: 3,615, Visits: 2,774
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