SQL 2005 Service Pack 2

Hot Topic

Users and his roles
Interesting custom functionality in Reports ... highlighting?
Unable to start T-SQL Debugging. Could not attach to SQL Server process on
Question transport-level error
Access Permissions on server scoped objects for login
SQL on Appliance Edition
visual basic 2005 problem
working with decimals or real numbers
BIDev Studio Merging 2 SSIS packages in to one
Access a database from a client application

SQL Server

How many user current "connect" to a row in table.
Accessing an SSRS report from the web, being prompted for Guest signon screen
Transaction is working but with one problem
Problem with XML Source
Subscriber to a SQL Server 2000 Replication
Checkbox
SQL SERVER EXPRESS can't see my Cerificate
UDM and Data Mart
Capture date and timestamp of a file?
Credentials in Reporting Services??

SQL 2005 Service Pack 2

Can anyone tellme when SQL 2005 Service Pack 2 will be out It is a big problem when I can't look at an existing role and see what permissions are for a group of objects.

I found this in forums:
http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=605425&SiteID=17

quote user="Bill Ramos"]

Actually - we have a "fix" in for our service pack 2 that will be available in CTP form later this summer that will list all of the securables for a given principle that have been explicitly set. You may need to use the "Effective Permissions" button to see if the principle actually has permissions on the securable.

Thank you,

Bill Ramos, Lead PM, SSMS




Answer this question

SQL 2005 Service Pack 2

  • singam

    Just providing the link to SP2 CTP

    http://www.microsoft.com/sql/ctp.mspx



  • Mandragon

    I've been checking the site above frequently. Does anyone have any new information on SP2 I'm particularly interested in the ability to put a Report Model on an Oracle data source.

  • spunky1a

    BTw, the CTP for SP 2 is available - a colleague of mine has downloaded it, and installed it. It still didn't fix his issue with Vista and not being able to use .Net scripts in SSIS packages

  • MusicMan2006

    and another reference here, for issues INSTALLING SP2 (ergo it must exist :-0)

    http://www.kbalertz.com/Feedback_926625.aspx

    And yet, I cannot find it on the MS sites anywhere!

  • Aaron Leiby

    That's pretty cool, don't you think, to have a KB on the product that's not even out yet! :-)




  • DaPosh

    I would have thought it would be soon as there is already a kb article about problems installing it kb926624

  • GoingNCircles

    There is no date for it yet. Check often link below for any available update. http://www.microsoft.com/sql/downloads/2005/default.mspx



  • SQL 2005 Service Pack 2
Answer this question