Windows LiveWindows Live™
 
 
Perfil de GregGreg Olsen - Yellow Duck...FotosBlogListas Ferramentas Ajuda

Blog
    24 de junho

    Create a ASP.NET Membership Security Database

    Here I will explain how to add ASP.NET 2.0 Membership Security tables, stored procedures, views to your existing SQL Server database - its simple! Here's how:
     
    Prerequisites:
    Visual Studio 2005 installed
    SQL Server 2005 installed (with a current database and your windows account with dbo/admin rights)
    1. Locate your SQL Database - make sure you have rights to it
    2. Locate the Visual Studio Command Prompt (All Programs > Microsoft Visual Studio 2005 > Visual Studio Tools > Visual Studio 2005 Command Prompt)
    3. Run the following command: aspnet_regsql -S (local) -E -d MyDatabaseName -A all

    Note:  Change (local) to your SQL database server name if it is not local. Change MyDatabaseName to your database name (suggest you create a test database first to test this on - don't do directly on production database!)

    DONE!  Now have a look at your database. You should see a whole lot of new tables and stored procedures etc within your database.

    For more help on the switches on the command above, type: aspnet_regsql /? within the Visual Studio 2005 Command Prompt.

    Any questions about the above process then feel free to post a comment and I will reply.

    Yellow Duck Guy
    Greg Olsen

    14:10 | Adicionar um comentário | Ler comentários (1) | Link permanente | Incluir no blog | ASP.NET
    18 de junho

    SQL Script to GRANT EXECUTE Permissions to all Stored Procedures

    Well I had a task on one of my projects to GRANT EXECUTE rights to all stored procedures to a certain database role I had set up and I wanted this to be scripted. So I thought we must be able to build up some nice SQL script using the select command ..... and you can!
     
    Below is an example script you can past into SQL Management Studio (SQL Server 2005) or Query Analyser (SQL Server 2000) which will build the T-SQL required for scripting.  You will need to change the text YellowDuckGuyRole to your role you have created (create a role if you don't have one).  Type 'P' stands for Stored Procedures from sys.objects.
     
    select   'GRANT EXECUTE ON dbo.' + name + ' TO YellowDuckGuyRole'
    from     sys.objects
    where  type  =  'P'
    order by  name
     
    Once you have the output in SQL Server then you can save the results as you like i.e. to text file or simply copy the results and paste into notepad - easy!
     
    Yellow Duck Guy
    Greg Olsen
    20:53 | Adicionar um comentário | Link permanente | Incluir no blog | SQL Server

    Microsoft Acquires Dundas for SQL Server 2008

    Well I just found this article on the web and thought - great! Dundas has been an awesome data reporting tool for years and now Microsoft has acquired Dundas's data visualization technology and now "will be part of the final feature set for Microsoft SQL Server 2008 Reporting Services."
     
    More about the acquisition can be found here:
     
    Yellow Duck Guy
    Greg Olsen 
    20:45 | Adicionar um comentário | Link permanente | Incluir no blog | SQL Server
    12 de junho

    Box.Net is now Office 2007 enabled via Ribbon Add-Ins

    Well I have had a Box.Net (http://www.box.net) account for quite awhile now. I have 1GB of FREE space for file uploads.  I have used this account to transfer files across the Internet when needed and to share photos publically to friends. It works really well, oh did I mention it's FREE?
     
    Now Box.Net has done some more development and integrated with Office 2007.
     
    They have released a plug-in for Microsoft Word, Excel, PowerPoint, and Publisher that conveniently uploads any document you're editing to Box. After the plug-in is installed, a "Save to Box.net" link will appear in the "Add-Ins" section of each Microsoft Office application (see image below I have taken from my installation). Clicking on this button will save your file to Box, making it easy to access from anywhere, share with anyone, or keep safe for later. Apparently the plug-in is compatible with Windows versions of Microsoft Office 2003 but I haven't tried it with Office 2003.
     
    You can Download the Box Microsoft Office plug-in here:
    http://www.box.net/r/office4
     
    Box.NET
     
    Pretty cool!
     
    Yellow Duck Guy
    Greg Olsen
    22:26 | Adicionar um comentário | Link permanente | Incluir no blog | Microsoft Office 2007
    11 de junho

    SQL Server 2008 - 'Katmai' June CTP is now available

    Had news today that SQL Server 2008 code name 'Katmai' June CTP is available for download.
     
    @@version from 9.0 to 10.0 !! - now thats geeky .. right?
     
    If you want to get a hold of this for an early look, then head over to:
    This link will provide you with guidance information.
     
    BUT YOU WANT THE DOWNLOAD RIGHT?
     
    1. Then do head to here for sign up with the CTP Program (do this first)
    2. Download your required version:

    One new feature: There are new data types, DATE  & TIME

    Tell us any cool things you find!!

    Yellow Duck Guy
    Greg Olsen

    21:16 | Adicionar um comentário | Link permanente | Incluir no blog | SQL Server
    10 de junho

    Google search finds Greg Olsen (Yellow Duck Guy)

    Well I did a Google search today to see if I could find this blog - and I did!
     
    Enter the following in Google search: "Yellow Duck Guy"    - include the quotes!!
     
    This is the result of the Google search .....
     

    Google - Greg Olsen

     
     
    Yellow Duck Guy
    Greg Olsen
    10:34 | Adicionar um comentário | Link permanente | Incluir no blog | Other
    08 de junho

    Internet Explorer 8 - Alpha already inhouse at MS?

    There seems to be a lot of talk on the web that Microsoft already has rolled out Internet Explorer 8 - Alpha release inhouse. Anyone got anymore info on this?
     
    Yellow Duck Guy
    Greg Olsen
    21:28 | Adicionar um comentário | Ler comentários (1) | Link permanente | Incluir no blog | Internet Explorer
    07 de junho

    IIS - Configuration Error ...

    I got this error again today and thought "how do I fix this again?" after checking out IIS remembered that I need to enable the folder/location as an IIS application - error messages mentions this!
    OK, so this is the error message:

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

    Source Error:

    Line 49:   ...
    Line 50:   -->
    Line 51:   <authentication mode="Windows" />
    Line 52:   <!--   AUTHORIZATION

    Cause:
    The Web.Config is telling IIS to treat this as an application but it has not been set up as an application in IIS - hence the error message.

    Solution:

    1. Run/Open IIS (under Control Panel > Administrative Tools  for most Operating Systems)
    2. Find the project in the list of projects. (Open up your computer in the list and look under "Default Web Site").
    3. Bring up its properties (Right click > Properties).
    4. If the "application name" (under "Application Settings" on the "Directory" tab) is greyed out then click '[Create]' and then '[OK]'.

    Now if you refresh or reload your browser to the address of your website or webservice you should see it!

    Greg Olsen
    Yellow Duck Guy

    19:51 | Adicionar um comentário | Link permanente | Incluir no blog | Internet Information Services (IIS)