mrkul's Q&A profile

• SQL Server TSQL Code Checker

  Is there a tool similar to FXCop that will check for TSQL ( or just SQL ) errors , ommissions etc and suggest code improvements Also, along the same lines, are there client-side JavaScript and VBScript tools similar to FXCop Thanks Short answer: no. Long answer: not really... For SQL Server 2000, there is a SQL Server Best Practices Analyzer that does some basic code-checking of T-SQL on objects in your database. http://www.microsoft.com/downloads/details.aspx FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en For SQL Server 2005, there is nothing available at the moment. We are making a new version of SQL Server BPA, but it will not have the T-SQL checking capabilities. My team's blog talks about the next ve ...Show All

• Customer Care Framework a problem with SSO Single Sign-On

  when i followed steps in lab D "Lab D: Use of SSO" Exercise1 and Exercise2 with application named " SSODemoLoginWebApp " every thing run ok, but when tryed to do the same with my application i found that username text box and password textbox not filled with username and password data, and nothing is happend. i tryed this with many applications i have, and when try to use my application url with the same name of  the application " SSODemoLoginWebApp " in sample Lab D it works fine, i think there is one step is missed, please i want to know is there any missing steps i appreciate your help   Check the app.xml and appmapping.xml files in " C:\Program Files\Common Files\Enterprise Sing ...Show All

• SQL Server creating a Smart Average

  Hello all, I need to create "Smart Average" calculating sales following way: Average of the "active months" of the customer. For instance, if we're in November, we'll take the first month this customer bought (for instance October) and we'll create an average ([sales for October – November]/2) How do I accomplish this in MDX Thanks, Liran Liran You need first to find the first month when customer bought something. Unfortunately FirstNonEmpty semiadditive measure won't help here, since it will return the measure value, not the member on Time dimension itself. So you will have to do it in MDX - something like this: Avg(NonEmpty(Date.Month ...Show All

• Visual Basic Sending text to another PC

  I'm trying to create a program to send messages through a network. Just one problem, I can't seem to get text to send to different Pc's. Can someone help me please! What have you tried so far You can try using the System.Net.Sockets classes, such as TcpClient and TcpListener . They will create a communication channel and you can then send text over the channel to another PC. The example code at the links above even do something similar to what you want to do. Good luck! ...Show All

• Internet Explorer Development CSS Div problems

  Hallo all i get this problem whit my code i can understand why the to top and bottom background is more px in i defind the div tag to be. here is my HTML and CSS code. <div style="width:586px; height: 216px;"> <div style="height: 4px; float: left;"> <div style="float: left; height: 100%; width: 8px; background-image: url('. $Url .'includes/images/gbog/topLeft.png);"></div> <div style="float: left; height: 100%; width: 570px; background-image: url('. $Url .'includes/images/gbog/top.png);"></div> <div style="float: left; height: 100%; width: 8px; background-image: url('. $Url .'includes/images/gbog/topRight.png);"></div> </div& ...Show All

• SQL Server Mirroring Problem using Certificates ( between LAN and DMZ )

  Hello Guys, Here it is my scenario; My principal server in LAN and my mirror server in DMZ and Iam using certificates both partners (I dont use witness server). I did not use wizard.I have just Setting Up Database Mirroring Using Certificates (Transact-SQL) ( http://msdn2.microsoft.com/en-us/library/ms191140.aspx ) Iam sure all steps are ok!(I mean ports,certificates,users,logins,endpoints,GRANT CONNECT ON ENDPOINT,SP1....) But I am still getting error Principal Server; Database mirroring connection error 4 'An error occurred while receiving data: '64(error not found)'.' for 'TCP://195.xx.yy.zz:5022'. Also,Mirror Database status changed (Restoring---->In Recovery) I tried many tests but I did not succeed.Do y ...Show All

• SQL Server how to save/publish cube results from analysis services 2005

  We can't figure out how to publish cube results from analysis services 2005 management studio. We can't find a way to save work in progress or save results sets other than in excel with the cube analysis add in.  Some of our data sets are too big for excel. Has anyone done this Do you mean "How to save the views that I create in the Browser tab of Cube in  BIDS " If thats, the question, one easy way would be to open a profiler, capture all the MDX, and use it in Reporting or other applications. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. d3dx10d.dll

  I was using the Direct3d9 samples from DirectX and while running i hadn't got any problems, but when i was copying the code from the sample into my own empty project a message occured that i haven't got the d3dx10d.dll. 3Nu, Which Version of Vista and DirectX SDK do you use Bleak-Pear, you are sure that you have used EmptyProject and not EmptyProject10 ...Show All

• Visual C++ Namespace Question

  Hi folks, I was just wondering if it would be possible to use .NET namespaces in a plain-old Win32 application It'd be nice to use the String's class, for example, or the StreamReader/Writer classes, etc. If it can be done... how would you go about doing it Any info would be appreciated! Thanks, Zero ...Show All

• Windows Forms URGENT HELP - PRINT

  C# - Windows Application (VS 2005) - OLEDB --------- Hi, I have a network printer IP: 1.2.3.4 shared name \\ns\admin_print$ I want to use a button within a form to print out the details of the form (data is from database). When I clicked the button, it will print straight to the designated printer. I do not want to have a print dialog to select printer. I do not know how to start with the code. Can someone advise private void PrintReport() { } Hi David, thanks but that is not what I required. What I need is to define the printer source, i.e either by IP address or network share name. In a network, there might be a few numbers of network printers but I want this form or report to prin ...Show All

• Windows Forms DataGrid and DataGridView issue?

  I am trying to use either a DataGrid or a DataGridView to list records that could later be edited through the click even of a row. My problem is this: while I am developing, I have to basically re-create the control by editing the designer generated code if changes are made to the control after compiling the app. Is there a way to get around this, or am I doing something wrong I understand that, and even as we speak, I have made some changes in the properties window, and when I compiled the app again, I got a an error that tesst me that the datadrig control does not exist.  However, when i look at the designer code, the Datagrid is there as a private variable, and is not available to the UI th ...Show All

• SQL Server Coloring Matrix subtotal row

  How do I color the text of my subtotal to red if the subtotal value is negative in a Matrix I am sorry if my question is being answered before. If so, can you please give me the link. I tried searching this forum and couldnt find the right answer for my problem. thanks ...Show All

• Commerce Server Commerce Server 2007 Get ShippingAddress

  Hello, I am trying to retrieve the shipping address from the CommerceOrderForm object, it was set by using order.SetShippingAddress(shippingAddress.OrderAddressId) - order = CommerceOrderForm. Is there a method which will show the ShippingAddressID from CommerceOrderForm Thank you, Dmitry I believe the OrderForm.SetShippingAddress() and OrderGroup.SetShippingAddress() methods set the LineItem's ShippingAddressId property for all line items in the OrderForm collection so you should be able to retrieve it by using the LineItem.ShippingAddressId property. Jeff Lynch MVP Windows Server System - Commerce Server http://codebetter.com/blogs/jeff.lynch Oops: Sorry Joesph, I didn't see your answer before posting. ...Show All

• SQL Server Domain group logins failing on SQL 2k5 workgroup

  This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're supposed to be able to access. The SQL Server is not a domain controller, but is a member of the domain, and domain logins do work for Windows-login purposes on this box. The problem is that when users try to connect to the SQL server, they are denied access. An error 18456 is thrown, and logged in the Application event log stating "L ...Show All

• Visual C++ Learning MFC

  i want learn vc++ (1) Doc\View Architecture (2) Knowledge of MFC (3) DLL (4) COM\DCOM (5) Device Driever Can you please guide me how can i start. i am beginner. i have not much idea about vc++ specially MFC. which book/certification course will help me in this regards Regards Hemant Joshi hem_kec@yahoo.com You should consider reading a book, such as Programming Windows by Charles Petzold. See http://www.amazon.com/gp/product/157231995X/sr=1-1/qid=1155901766/ref=pd_bbs_1/002-5043776-5890412 ie=UTF8&s=books . ...Show All