DFX1212's Q&A profile

• SQL Server Need VB/VB.NET Help

  Hai Folks I Want a coding for Read the SQl Server Log Files Now I am Using SQL Server 2000 For Example: Test is a database Name... Test_Data.MDF is a Data File Name Test_Log.LDF is a Log File Name Now I Create a Table Name Check with Single Field Now I want to check this Details like I run this VB Coding then Its tell me The Last Transaction of the Test database is Create a Table Name is Check I hope You can Understand My Request... In exact Wors I want JobHistory of Some Table... If its Possible VB.NET than Please give me a Sample Code Please This is very Very Urgent................ The SQL Server log file will not give you specific actions taken in the database. The transaction log is different, and it does have a record of every ...Show All

• SQL Server Custom Errors

  Hi, I am showing my report in the web application using Report Viewer control.In the report i have start date and End date parameters.While running the report if i give startdate as '45/66/20007' it is displaying a message which is not user friendly.Is there is any way we can handle this type of errors and display our own custom error messages. Thanks in advance Hi, I try to implement that when the condition occured, it is displaying like in this way: Query execution failed for DataSet1. An error occured during local report processing under this our raise error message is displaying. Is there any way only to display our message which in raise error other than first 2 lines. Thank ...Show All

• .NET Development .NET (v2.0.50727) server committed a protocol violation

  Hi, I’m working on a simple web service in C# running on IIS which sends a GET-Request to an external server. The Get-Request is received properly and processed by the external server. A trace with Network Monitor tells me that the response code from the external server is 202-Accepted. I guess this might cause the problem that the HttpWebResponse class throws the following WebException “ The server committed a protocol violation. Section=ResponseStatusLine” I looked at many mailing lists and found the ( httpWebRequest useUnsafeHeaderParsing="true" ) patch. I changed machine.config and web.config but without any changes. I also changed the header field “connection” in the Get-Request from “keep-a ...Show All

• SQL Server Adding ndf files

  Hi I have prod DB about 16GB and only single file we plan to move to enterprise artitecture and will be more used in future so planning to add more data files for parallelism and better performance. My idead is to have additional 20GB ndf files but ho wdo i configure the existing datafile and addiotnal ndf files Do i restore the DB with a single file and add other files but how do I make sure that the data is spreading across evenly. Can i limit the original file to 20GB and add the other files as 20GB PLS can anyone give me som ehelp AdminAnup restore the database and make sure it's working correctly. Then use 'alter database' statement to add the ndf file to a different filegroup. Then you can re/create a clustered ind ...Show All

• Visual Studio Sandcastle: Problems with HTML display in Firefox

  I just noticed that the Prototype-style HTML generated by the September CTP of Sandcastle does not display properly in the Firefox browser. While not a problem when building the CHM or HxS versions of the documentation; it is a problem when trying to create a web-deployable version of the documentation using using Eric Woodruff's GUI. I haven't tried the VS2005 style to see if it has the same issues. Given that the ability to post generated documentation to the web is a deployment option that seems to be of interest to multiple parties, it would be nice if more than just IE was supported. — Eric — Did you download and apply the SCPresentationPatch.zip file that went along with the last release of ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. device.AvailableTextureMemory somehow?

  Is it possible to get the free or the used VGA memory somehow in Xna like device.AvailableTextureMemory in MDX or GetAvailableTextureMem(). If it is not possible in the XNA framework, can I extract the "native DX device pointer" from XNA and pass it to the C++ DirectX dll and ask GetAvailableTextureMem() with PInvoke Thanks, George I just want to show the used texture memory as a statistics about the current state of the program. Like the Fps statistics (or the number of triangles) that is usually displayed on the top of the screen. ...Show All

• SQL Server Can the data tables in SQL Express database be printed out?

  Hi, is it possible to print out the data tables If, yes how to go about doing it how to print 1 table per page You can show a report in a WinForm application in two different ways: You can build the report directly into your WinForm application - Add New Item | Report (Note: The VS report designer is not available in VS Express.) You can build the report for SQL Reporting Services and show the report using the Report Control in your app. (Note: The report runtime control is a separate download for VS Express.) In-line reports do not require SQL Reporting Services to be installed, they go directly against the database. If you want to use SQL Reporting Services, it would be a typical configuration that RS would be installed ...Show All

• Visual Studio Express Editions sample code to access exchange server

  Hi guys i am new to visual c# programming can any give me a sampl code how to access exchange server and retrieve contacts using c#... Thank You Hi, have a look at this Exchange SDK: http://www.microsoft.com/downloads/details.aspx FamilyId=32774E09-4984-458E-BDB7-ED2BB356BD27&displaylang=en -- SvenC ...Show All

• Visual Studio 2008 (Pre-release) How To: Attach event handler to element in DataTemplate?

  This question/problem is a little bit esoteric, but hopefully someone has seen it before... I need to attach an event handler to the Loaded event of Image elements within a DataTemplate. The Loaded event handling method is in a utility class, so I can't use XAML to attach the handler. In a Window's Loaded event handling method I call this method in the utility class : FrameworkElementFactory factory = listBox.ItemTemplate.VisualTree; while ( factory != null ) { if ( factory.Type == typeof ( Image ) ) { factory.AddHandler( Image .LoadedEvent, new RoutedEventHandler ( OnImageLoaded ) ); break ; } factory = factory.FirstChild; } There are two problems, one is not too bad (just odd) and t ...Show All

• Visual Studio Express Editions accessing custom properties of a file

  I have written an app in VB.net 2005 express. This app is responsible for automatically moving new files around in my FTP server (located in my office). While this app is doing it’s thing, it is gathering information based on the file name and a some of the file’s properties (like the size and the date last modified) and creating text logs. I plan to create a database to hold all of this information, once I make a few tweaks in the app. One of the tweaks concerns the MS Word docs that are uploaded to our FTP. These Word docs have some information that is stored in their “custom properties”. If you were to right mouse click on any of these docs, you have access to the custom properties without having to open the doc. Is there a w ...Show All

• SQL Server Pocket PC database connection

  Hi, I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas Thanks a lot. Imports System.IO Imports System.Data Imports System.Data.SqlClient Imports System.Math Imports System.Drawing Imports System Public Class Form1 Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks" Dim strQuery As String Private Sub Button1_Click( By ...Show All

• SQL Server Two transactions + different rowsets = problem

  PERSONS data table id PName Label ----------------------- 1 John tall 2 Bill rich 3 Mary rich 4 Susan tall 5 Tom thin 6 Lu tall Indexes: id - primary_key Problem: I have a two parallel transactions T1 and T2. Each of transaction deletes data in Persons table. Each transaction deletes unique rowset from table (situation when both transactions are trying to delete one particular row is excepted). So, see the execution timeline below: Example 1 (works fine): T1 T2 ---------------------------------------+------------------------------------- begin tran T1 delete from persons where id between 1 and 3 begin tr ...Show All

• Windows Forms "Window class name not valid" error in designer

  Window class name is not valid. Hide at System.Windows.Forms.NativeWindow.WindowClass.RegisterClass() at System.Windows.Forms.NativeWindow.WindowClass.Create(String className, Int32 classStyle) at System.Windows.Forms.NativeWindow.CreateHandle(CreateParams cp) at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.DateTimePicker.CreateHandle() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.ControlCollection.Add(Control value) at System.Windows.Forms.Form.ControlCollection.Add(Control value) at System.Windows.Forms.Design.ControlDesigner.DesignerControlCollection.Add(Control c) ...Show All

• SQL Server Data flow source for MS Access in SSIS package

  Hi all... I'm creating a SSIS in the designer view of SQL Server BI Dev. Studio (SQL Server 2005) I need to import a whole table from MS Access into my local SQL Server.(this task will be performed weekly, so once working I'll schedule a job for it) I've created a 'FILE' connection to MS Access in the 'Connection Managers'. When I'm on the 'Data Flow' tab I can't find a Data Flow Item to use as a MS Access connection. (available on the 'Data Flow Sources' are only: DataReader, Excel, Flat File, OLE DB, Raw File and XML Sources) What am I doing wrong/missing Thanks for your help. Hi Jamie, I do not see ant OLE DB provider for MS Access. I trie the one for Jet and was not successful i ...Show All

• SQL Server SQLRUN_SQL.MSI is not valid for Service pack 1 SQL 2005 command line REINSTALL

  Hello, I have recently tried to run this command line utility for SQL Server 2005 - "start /wait \sqlfoder\setup.exe /qb INSTANCENAME=myinstance REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[password] SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI" Unfortunately I recived an error stating the "Installation package for the product SQL Server 2005 (64bit) cannto be found. Please locate a valid SQLRUN_SQL.MSI". Which I couldn't find anywhere., so.... I created a fresh instance on my 2005 server, held back on installing SP1, and ran the command line again. This time it worked. My best guess is that the installation scripts check the version header on the MSI file during install and display a compatibilty error t ...Show All