pramod_sp's Q&A profile

• SQL Server Format Dates in ISO 8601

  Hi, I'm totally new at SQL Server, I'm sorry if this question looks very simple, but I just don't know how to change the datetime value in a field on my database. I'm working in vb.net and I have a datetime field in sql server, I can store date values passing this value: DatePick.Value.ToString( "s" ) dates are saved fine, but if want to make this query: Select * from backlog where date1 >= isdate (' 21/02/2006' ) order by date1 asc I get all the values from that field, no filter is done. Date are shown like this 2004-05-23 14:25:10.000 in the query. What do I have to do do I have to change the date format of my field to ISO 8601 how do I use a script or what Please remeber that my sql script sh ...Show All

• Visual Studio 2008 (Pre-release) Session data or how to implement a client side transaction

  I've got a three-tier-setup: 1) Client tier. Using WCF to communicate to tier 2 2) Middle tier. Listens to WCF and uses TSQL to communicate to tier 3 3) SQL Server 2005 as database tier. A client opens a client proxy, sends a command to the middle tier, and closes the client proxy after use. The middle tier, when called, opens a SqlConnection to the SQL Server, does its stuff, closes the SqlConnection and reply to the client using WCF. This is working nicely, transactions in the middle tier work nicely, but how do I start a transaction initiated from the client, across more than one WCF call For this I would need to keep the SqlConnection open and reuse it, but where do I store it How do I recognise the client aga ...Show All

• Visual C# If I deleted a referenced assembly, how's going to happen?

  it's going to find if there is one in the GAC, right it's going to find if there is one in the current directory, right And Thx. that means, once I deploys an assembly at GAC, even I specify the wrong path in my project, it should still work. thx. ...Show All

• SQL Server Drill Through Reports

  Any way to have the drill through report open in a new window on the web ...Show All

• Visual Studio 2008 (Pre-release) Intercepting Service Instance Creation in ServiceHost...

  Hi, Is there a way I can intercept the creation of non-singleton services anywhere in the ServiceHost class I need to be able to pass some data to the instance, the data in question is nothing to do with its contract so I don't want to add them via a Wcf call, I need the concrete instance created. Thanks, Kieron Have a look at the "How to Initialize Hosted WCF Services" post by Wenlong Dong: http://blogs.msdn.com/wenlong/archive/2006/01/11/511514.aspx KjellSJ ...Show All

• SQL Server SQL Express needs to work on XP service Pack one

  SQL Express 2005, MUST work on windows XP Service pack 1, it should not need XP SP 2 . Also it should not require windows server 2003 SP1. This is seriously limiting our possibilities as a development company, this is ruining business , ANYONE READING THIS MESSAGE WHO CARES ABOUT THIS ISSUE, AND THAT INCLUDES ANYONE WHO WANTS TO DISTIBUTE SQL EXPRESS, SHOULD ADD THEIR SUPPORT BELOW, COME ON GUYS, PLEASE LET M.S. KNOW HOW WE FEEL ON THIS ISSUE.... It seems to take some time to participate i signed up but i have not heard a response yet. Please guys lets lean on MS to get the service pack requirments down to xp 1 and windows 2003, this will allow us all to install our software on thousands more computers. ...Show All

• SQL Server Adding SQL Reporting Services to SQL Server 2005 SP1

  I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases: ! Verifing Database Version The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database. ! Creating upgrade script for database version C.0.8.40 ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(Strin ...Show All

• Visual Studio Sandcastle feature requests

  I am now using Sandcastle November CTP with some modifications to build help for several related projects. I am using no additional software except a batch file with some input parameters which automates the build process. In order to get good results it has been necessary to make several changes to the released version of Sandcastle. Many of these changes I think should be included as standard features. I know that Eric Woodruff's SCHB does most of this stuff (and a lot more). However, I don't think an end user should have to rely on this in order to make Sandcastle easy to use. Here is a list of modificiations and extra features I would like to see as standard, especially 1.1, 1.2 and 1.3! 1 General requests 1.1 [vs2005 ...Show All

• Software Development for Windows Vista WorkflowInstance.GetWorkflowDefinition() problem

  Hi, Calling GetWorkflowDefinition() on a workflow instance returns an activity object with an InvalidOperation exception in its <WorkflowInstanceId> property. Is this a bug Ta in advance, Michael Ps I'm simply trying to get the root activity. Hi Michael, Where are you calling GetWorkflowDefinition from I am researching further into this but any additional detail you can provide would be greatly appreciated. WHat build are you using I could repro this with the 3603.4 Beta 2 build and a wizard generated sequential console application calling GetWorkflowDefinition from a couple different places. Thanks, Steve ...Show All

• SQL Server Finding deatail Deadlock info IN SQl Server 2005 Standard Edtion

  We are using SQL Server 2005 with SP2.Originally, we seemed to be having a lot of unnecessary lock escalation occurring to the page and table level. I would like to track down all storedprocedure/queries or function that are being casue of deadlock in sql server 2005 with all deadlock input like transactionID ,command ran,loginID etc.But we have to need to find these information on SQL Server 2005 standard edtion. Is there any tool,command or something like this which track down these information blindly in sql server 2005 without effecting system performance seriously. Ahamd Drshen Hi, When executing DBCC TRACEON (1204,-1) in a command window, you're enabling the deadlock tracing option. ( http://msdn2.microsoft.com ...Show All

• Visual Studio Express Editions URL to download C# Express

  Hi, someone can tell me the URL to download C# Express Thanks! Hi, here you can find iso images of the cds. http://msdn.microsoft.com/vstudio/express/support/install/ ralph ...Show All

• Visual Studio 2008 (Pre-release) Display transparent button image

  Hello, I created a StackPanel containing some Buttons in vertical order. The StackPanel has a specific background picture. The Buttons within the StackPanel contain images (PNG) with a symbol and transparent background. If I show the image on the button using the Image element, the background of the image is not made transparent. I can set the "Opacity" attribute of the button to true, but then the whole button becomes transparent, which is not my intention. I already converted the image to gif, but that didn’t work either. Isn’t Xaml able to determine transparency within pictures and to render it correctly or where is my fault Code: <StackPanel DockPanel.Dock="Left" Width="116" Height="768"> ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. FrameTransformMatrix in .x-file meshes is ignored

  Hello. I use XNA (beta2) and try to load a .x-file into the content pipeline . First everything seems to work fine, but I wondered about the aspect ratio of the shown objects. If I load the .x-file with the "DirectX Viewer" from the DirectX SDK the 3d objects are shown right. But when I load them with XNA the entries in " FrameTransformMatrix " seems to not being calculated. I use blender and its exporter to generate .x-files. Does anybody else noticed this problem Bestregards, MircoS Thnaks a lot, leclerc9. That was exaclty what I misunderstood. I thought, any transform information in the .x-file would be done automatically. You are right, until now I just want to load and render the ...Show All

• Visual Studio 2008 (Pre-release) ...text/plain; charset=UTF-8' of the response message does not match...Add text/plain to valid encoding?

  Hi everyone, I do have the following question. I send a message with an wcf client to a web service implemented in Java. The standard reply, that everything is okay is HTTP/1.0 204 No Content Content-Length: 27 Content-Type: text/plain; charset=UTF-8 HTTP/1.0 204 No Content The client complains about this reply with the error message The content type text/plain; charset=UTF-8' of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder be sure that the IsContentTypeSupported method is properly implemented. Usually, the messages sent to the server are text/xml encoded. Is there a possibility to let the client accept this encoding, too It would be good, if this would ...Show All

• Windows Forms Problem with DataMember of DataGridView

  Hello, I am having some problem with flitering a dataset and setting the same data set as the source of a datagridView. customer_list.Tables[0].DefaultView.RowFilter = "Surname like '" + textBox1.Text + "%'" ; this .dataGridView1.DataSource = customer_list.Tables[0].DefaultView.ToTable(); this .dataGridView1.DataMember = "customer_list" ; But it is not working. In my earlier projects the same code worked fine with dataGrid, well, i did not have to specify the datamember in that case to see the data. Can anybody please tell me, how do i simply show the data of a DataSet(thats been flitered) in a dataGridview hey man, you are simply great, yes it works.... thanks a lot for the help ...Show All