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 Monday, September 16, 2013 10:44 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:43 PM
Points: 33,046, Visits: 15,152
Comments posted to this topic are about the item Visibility






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1495366
Posted Monday, September 16, 2013 10:59 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 12:25 AM
Points: 445, Visits: 565
Start your day with some learning
Post #1495368
Posted Monday, September 16, 2013 11:56 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
Nice one. Will probably never use it though



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1495374
Posted Tuesday, September 17, 2013 3:54 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:18 AM
Points: 475, Visits: 245
Koen Verbeeck (9/16/2013)
Nice one. Will probably never use it though


+1
Post #1495421
Posted Tuesday, September 17, 2013 3:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 31, 2013 11:22 AM
Points: 160, Visits: 231
Interesting that you cannot change the visibility once you have objects referencing to it.

I understand that if visibility is ON and there are already non-CLR object referencing an assembly. Then you should not be able to switch it to off.

But being invisible first: Why is it then blocked to make it visible?

Nice question to see what I do NOT know


________________________________________________________
If you set out to do something, something else must be done first.
Post #1495422
Posted Tuesday, September 17, 2013 4:58 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: Yesterday @ 10:54 AM
Points: 3,847, Visits: 4,984
Interesting question, thanks Steve
Learned something interesting today...


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1495443
Posted Tuesday, September 17, 2013 5:34 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, July 18, 2014 2:05 PM
Points: 3,943, Visits: 2,957
I just got to learn something new. I prefer to stay within native SQL where possible, but it's still good to learn new things. Thank you.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1495453
Posted Tuesday, September 17, 2013 6:30 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:53 PM
Points: 8,543, Visits: 9,030
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.


Tom
Post #1495474
Posted Tuesday, September 17, 2013 6:54 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 532, Visits: 447
Good one, thanks!
Post #1495485
Posted Tuesday, September 17, 2013 7:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 1,823, Visits: 1,356
Ed Wagner (9/17/2013)
I just got to learn something new. I prefer to stay within native SQL where possible, but it's still good to learn new things. Thank you.

+ 1




Everything is awesome!
Post #1495511
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse