Rocking Karthik's Q&A profile

• SQL Server SA account (DBA System account) Granting Priveleges but SQL Server 2000 not applying them

  I have been running a script in SQL Server 2000 as sa also as a Active Directory user who has administrator rights (I tested both approaches SQL Server then Windows Authentication) in Query Analyser which grants execute rights to the stored procedures within the database instance and Query Analyser does not give any errors when I run the script. I have made sure that each transaction has a go after it. I then return to Enterprise Manager, check the rights (I apply them to roles so that when we create another SQL Server user we just grant him/her rights to the role) and discover that the role has not been granted the rights. I seems to be occurring only with 2 of the procedures. Is there a known bug that might be causing this yours since ...Show All

• Visual Studio Team System Internal Error! Failed to acquire a ReaderLock

  I get this error message at the end of a webtest. Any ideas as to why If I find a way to reproduce it consistently, then I will post here again. It might help me to reproduce the problem if I had an understanding of what a ReaderLock was and what it did. Thank you very much ...Show All

• SharePoint Products and Technologies Accessing a SQL Server table using sql authentication as opposed to windows authentication

  I have created a pivot table based on a sql server 2005 relational DB connection, with the userid and password stored in the ODC (sql server authentication). The ODC is in the data connection library (DCL) and is approved. I created an Excel sheet with a pivot table based on the ODC. I can refresh this pivot table in Excel 2005, and I have deployed the sheet to the documents library. When accessing the sheet via Excel Services Web access, it displays properly, but refuses to refresh, errorring with : "Unable to retrieve external data for the following connections: xxxxx The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location and ...Show All

• SQL Server SQL server 2005 workgroup edition in SBS 2003 R2 Max memory question

  We have only a small busines and haven't got too much experience with servers and now have a proliant server coming in with SBS 2003 R2 Premium with the 4 GB max memory that SBS 2003 can handle according to the specs. We weren't planning on using the SQL 2005 worlgroup edition up till now, but now we might. According to the specs of SQL server 2005 workgroup edition however, it has a max RAM of 3GB! Is this going to be a problem and should we keep using our previous DB, or can we migrate toward SQL server with the 4 GB of RAM ...Show All

• SQL Server SSIS Integration

  After developing a ssis package and deploying it using sql agent job,now what i wish is send me an email automatically after performing ssis job,and the content of eamil should include details about ssis,what can i do Thanks in Advance ...Show All

• Visual C++ Arrow Position on a ComboBox

  Hi, If the arrow located on the right side of a combobox is desired to move to the left, the only setting I found was to set the RightToLeft property to true. The problem is that this is meant for localization and the languages which start from the right side, not proper for English. What is the best way to move the arrow to the left of the ComboBox . A work around perhaps, to set the properly to true for the combobox, and then to set it false by getting a handle to the listbox part of the control during the runtime Any idea Best Regards, Reza Bemanian This should be done by the use of the HwndHandle for the list box embedded within the control. Though the RightToLeft is a public property, still ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to gray out screen for pause menu

  Hello, I am trying to create a grayed out copy of the screen of my game so that I can render a "pause options" menu on top of it. I think the solution might have something to do with using GraphicsDevice.CreateRenderTarget to render the game to a new texture, and then drawing that texture grayed out. How do I accomplish the actual graying out How (if it is even possible) do I render my game so that the result ends up in a new texture instead of on the screen Thanks! Sorry I couldn't help more, that's why I'm hoping someone can translate what I have said into some HLSL or an Effect class that you can use directly. Using shaders opens up an world of possibilities, even for 2D work. Once you get used to working with them, the ...Show All

• Windows Forms Custom strings erased from resourcefile

  Hi I'm working on a project in norwegian and it will also support english  (UK). I have some strings in resourcefiles that will be used in messageboxes, both in english and norwegian.  All my button text and stuff like that seems to work fine, but all my custom strings, that are not connected to any controls seems to be erased from the resource files. F.eks  if I make a string  called  strHello  with the value  "Hello World"  it will at some time get erased from the resource. Can anybody tell me what's wrong or if I'm doing something wrong   I'm doing this in  VB.Net 2005   regards Stein ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. LoadContent/UnloadContent Interface

  I'm working on making a solid start to my scene manager game component, and for the nodes I want different levels of components such as an UpdateableSceneNode and DrawableSceneNode. My problem is that I can't seem to find the interface which defines LoadContent and UnloadContent. Is there such an interface And if not what is the process of properly creating these in my nodes I know that, but I don't want to extend their class. Personal opinion sort of thing, but I would rather just implement an interface for the two methods than extend the whole class. But thanks for the recommendation. ...Show All

• Visual Studio Team System "The operation could not be completed" trying to add project to TFS using MSSCCI provider

  I was fooling with adding projects to TFS through the MSSCCI provider in Visual Studio .NET 2003. I added some projects successfully, canceled some check-ins, and just generally used VS as I normally would. At some point I became unable to add a project to source control. When I would try VS.NET would present me with the "choose server" dialog as normal. I clicked OK and after a short pause I would get "The operation could not be completed." No additional error message in the event log or anything. I deleted the team project and recreated it with the same name. I received the same error. I manually removed all source control data from the CSPROJ and SLN files as well as deleted the SUO and .vssprj file. I even tried ...Show All

• SQL Server Query Notification stops working after 10 minutes

  Hi All We built a Cache component that take advantage of the SQL Server 2005 query notification mechanism, all went well , we tested the component in a console application , and notifications kept coming for as long time as the console application ran. When we initiate our Cache Component in our web service global.asx application start event , the query notification works for a few minutes , but if we came after 10 minutes or so , we stoped getting notifications from sql, the SQL Server queue is empty , and all is showing that there is nothing wrong on the DB side... Our Cache component is a Singleton class , that perform all registrations ,catch the notification events and resubscribe for notifications. What can ...Show All

• SQL Server multi-select dropdownlist with checkboxes

  When creating a windows forms report (rdl), multi-value parameters are rendered with a nice drop down list with check boxes...including a (Select All) item. When you run this via a report server and render the report for the web, the multi-value selection shows up nicely. Can I create a similar web form dropdownlist so I can duplicate the functionality with an RDLC report Jim Jim, Please check this online posting. http://www.dotnet247.com/247reference/msgs/42/211693.aspx It describes creating a dropdownlist with checkboxes. There is nothing out of the box available. You will have to write your own control. HTH, Rakesh ...Show All

• Visual Studio Team System HELP: Accidently deleted an important project and i need it back!

  Hi all, Here is the deal. I was attempting to move a project in TeamSystem to another project. I had everything checked in and I had a copy on my hard drive. I deleted the project with TFSDeleteProject.exe and then went to create a new one but when I set up my new Workspace and started to add my source I found my source was no longer on my drive. Ok. So I started to freak because this was approx 3 months work for me. We have nightly backups but I had left the backup to my systems team and they only backed up the databases. So I created a new install of TeamSystem on another machine and restored the databases. So far so good , I can connect to the new server and see the 6 or 7 projects I have in there including the project I delete ...Show All

• Visual C++ C++/CLI .NET threading model differences?

  Hi, We have a native application in C++ using several threads and criticalsections between them. We've been developing this app using VC++ .NET 2003 and has been working quite good so far. Now we must use C++/CLI as a wrapper for presenting GUI to our native app. So far things went ok with the side by side managed and unmanaged code. However our threads starts to deadlock when they reach criticalsections. At first thought we figured it was perhaps a deadlock due to same thread aquiring same mutex twice. However the way that criticalsections often work is that they allow double locking by same thread. We've been going through our code but so far there's been no indications of errors. This leads me to think that the .NET threading m ...Show All

• Visual C# Problem writing to a custom event log

  Hi, I have developed a windows service (which works), however the problem I'm having is writing to a custom event log. I have managed to create an event source for my service and register it to my custom log (double checked this in the registry) but I keep getting the following message appearing in the Application log (nothing gets written to the custom log): The description for Event ID ( 0 ) in Source ( EmailForwarder ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ...Show All