Bolugbe's Q&A profile

• SQL Server Permissions to view Stored Procedure Property

  My Production servers are SQL Server 2005 x64. I would like to allow my developers the ability to look at permissions on production stored procedures but not be able to change those permissions or alter the production code. What has to be set to allow this sort of security. I have done that for the developer group and I still get this error on Stored Procedures TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property DefaultSchema is not available for Database '[HouseAccounting]'. This property may not exis ...Show All

• Windows Forms how can i make ProgressBar synchronous with process of my app???

  Hi all i have an app and i want to display a progress bar which synchronous with process of my app when my app are retrieving data from database. How can i do that Please help, thanks The progress bar has to have something to measure itself by. It starts a number and the code can step it intermittently as the processing is occurring until completed. Since you don't control data access; measuring that progress doesn't fare well with what the user will experience....I recommend that you set the bar to Marquee mode and stop it once done. ...Show All

• Visual C# Public partial classes

  Hello Everyone, How to access these public partial classes: I have something like this public partial class test : System.Web.UI.Page { // What ever I need here } I have a second class public partial class test1 : System.Web.UI.Page { //Code here How can I access test from here } If test has some public/internal members that are static thus type members that you just need to access them by specifying the full namespace (unless they are in the same namespace) followed by test. If you want to access instance members (not static members) than you need to create an instance first of test in test1 to be able to access them. In test1: test _test = new test(); The ...Show All

• Visual Studio goto/find commands on the context menu

  Hi all. Im working on implementing a langaugeservice for a custom programming language and I have a question about some of the standard commands on the editor contextmenu. The commands in question are: "goto definition", "goto declaration" and "goto reference". I want to get rid of the "goto declaration" and "goto reference" commands. I have implemented IOleCommandTarget.QueryStatus and I use it sucessfully to remove other unwanted commands from VS, but this method is never called for these commands ( VSConstants . VSStd97CmdID .GotoDecl and VSConstants . VSStd97CmdID .GotoRef). So what I want to now is, is there som other way to hide these commands I would also like to have the & ...Show All

• Visual Studio Team System Data Tier Problem

  Hey, I wanted to create a test environment. So, I installed everything as I was supposed to, and then I backed up the production DB and restored it to the testing environment. Then, I used TFSAdminUtil and specified the new data tier. Seemingly, all went well - no error messages, I even checked up on one table (subscription) in TFSIntegration and it pointed to the new data tier - great. However, today, I was startled to find that changes I made to work items on my testing environment changed things on the production environment! Then I took a quick look in the TFSWarehouse to find out what was the last work item id and found that I was right - the test server was actually pointing to the production server (I learned this ...Show All

• Visual Studio after one day of Visual Studio 2005 trial installation its expire

  Hi, i just installed VS 2005 on January 17, and today i tried to run it, the message pop out that trial version is expired. any comment and help would be appreciated thanks in advance ...Show All

• SQL Server passing varibales as SP input inside a cursor

  Hi dear, I want to assign the variable @myVar an input to my stored procedure parameter @myParam. But I want to do that my cursor code: declare @myVar as.. fetch next from crsMyTblParams into @DBparam while @@fetch_status=0 begin EXEC sys.sp_helprotect @username=@myVar fetch next from crsMyTblParams into @DBparam end close crsMyTblParams deallocate crsMyTblParams But that gives me an error 2/ another question pls: how can I use use @myDB for a varibale like this: declare @myDB ...cursor code use @myDB ...rest of cursor code ...end of cursor code Is that possible , thank you Thanks a lot. I ha ve a problem when the var @myVar has a \ in it like : @myVar = 'domain\myUser' ...Show All

• SQL Server Help please some data not replicating

  Hello, We have four mobile devices that are set up for merge replication via the web. We are not receiving errors but some of the data is not coming over to the devices. If we manually add a record that record will come over, but there is data that is on the server that isn't on the devices. If we run the snapshot for each device (We're using host_name as a filter) nothing happens. If we do validation check we get errors. If we reinitialize all devices it works but the next days data (sql job populates data to the publisher db at night) isn't on the device after syncing the next morning. Any help would be appreciated. John Mahesh, No the only filter we have is the HOST_NAME() for specific ...Show All

• Visual Studio 2008 (Pre-release) DLinq bug on DataBinding

  Hello, I think there may be a DLinq bug for databinding.  In my database, the Employee table has a column "AddressID" that is a foreign key reference to "AddressID" column in the Address table which serves as it's primary key.  I generated my DataContext class using SqlMetal. When I first designed the UI in order to update this information, I put all of the Employee and Address UI controls on the same form, and used databinding to bind the properties of the entity classes to appropriate controls.  When I saved my Employee changes for an existing employee, everything saved appropriately to the correct rows in the database.  Meaning if the Employee referenced AddressID = 47, then the changes woul ...Show All

• Windows Forms inherited form constructor not found warning message

  I've seen one other post about this and it was never replied to, so I'm assuming this problem could be universal. When using a form that's a base class to be inherited by other forms that has a constructor with parameters, I consistently get a warning about the constructor not being found, and I can't use the designer on any of the inherited forms. Granted everything compiles and works just fine, but I always get a warning message, and I can't use the designer for any of the inherited forms. The designer for the base class works fine however. If I add a parameterless constructor on the base class that calls InitalizeComponent(), everything works correctly. But this is an entirely useless constructor that's used only to get the des ...Show All

• .NET Development asynchronous operations issues....

  Hi guys, I have a problem with FileStream object!!! By using something like; processHandle = OpenProcess( ProcessAccessRights .PROCESS_DUP_HANDLE, false , processId); if ( DuplicateHandle(processHandle.DangerousGetHandle(), handle, currentProcess, out objectHandle, 0, false , DuplicateHandleOptions .DUPLICATE_SAME_ACCESS)) { handle = objectHandle.DangerousGetHandle(); } FileStream s = new FileStream (objectHandle.DangerousGetHandle(), FileAccess .Read, true ,128, true ); First time I run it it works without problems but second, third,.... time when I fire it it gives the following error; Handle does not support asynchronous operations. The parameters to the FileStream constructor may need to be changed to ...Show All

• Visual Studio 2008 (Pre-release) WCF hosting: NT Service X IIS?

  Hi Everybody! We are starting a new project for a high available web system and we are thinking about using WCF to provide the required services. Probably we will use server clusters in order to provide the required availability, but we don't know yet if the solution shall use 3 levels of clustering (web, application/business and database) or 2 (web/application and database) as it depends on the customer budget. I'd like to know which solution would be more suitable: hosting the WCF services as NT Services or within IIS. Could you help me regarding the pros/cons of using each one considering: 1 - How easy each one adapts to the clustering hardware solution 2- Performance 3 - Security ...Show All

• Visual Studio 2008 (Pre-release) FindResource Problem

  Hi i have problem on finding a resource i have a Avalon Application Project and i have implemented on it a custom control my problem is, i have declared a brush as resource on generic.xaml but the FindResource can't find it! the generic.xaml is loaded by default or i need to specify Sorry for my english I use the June CTP Hi, the code is here http://www.dotnetfireball.net/ExplorerTreeView.zip this is my test project, the error appen's on line 146 on file FileSystemTreeView.cs b = ( Brush )FindResource( "defaultFileIcon" ); ...Show All

• Visual C# Make end of statement ";" optional?

  I think microsoft should make the end of line statement, (i.e. the ";") optional. If you program VB.net like I do and is inevitably forced to write/read C# code, having to write the ; after each statement is annoying. I know C/C++/java etc all have it but in an enviroment like Visual studio where the IDE makes life so much easier the end of line statement is unnecessary. Who agrees with me The IDE has nothing to do with it. The end-of-statement character is needed to parse the language. The under-score continuation character in VB is just the type of hack needed when you don't use a terminating character. It's just one of the many patched to VB needed to mantain the syntax created 40+ years ago, when a line of BASIC code h ...Show All

• Smart Device Development Alternative of System.sr.dll

  I have a application for which if I to add extra cab file for system.sr.dll for exception error message strings . Is there any other work around so that I can show exception error message strings without system.sr.dll {I don't want an extra cab file foir this system.sr.dll} Thanks mgaur.{You are always Helpful} OK That mean there is no way that I can avoid system.sr.dll. Is there any way I can bundle this System.Sr.dll with my application cab so that I can avoid extra cab for this System.Sr.dll ...Show All