Rogerrr's Q&A profile

• SQL Server How to lock out everyone but me?

  I'm working with SQL Server Express, and I want to configure a named instance so that only the 'sa' user and a specified SQL Server user with a specified password have access. In particular, I'm trying to lock out BUILTIN\Administrators. Furthermore, I need to be able to do this from a command-line, since I want to configure it in a script. Nothing I do seems to work. I've attempted to use sqlcmd and the T-SQL call ALTER LOGIN [BUILTIN\Administrators] DISABLE, but that returns the error "Cannot alter the login 'BUILTIN\Administrators' because it does not exist or you do not have permission." What I can (apparently) successfully do is run DENY CONTROL TO [BUILTIN\Administrators]. This runs without reporting an error. However, afte ...Show All

• Windows Forms detemine whether the user have reacted or not

  Hi all, from a method i would like to invoke a form and it must be filled by the user, how can i detemine whether the user have reacted (fill the form) or not after a pause time (for example 1 min.) Any help ist appreciated Thanks Be specific as Gabriel as asked for. Do you want to detect if user has interacted with that application form or you want to detect if the form has been filled in required time or not. Create a timer and start it with 1 min interval, create a bool flag in you form to detect when application was being started to be filled and then set this flag to true. After timer Tick Event is raised see if that flag is true it means user done something with Form otherwise not. To dete ...Show All

• .NET Development Convert.Toxx vs DataType.Parse

  Whats is the best practice between using Convert .ToInt16 ("stringVar") short.Parse("stringVar") what is more aproppiate for performance and memory space use thnks   Convert.ToInt16("string")   calls Short.Parse("string") ...Show All

• Visual Studio Team System Team Foundation Server Licensing

  Hi, I am very confused with all the licensing for team foundation server, could someone please explain to me what licensing i need to be able to implement TFS. Our company already run on Windows Server 2003 There are 5 developers in the team, what licenses do i need to get the team up and running on TFS. For Example: If i get the Team Foundation Server, do i then need additional licenses for each user. I would appreciate it if someone could give me a guide price for Team Foundation Server with 5 users or point me in the right direction to find the information i am looking for. Many thanks Neil Senior System Developer Travel Trust Association You have two choices. TFS Workg ...Show All

• Software Development for Windows Vista missing wlanapi.dll

  hi all, recently i installed windows sdk.while running a sample application on wlan,an error message was displayed saying that wlanapi.dll was not found.can anyone please tell me where can i find it i have searched the installation folder of the sdk but i could not find it there. any kind of help will be welcome. thanks in advance Jyoti A quick google looks like it will get installed with wireless drivers (dlink etc) so a system that is not connected by a wire will be missing this DLL (eg my xp is wired to the wall so no DLL). Looks like Vista contains the DLL regardless as my vista test machine has a wire for lan conectivitiy. ...Show All

• SQL Server Lock page in memory setting in SQl 64 system

  Hi All, We know that locking page in memory setting is recommended to set in SQL 64 system. The purpose is used to avoid memory pages in Sql address will not be OS paged out. It is a little confused that if the memory pages of sql cannot be paged out after setting lock page in memory. Then the memory used by SqL will increase forever. If the physical memory is limited, it will obviously caused the memory pressure of the system eventually. How does the 64 bit sql manage his Buff pool in such scenario Will it be paged out Thanks in advance SQL Server listens to memory notifications from windows. These notifications indicate the state of physical memory on the system, low (meaning that the system does not have enough memory to ...Show All

• SQL Server Newb question

  If I am using Ado.Net from a .Net Class library hosted outside SqlServer to do Sends and Receives do I have to use anything else other than queues The reason I am asking is because I already have an abstraction layer for a couple of our queueing systems and I was hoping to put SSB in there as well but the abstraction layers' primitive is the Queue not Conversation/Dialog/Service, etc. Thanks Costas Rushi, thanks, I think that's where my ability to comprehend the service broker external call breaks down. All samples, articles, etc discuss it from the point of view of internal services talking to each other through dialogs which is not what I want to do or is it Are you implying that my "from" serv ...Show All

• Windows Forms How do I set a margin for controls?

  I would like to create a control which would behave like a Form or a Dialog box. For example, forms have a blue bar on top with the minimize, maximize buttons, etc... and you cannot add controls to this area, in other words, there is a margin. So basically I'm asking how can you specify regions on a UserControl, where no child controls can be added would it work if you put a panel on the usercontrol to Dock = Fill .. and the padding of your usercontrol to something... then whenever the user drag a control on the usercontrol .. it add it to the panel dont know if it works .. just suggesting something ...Show All

• Visual Studio Team System Why there're always errors on "Reports" and "Documents"

  Team Explorer shows four directories in a single project: "Work Items", "Documents", "Reports" and "Team Builds". But there're always red cross on "Documents" and "Reports", even I've set the user as an Administrator. Many thanks! Another route is to use the "TFS Admin Tool" to sync the permissions between TFS, Sharepoint, and Reporting. http://www.gotdotnet.com/codegallery/codegallery.aspx id=cea30722-cd0a-4ef4-9c75-a5a5e4932b05 You can also just browse directly to the sharepoint and reporting sites and they should give the same error as the Team Explorer interface (the permissions problem, most likely) which should at least help clarify exactly the probl ...Show All

• Visual Studio VSS 'inconsistency found' problem

  Hi mates, please some one help me regarding this issue: We are using VSS for version control. there is sometimes a problem when VSS is not properly closed: which says to run analyze utility. When analyze utility is run. it says that anlyze utility over network is not recommended. whats this when i run it by ignoring this message, it finds some inconsistencies. now how can i fix these. Is there any problem which may occur by using analyze-f. some times it says use analyze -f -v3 -d. what is meant by -v3 and -d. Hoping a quick reply, Ragards, Muhammad Usman Khalid Thanks Alin, Your response was really helpful. Please also tell me something about the backup folders created by analyze utility. It creates backup folders ...Show All

• SQL Server Access Denied - Remote connection to SSIS

  We have 2 SQL2005 servers currently. 1 is a dev box, the other production. To grant remote access to SSIS, I added my developers to the local Distributed COM Users group and also gave them remote Access and remote Activation on the MsDtsServer component. This worked just fine. Recently we applied SP1 and the follow-on hotfixes to all SQL components. I followed the install order prescribed in the Q article and applied all component fixes. My developers are now unable to access SSIS remotely unless I add them to the local administrator's group. I don't see anywhere that a log gets generated to help me track down what's going on. Nothing shows up in my Windows security log, despite enabling audit logging on: Accout Logon Events, Logon ...Show All

• Visual Studio Express Editions Moving Pictures

  How can you move objects (X,Y). And How can I have it do something when I press one of the arrows on the keyboard. nobugz wrote: Check this thread ... The thread you sent me was for visual Basic not C#. Now I have two choices try to transalate the languge or just use Visual Basic. ...Show All

• Internet Explorer Development Hide address bar IE7

  Hi Is there a way to hide the address bar completely, without using the Kiosk mode I work at a library and in IE6 we have the catalogue running without the address bar to stop students typing in the location they want to go to, but this doesn't work in version 7. Any ideas Thanks Ian Hi! In order to hide the Internet Explorer Address Bar, create the following registry key : HKCU\Software\Policies\Microsoft\Internet Explorer\Toolbars\Restrictions\ Then set the NoNavBar DWORD value to 0x00000001. It's that easy Ben ...Show All

• Visual Studio Team System Server not referred to by the FQDN

  I want the server to refer to itself ONLY by the FQDN. http://img116.imageshack.us/img116/2330/properties9sk.jpg if you have a look in the image - the server name is Fully Qualified, although the link that it will send the user to is not. how do i make them both be the same FQ thank you. Yes, that is true, the Sharepoint admin stuff always needs its own port. Here is my wishlist in this area: - Support having the TFS web services and the Sharepoint sites on one IIS site. That would make client access sooo much easier, SSL configuration would be super simple as well. And clients could connect using only one port and one DNS name, which would be great. If this configura ...Show All

• Internet Explorer Development IE7 Tabs

  I am looking for a way using the SendMessage API or something along those lines to activate a different Tab from an external application, so I can detect if a URL is already open and restore that instance of IE and automatically switch to the proper tab. Hi CableHead, If you are looking for a job, I am afraid that I can't offer you one... hell I need one too. What I would like to proposition you with though is a combined effort to write a BHO for IE6 and IE7 in C++ or ATL. It would require a moderate skills level in either one of these languages and also some API and Callback usage.I already have an established customer base and a web site http://www.iecustomizer.com and could offer you a cut of the ...Show All