Code Snippets

I am looking for a sample code to write a tool or a 3rd party tool that will enable me to get the same functionality as visual studio 2005 code snippets in SSMS.

We do not expose the necessary interfaces to have 3rd parties plug-in their components into SQL Server Management Studio in SQL Server 2005. We are looking at this for a future release. We do have a Template Explorer, which may be of use in the meantime.

Using SQL Server Management Studio Templates
How to: Use Templates in SQL Server Management Studio

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Maybe you are looking for something like this (with sourcecode)

http://www.codeproject.com/useritems/enisey.asp

|||

Paul I was able to use the templates, its just that I was hoping for similar style of code snippets that Visual Studio has, where I could right click and have some of common tsql scripts available while using a query window. But for now the templates look better than nothing. I am not sure where to put in a suggestions, but that would be my first to have code snippets like visual studio 2005 uses in ssms.

Jurgen thanks for sending the like, but I am looking for more custom snippet storage not neccessarily code generation tools. But Thank you for the suggestion.

Thanks Troutbum!

|||

We have a customer portal where you can file suggestions. It's called Microsoft Connect. You can submit your suggestion here: http://connect.microsoft.com/SQLServer/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Code Access Security in SQL Server 2000 Reporting Services

I have a 3rd party DLL that I need to give Full Trust to. Here is the code in
the prvpolicy.config file I am using to do so. My question is, what am I
doing wrong?
Does it need a certain name or is the <IMembershipCondition
class="UrlMembershipCondition" the wrong thing or?
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="AzaleaBarcode"
Description="Code group for processing azalea font barcodes">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Azalea\Bar Code Engine\Barcode.dll"
/>
</CodeGroup>We're working on the same exact problem. Has anyone solved this problem?
"Pinolian" <Pinolian@.discussions.microsoft.com> wrote in message news:<B8247CA5-44C0-4E59-BE3D-EABDFC22EEE1@.microsoft.com>...
> I have a 3rd party DLL that I need to give Full Trust to. Here is the code in
> the prvpolicy.config file I am using to do so. My question is, what am I
> doing wrong?
> Does it need a certain name or is the <IMembershipCondition
> class="UrlMembershipCondition" the wrong thing or?
>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="AzaleaBarcode"
> Description="Code group for processing azalea font barcodes">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Azalea\Bar Code Engine\Barcode.dll"
> />
> </CodeGroup>