December 2008 Entries

How to Grant Execute to all SQL Server Stored Procedures/Functions

When you create a database i'm sure you can grant users/roles access to stored procedures tables etc.. But if you inherit the sql database then you will need to find a solutionThanks to Jeremy Kadlec from sql tips Unfortunately, with all of the security changes in SQL Server 2005, no default role is available to execute all stored procedures in a given database.Quite sure the same applies to SQL SERVER 2000. But there is a solution looking at the script below: Just pass in the loginname below to ......

Posted On Tuesday, December 16, 2008 5:43 PM | Comments (2)

Error:Unable to load client print control

When you click the print button from the ReportViewer control (Sql Server 2005)you get the error: Unable to load client print control I never had this issue with ReportViewer control (Sql Server 2000). After doing some research it came out that there were many solutions to this depending on your environment. 1) Installing the RSClientPrint.Cab which can be found in the program Files\MSSQL Server\Reporting Services\ReportSerer\bin\.. folder. But with this you would have to deploy this cab to all the ......

Posted On Wednesday, December 10, 2008 7:16 PM | Comments (8)

Feature 'ID' is not installed in this farm, and can not be added to this scope.

I wanted to install one of the 20 Admin Templates for WSS v3. I was only interested in the in the HelpDesk Template. So i went and downloaded the help desk templates and added the solution. When i tried deploying the solution i get the error: A feature with ID 75a0fea7-97c5-4487-88e4-70f... has already been installed in this farm Use the force attribute to explicitly re-install the feature. So i tried deploying it using the -force option and the error went a way.So i was happy But anytime i ......

Posted On Thursday, December 4, 2008 12:55 PM | Comments (5)

Copyright © Patrick.O. Ige

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski