I believe I was able to create the clr stored procedure in visual
studio, set 'clr enabled' on the server, create an assembly, create an
sp based on the external name, and finally EXEC it from T-SQL to call
it. When I call it, I get the System.Security.HostProtectionException
below.
Here's the URL for an article I wrote to help with this kind of thing. Its
the same idea the BOL covers, but in more tutorial fashion.
Re: Replicating database schema changes in "daisy chain" situation ... create database central...exec sp_replicationdboption 'central','merge publish','true' ...SQL Server B> is installed in another country and replicates key master data from server A.> MSDE Instance C replicates with Server B to receive this master data as well> as merge data that is shared only between B and C. ... (microsoft.public.sqlserver.replication)
Re: Verwaiste Benutzer ... > jedoch fehlt die Zugriffsberechtigung auf den Server.... > Muss ich jetzt tatsächlich allen Benutzern neuen Zugriff ...EXEC sp_configure 'show advanced options', ... WHERE name NOT IN (SELECT name FROM master.dbo.sysxlogins) ... (microsoft.public.de.sqlserver)
Re: Share Point Services ... Change the database ownership and permissions for the configuration database ...Microsoft SQL Server, and then click Query Analyzer....EXEC sp_changedbowner @AdminVSAccount; ... (microsoft.public.sharepoint.windowsservices)
