SQL Server Management Tools - Service Pack?
I've got the following installed on my local machine (XP Pro, sp 4, SQL 2000 tools)
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
It keeps bomging and giving errors.
I can't find a specific service pack for the tools...maybe there isn't one? Do I need to install the regular sp2 server service pack?
I'm confused.
View Complete Forum Thread with Replies
Related Forum Messages:
Does Service Pack 2 Affect Client Tools?
Hello, Does Service Pack 2 affect client tools? In other words, if you have a client machine with just the tools installed (management studio, BIDS, etc) do I need to run the SP2 package on this client as well? Regards, Jeroen
View Replies !
SQL Server 2005 Service Pack 2 Has Not Upgraded Visual Studio 2005 Business Intelligence Tools
Hi, I understand from previous threads that installing SQL Server 2005 Service Pack 2 on the desktop client can speed up the response rate of the Visual Studio 2005 Business Intelligence Tools. However after logging on as an administrator and installing Service Pack 2, Service Pack 2 returned no errors. However after launching Visual Studio and clicking on the about dialog box the version reported was still €œRTM.050727-4200€? where I was expecting to see €œSP.050727-7600€?. I understood that I applied the same service pack to my copy of SQL Server on my laptop and the upgrade worked successfully. Can anyone help? Thanks in advance, Kieran.
View Replies !
Management Studio Service Pack
Is there a service pack for management studio? I don't mean studio express I mean the full version. If so where can I find it because I've looked and it only appears to be a service pack for Express which i don't want. Cheers
View Replies !
SQL Server Management Express Studio Management Tools
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
View Replies !
Management Tools In SQL SERVER 2005
Hi Team, Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer. Can anyone explain to me... Thanks.
View Replies !
SQL Server Management Tools Not Installed
>> I was able to solve this. Read the bottom of the post. I just installed SQL Server 2005 Standard Edition and none of the management tools seem to be there. At least they do not show up in Start>>All Programs>>Microsoft SQL Server 2005. All that shows up is the Configuration Tools menu item. I have been searching through the forum and I have found dozens of other threads about this, but none that seem to actually answer the question or give a solution. Some say to delete everything and start over, others say to review Visual Studio 2005 (which takes something like 4 hours to install, and then you still have to install all of the 3rd party tools, so I don't want to do that unless I just have to), and a few others say to uninstall SQL Server Express and then reinstall SQL Server. However, I believe that I selected to install them both at the same time. Anyway, I just looking for some ideas here to get all of this installed. There seems to be some problem here that a lot of people are having to deal with. Are the Managment Tools disabled by default? It seems that in 2005 a lot of the services are turned off by default so I'm wondering if I have to do something to turn on the Management Tools. Best regards, Greg Rothlander I just uninstalled and reinstalled per some threads on the forum and it all showed up. Apperently if anyone runs into this, just uninstall everything that has to do with Microsoft SQL Server and reinstall.
View Replies !
Installing SQL Server Management Tools
I have been trying for 2 days now to get the SQL Server management tools installed on client machines. I'm starting to think it is not possible to do that the way we used to be able to with previous versions of SQL Server. I have installed 3rd party open source software on my own machine so that I can query the database without logging onto the server directly and would like for my co-workers to be able to do the same. As I mentioned we tried the SQL Server Management studio and all we get is a message saying to uninstall all the beta and Visual Studio *** on our machines. We stripped one machine all the way down to the OS and still kept getting that message so I'm guessing it is some new Windows Vista issue that makes SQL Server 2005 client tools completely incompatible with XP. However, we are not going to bow to Microsoft's evil ways and upgrade to their new OS just to use the SQL Server Studio. If need be I will write my own software to workaround this problem. In the meantime, can anyone recommend some good 3rd party tools that will allow us to query the SQL Server 2005 database on a server and preferably one that does not require all other software be removed first?
View Replies !
SQL Server Management Tools Standard And Express
Can the SQL Server 2005 Management Studio interact with local SQL 2005 Express databases. So can we use one management tool for both our server (non-local) SQL 2005 Databases and our local SQL 2005 Express databases (That the developers have free reign over). Any tips and tricks for this kind of setup?
View Replies !
SQL Server 6.5 Service Pack 5
Happy Holidays Everyone, Does anyone know when SQL Server 6.5 Service Pack 5 came out and of any reviews on it?? Would like to make sure there are no major issues or bugs before installing company-wide. Thanks in Advance, Bill.
View Replies !
Service Pack For Sql Server 7
I'm working in a manufacturing company which run with a sql server 7 but we 'd like to know whether this is relialable because all our manufacture databse is on that Thanks per advance. Marc
View Replies !
Service Pack -3 On SQL Server
Hi all, Can anyone give me the insight as what r the things to be considered while installing SP3 on SQL server and what all the things to be checked after the installation of the service pack. Any suggestions on this is greatly appreciated. If any one can mail me the check list that would be of great help Thanks in advance Reddy
View Replies !
Sql Server 7 Service Pack 3
After installing service pack3,I am having trouble with this line of code Set objADSI=CreateObject( session("strDLL") & ".cADSI") objADSI.DSN=session("DPS_ConnectionString") LocalProviderMoniker = trim(cstr(Session("ProviderMoniker"))) LocalDomain = trim(cstr(Session("Domain"))) LocalUserID=trim(cstr(Session("DPS_Logon_User"))) strAdminGroupName=Trim(Cstr(Session("DPSAdminGroup Name"))) 'Get Group Info - All groups/sids, user groups/sids, and whether user is 'DPS system administrator 'using ADSI to retreive global address list from nt server arrGroupInfo = objADSI.ADSIGetGroups(cstr(LocalProviderMoniker),c str(LocalDomain),cstr(LocalUserID), strAdminGroupName) After this line of code, I am getting ASP Error Active Directory error '80004005' Unspecified error I am confident that it has something to do with data component. But I need to solve this problem. if you have any idea let me know.
View Replies !
SQL Server 7 Service Pack 4
Like Steve a few messages back, I'm also getting ready to add SP 4.0. Anyone found any problems? We are running a lot of replication, so I'd like to know if anyone has seen anything different. -Kurt
View Replies !
Using SQL Server Management Studio Tools To Manage Dbs On SQL Server Express Edition
Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted. I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition. Thank you in advance for your help.
View Replies !
Installing SQL Server 2005 Management Tools - Setup Crashing Repeatedly
I'm having many many issues installing sql server management tools. i had visual studio 2005 installed first, but uninstalled and sql related things before trying to install sql server management tools again - i also deleted the program files/microsoft sql server/ folder so there are no references. Firstly the system configuration check gives me a warning that the system doesn't meet the recommended hardware requirements - this is wrong... i've got 2.33Ghz dual core + 1gb of ram... I select just management tools + client connectivity to install and click next -> the setup support files/native client/owc11 etc all install fine but workstation components etc fail and the setup log appears to either be empty and not available and MSXML6 fails... after clicking finish the installer appears to crash - : "Microsoft SQL Server 2005 Setup has encountered a problem and needs to close. We are sorry for the inconvenience"... I have tried all sorts of variations on this install and have had no problems in the past - please help! The setup log from the MSXML6 failure - === Verbose logging started: 18/03/2008 12:34:09 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (5C:78) [12:34:09:067]: Resetting cached policy values MSI (c) (5C:78) [12:34:09:067]: Machine policy value 'Debug' is 0 MSI (c) (5C:78) [12:34:09:067]: ******* RunEngine: ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE} ******* Action: ******* CommandLine: ********** MSI (c) (5C:78) [12:34:09:067]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (5C:78) [12:34:09:067]: Grabbed execution mutex. MSI (c) (5C:78) [12:34:09:067]: Cloaking enabled. MSI (c) (5C:78) [12:34:09:067]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (5C:78) [12:34:09:067]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (28:E4) [12:34:09:113]: Grabbed execution mutex. MSI (s) (28:74) [12:34:09:113]: Resetting cached policy values MSI (s) (28:74) [12:34:09:113]: Machine policy value 'Debug' is 0 MSI (s) (28:74) [12:34:09:113]: ******* RunEngine: ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE} ******* Action: ******* CommandLine: ********** MSI (s) (28:74) [12:34:09:113]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (28:74) [12:34:09:113]: MainEngineThread is returning 1605 MSI (c) (5C:78) [12:34:09:113]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (5C:78) [12:34:09:113]: MainEngineThread is returning 1605 === Verbose logging stopped: 18/03/2008 12:34:09 === The log summary: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Mar 18 12:05:06 2008 EOC429 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online. Machine : EOC429 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : EOC429 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : EOC429 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log -------------------------------------------------------------------------------- Machine : EOC429 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt. Time : Tue Mar 18 12:19:20 2008 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core(Local).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_MSXML6_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0 LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SNAC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SCC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_WI.log
View Replies !
SQL Server 2000 Service Pack 3a
Hi all, I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS. Have some suggestions? Thanks
View Replies !
SQL Server 2000 Service Pack 3a
Hi all, I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS. Have some suggestions? Thanks
View Replies !
Sql Server 2000 Service Pack 3
Hi, I am trying to install the service pack 3 for sql server 2000 but cannot do it. I keep getting stuck at the screen where it asks u for the windows authentication or the sa password. I select the sa password option and enter the password but it gives me an error saying that it was unable to connect. Can someone tell me what to do. Kind Regards, Yoshi
View Replies !
Microsoft SQL Server 6.5 & Service Pack 5
I wanted to find out more about Service Pack 5. I have heard that the purpose of this service pack is to make SQL Server 6.5 Y2K compliant. Does anyone know anything about this Service Pack (its contents, release date etc). I have checked the Microsoft SQL Server home page, MSDN Library, TechNet, Knowledge Base and have not had much luck. Thanks!
View Replies !
Uninstall Service Pack 5a On SQL Server 6.5
Can someone help me out to uninstall service pack 5a on SQL server 6.5? We have few problems with this new service pack. Stored procedures could not delete temporary tables created in them. Can I load the backup databases from this service pack(5a) to service pack 4 servers? Thanks in advance, Mohan
View Replies !
Installing Service Pack 5a For SQL Server 6.5
Hi Everybody, We have SQL Server 6.5. We planned to go for Service Pack 5a. Right now SP3 is running on SQL. I went through the "Microsoft Site", we also noted down some information from the site. In our server we didn't set any password for 'sa'. In the Documentation they hv given some options for setup. I am not able to follow that. Can anybody explain to me what options I hv to give while I execute the setup.exe for "SP5a" and Can anybody please tell me what precautions we have to take before installing the SP5a?. Vasu
View Replies !
SQL Server 6.5 Service Pack 5a + HotFix
Hello all, Our clients have upgraded SQL Server 6.5 from Service Pack 3 to Service Pack 5a and have encountered a few problems. Our development platform has for the past year or so been on Service Pack 5a + Hotfix (we are not responsible for clients upgrading the SQL Server). The problem now is that we cannot find the HotFix to determine whether this would actually overcome their problems. I have search high and low and cannot find any trace of a HotFix for SQL 6.5 SP5a, not even on the Microsoft site. If anyone knows the whereabouts of this HotFix I would appreciate the knowledge asap. regards Brian Roberts UK
View Replies !
Can't Install SQL Server 7.0 Service Pack
Has anyone had a problem when installing service pack 2 or 3 on SQL Server 7.0? I'm stuck at MDAC upgrade every time, had to 'end task'. Did select @@version afterwards, still on the old version. I didn't try service pack 1 yet. I found the following page titled "Can't install SQL server service pack 1", but I'm unable to access. http://www.swynk.com/archive3/4500/45001235457.asp Any help will be appreciated. Please email me directly. Thanks in advance. Phyllis
View Replies !
ADSI, Sql Server Service Pack 3
After installing sql server service pack 3, The following line of code does not work properly.(It's ASP code) Dim objDomain As IADsDomain Set objDomain = GetObject("WinNT://domainname") I am getting Active Directory error '80004005' Unspecified error If you have any idea to solve this problem, let me know.
View Replies !
SQL Server 7.0 Service Pack (Urgent)
Hello, My production server has MS SQL Server 7.0 with service pack 2. I want to install the latest service pack but all my seniors who are working on Unix and sybase sql server doesn't want to install SP 4 they think with this service pack there has been no problems, we don't want to install new SP and create problems. CAn anyone guide me that what bugs are fixed and wht are good reasons for installing latest SP over the old one, and Is there any draw backs about new SP. Thanks In Advance Qinglee
View Replies !
SQL Server 2005 Service Pack 1
SQL Server 2005 Service Pack 1 has now been released. Download - http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en New features and improvements KB -http://support.microsoft.com/default.aspx/kb/916940 SSIS section below- SQL Server 2005 Integration Services (SSIS) €¢ Usability of the Import/Export Wizard has been improved in multiple-table scenarios. €¢ The IDtsPipelineEnvironmentService service lets custom data flow components have programmatic access to the parent Data Flow task. €¢ Interoperability with Analysis Services has been improved. The DataReader source in SSIS supports the System.Object data type by converting columns that have this data type to the DT_NTEXT ssISnoversion data type. To change the data type to a type that is more appropriate for your data, you can add a Data Conversion transformation. €¢ Performance has been improved for many transformations, such as the Sort transformation. €¢ Designer usability has been improved. For example, you can now right-click Dataflow and then click Execute Task to execute only the Dataflow task. You do not have to switch to the control flow to execute only the Dataflow task. €¢ The Expression Builder dialog box now has a public and documented API. This increased access to expression-related objects will benefit task developers because expressions are important to the way that tasks are interrelated. €¢ We have added a registry-based policy for handling SSIS package signatures as a package is executed. For example, administrators can disable loading of unsigned packages and untrusted packages. Because these settings are in the registry, administrators can propagate these settings in the domain by using Microsoft Windows Group Policy policy settings. €¢ In the Advanced Editor dialog box, the Flat File source has the new property UseBinaryFormat. This property supports loading packed decimal data into the pipeline for processing by a script or by a custom transformation. €¢ In the Advanced Editor dialog box, the DataReader source has the new property CommandTimeout. You can use this property to modify the time-out period to allow for long-running operations. €¢ To create or to modify the property expressions of variables, you can now open the Expression Builder dialog box from the Properties window. €¢ You can now add annotations to precedence constraints.
View Replies !
SSIS And SQL Server Service Pack 2 X64
I have recently installed SQL Server SP2 on a Windows 2003 x64 server SP 1 and now I cannot open existing packages on that machine. The packages work fine on other machines. Also, when I create a new package and then attempt to add a data flow component, I get an error that the designer could not be initialized. It does add the component, but when I try to delete it, I get an error that the collection cannot be null (parameter: c). I have read some posts that point to registry permssions, and have ran the sample c# code, but I do not see any problems. Anyone have a suggestion?
View Replies !
SQL Server 2005 Service Pack 2:
SQL Server 2005 SP2 and a new version of the 2005 Books Online Released and now available at SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx WHat is new in SP2 http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm#BKMK_DatabaseEngine list of Bugs fixed http://support.microsoft.com/?kbid=921896 Madhu
View Replies !
SQL Server 2005 Service Pack 3 ?
I participate in the SQL Server Integration Services and Reporting Services forums and I have seen many outstanding issues users would like to see fixed. Is there a SQL Server 2005 Service Pack 3 being developed and if so when would it become available?
View Replies !
SQL Server 2005 Service Pack 2 -- Now Available
SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Thanks, Sam Lester (MSFT)
View Replies !
SQL Server 2005 Service Pack 1
Is there no "passive" install mode for SP1 (gui but no user input required)? I can run unattended using the /quiet switch but this gives me absolutely no feedback as to progress or success/failure of the install. It also returns to the command prompt immediately whilst kicking of msiexec in the background, meaning I can't trap any errorlevel. How are we supposed to check success or failure in applying the SP for unattended installs? For rolling this out across an enterprise we need something, usually hotfix.exe has a passive install mode. thx, Simon.
View Replies !
Service Pack Of The Reporting Server
How to know which service pack is running in the reporting services? I am aware of " SELECT SERVERPROPERTY('ProductLevel')" command. But I guess it shows only sql server sp not reporting service sp. Am I right?
View Replies !
Service Pack For SQL SERVER 2005 Exp Ed
Hi, I would like to know which downlaod should I do from the Download page of SQL SERVER 2005 SP I can see there are 3 downloads but have no clue which one I should be downloading. ALl of them are about 300 Mb in size. Thanks Paps
View Replies !
SQL Server 2005 Service Pack 2 Without 1
Hi, I'm just installed the sqlserver 2005 sp2 without installing service pack 1. Can i install service pack 1 after installing sp2? or is it sp2 includes all the sp1 updates? Thank you and Have a nice day. Regards, Ben
View Replies !
SQL Server 2005 Service Pack 2 -- Now Available
SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Everything including Readme, updates books online etc can be found here: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx Thanks, Sam Lester (MSFT)
View Replies !
Sqlserver Service Pack For Service Pack 2
yestarday there is an article released about the service pack for the service pack 2 for sqlserver wo downloaded before mar 5 , 2007. but to my development server i didn't download sp2 yet. Ifs it safe to download the sp2 for sqlserver 2005 enterprise edition now?? thanks,
View Replies !
SQL Server 8 And SQL Server 2005 Management Tools In Consistencies
I have been investigating this issue and here is what I have found, when using SQL Server 8 Query Analyzer the results show that for example xp_regread has Execute permissions granted to €˜public€™ role. When checking the Same using the SQL Server 2005 Management Studio the results show that there are no Execute permissions granted to €˜Public€™ Role. So the following Query doesn't return any results on Management Studio SQL Server 2005: SELECT sysusers.name , Status = CASE protecttype WHEN 204 THEN 'GRANT_W_GRANT' WHEN 205 THEN 'GRANT' WHEN 206 THEN 'REVOKE' ELSE 'Unknown' END , Permission = CASE action WHEN 193 THEN 'SELECT' WHEN 195 THEN 'INSERT' WHEN 196 THEN 'DELETE' WHEN 197 THEN 'UPDATE' WHEN 26 THEN 'REFERENCE' WHEN 224 THEN 'EXECUTE' ELSE 'Unknown' END , sysobjects.name FROM sysprotects, sysobjects, sysusers WHERE sysobjects.id = sysprotects.id AND sysprotects.action IN (193, 195, 196, 197, 224, 26) AND sysprotects.uid = sysusers.uid AND sysusers.name = 'public' AND (sysobjects.name like '%xp_%' OR sysobjects.name like '%sp_OA%') Where as running the Same Query in SQL Server 8.0 Query Analyzer will return results, saying there are a few extended procs available to Public for Execute. Do you know whats going on here? Thanks!
View Replies !
|
TRACKER
