Behnam Fagih's Q&A profile

• SQL Server Check if a windows/nt user account exists

  I have some script which creates/grant priveleges to windows/nt users to DB but i frequently get the message below: Windows NT user or group '<user or group>' not found. Check the name again. I understand that this is because the said user/group is indeed not present in the environment I'm running the script (ie. testing and production environment). But is it possible to have some sort of checking whether the user/group exists in the environment so that I could determine whether or not to call some lines of code Not sure if this is possible so i had to ask. c",) SELECT * FROM sysusers will show the users from the current database. There are columns like isntname ...Show All

• SQL Server Temporary Table

  Dear all, I have two store procedures,sp1 and sp2 sp1 : some codes here SELECT * INTO ##A FROM ATABLE sp2 : some codes here SELECT * FROM BTABLE LEFT JOIN ##A ON BTABLE.a= ##A.b I use vb.net to call sp1 first and fill the data to dataset,then call sp2 and fill the data to dataset. So you find that sp2 is left join to ##A. ##A is a result from sp1. If I run sp1 first,sp1 can provide the data to dataset(VB.NET) and sp2. It can improve the perfermance. So I can not use local temporary table #A The problem is : When two or more users run the program at the same time. It give me an error message : ##A is exist at server. My question here : (1) I know ##A is a global variable. but users use differen ...Show All

• Software Development for Windows Vista windows vista

  i would like to install an application as standard user, windows vista does not allow me to that . it ask admin approval. is it possible to give a standard user installation rights in windows vista. thanks This appears to be a duplicate question. See my new response in your original thread. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1184394&SiteID=1 ...Show All

• Visual Studio Express Editions maskedtextbox problem?

  i have a problem regarding maskedtext box....i masked the textbox as a date and time.... i want is to input only valid date(12/25/2006) if user attempt to input date (50/50/5555) then user will promt that input is invalid pls help     Try DateTime.Parse( "Jan 331, 2002" ) Catch MsgBox( "Error" ) End Try ...Show All

• SQL Server Save time in Script Component which is almost forwarding

  Hi, I have to add the fields coming from the source AS IS but, I need to add current date as a column to it. So, What I do is to add an Script Component and add each and every output column in that along with defining their types and writing an "assignments" script. Is there any possibility for me to save time in the scenarios where I am almost passing on the information to next level in the data flow Any input regarding this will sincerely be appreciated. Fahad ...Show All

• SQL Server Mirroring between Standard and Enterprise editions...

  Hi All, We are going to use database mirroring and database snapshots for reporting. The principal server runs SQL Server 2005 Standard Edition and mirror (reporting) runs SQL Server 2005 Enterprise Edition (64-bit). I failed to setup database mirroring trough GUI using SQL Server Management Studio and got this error: This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition. But when I use T-SQL commands I was able to setup database mirroring and it works OK so far. SQL BOL says that one of requirements for database mirroring is to use the same SQL Server editions but I am wondering if it wor ...Show All

• Windows Forms deploy without GAC

  Hi I m having a very hard time finding anything that can either how to do this or if it is even possible -   I want to call a c# dll from within a plain C++ dll (unmanaged) without registering it in GAC. I have create c# dll by useing COM Interop and so Export it into a typelib by using regasm(also know about regasm /codebase , tlbexp and gacutil). and then use it in my plain c++ dll. Application is running fine on my machine when managed dll has referance inGAC. The problem is, I cant deploy these dlls on client machine without registering it in GAC Is it possible to deploy managed dll without giving it in GAC do i have to change configuration of my project in vs 2005 Regards ...Show All

• Windows Live Developer Forums Getting phone numbers from find()

  When I do map.find() I get back an array of VEFindResult which has a description field which contains the address but no phone number. I know local.live.com has the company's phone numbers as well as atlas.freshlogicstudios.com. Is there a way I can get this ...Show All

• SQL Server Why only admin can access SQL 2000 database?

  We have SBS2003 and SQL2000 is running on it. Recently we built a trips database and Installed trips application on it but the problem is that only the administrator can run Trips application. Other domain users cannot get access to the new trips program. I added the users on database and double checked. When normal user logs on, these messages show up: Message 1: "MS sql Server login Connection failed: SQLState: '01000' SQL Server Error: 53 Microsoft ODBC SQL Server Driver DBNETLIB ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error:17 Microsoft OBDC SQL Server Driver DBNETLIB SQL Server does not existor denied." Message ...Show All

• Visual C# sendkeys.send doesn't work from backgroundworker

  hello, I have a backgroundworker component . In the event handler for it I use sendkeys.send but it doesn't work. However when I try sendkeys.sendwait it works. Why ...Show All

• Windows Forms How to center text in a textbox for a field with trailing spaces?

  Howdy, I would like to center text in a textbox, however, when the control is bound to a table field, the trailing spaces in the field cause the Text value to be pushed to the left edge of the control, i.e.: [A___], instead of [ A__]. FWIW, I have set the MaxLength property to 1. Interestingly enough, when I enter a character into the text box, the new value is centered, but values from the TableAdaptor are not. TIA, Karl Use a custom binding to format the data before it is displayed, e.g. class StringTrimBinding : Binding { public StringTrimBinding( string propertyName, object dataSource, string dataMember) : base (propertyName, dataSource, dataMember) { } protected override ...Show All

• Windows Live Developer Forums Batch Location Additions / Location Import

  Hi, I'm new to the local.live mapping system and need a way of adding location push-pins in batches, I have a CSV text file with about 100 locations - is there any way of importing these into a saved map Thanks Rob You'll need some work to convert that CSV file to the appropriate GeoRSS file. You'll need to upload the GeoRSS file onto local.live (see the collections tab in local live) and then call it back in your VE application. More information (and on what a GeoRSS file format is) here: http://dev.live.com/virtualearth/sdk/ref/HTML/WorkingWithLayers.htm Hope that helps ...Show All

• Visual C++ Internet Explorer Information Bar

  How can i stop Internet explorer information bar from being deisplayed for my ActiveX Control I tried using IObjectSafetyImpl but it didn't work. Thanks in Advance For such issues, please use the newsgroups at http://msdn.microsoft.com/newsgroups OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio 2008 (Pre-release) WCF and C++ integration tool.

  Hi, Does anybody know about a reliable (and tested) tool for integration between WCF and C++ Thanks, Dror. You should be able to use the WCF service moniker from C++ clients. Take a look at http://msdn2.microsoft.com/en-us/library/ms733928.aspx  for documentation on this. Hope this help, Andy Milligan. ...Show All

• SQL Server Win2K Users Cannot Connect to SQL2005 Database

  Hi, I recently migrated our database from Access to SQL Server 2005. All the WinXP users can connect to the new SQL2005 database. But all the Win2K machines fail to log on. To diagnose the problem, I tried to connect from a Wind2K machine using an .udl file. The connection failed because "a provider failed to initialize". The SQL2005 server is residing on a WinXP machine. Users log on via SQL Server authentication layer using a dedicated login that only has read/write privileges to one specific database. Does anyone know a solution Thanks in adance. Regards, Vladislav Hi, could it be that they are using an older MDAC version than the WinXP machines Did you try using the SQL native ...Show All