dark_viper's Q&A profile

• SQL Server msdb..backupset.backup_finish_date -- changes from SQL2000?

  It appears that the behavior has changed for the backupset table in the MSDB database between versions. In SQL2000 backup_start_date & backup_finish_date were populated correctly. In 2005, backup_finish_date is the same as the backup_start_date value. Is this a bug or should I be looking for my backup timing elsewhere in 2005 Thank you. I can't repro the problem. It works fine for me. I use this query to get a quick look at timings. select top 100 database_name, backup_set_id, type, backup_finish_date, backup_start_date, datediff (second,backup_start_date, backup_finish_date) secondsToC ...Show All

• Visual C++ XML Comments

  When I first heard that Visual C++ 2005 was going to support XML documentation I was very excited to try the beta.  One fo the things I expected was the XML documentation experience to be identical to that of C#, but here are some of my experiences. The triple slash (///) before a function header doesn't automatically generate some blank xml comments for me When I place XML comments above a function header and specify information about its arguments, the intellisense doesn't seem to pick that up when I start filling in the arguments of a function call (like it does in C#) While I do see the XML comments within the intellisense before I ...Show All

• SQL Server Creating a job for SQL 2000 using SQLDMO in c#

  I have a quick question on how one can create a backup job using SQLDMO in C# I have not really been able to find any information on how to do this. I can create backups using SQLDMO and I can create Jobs but I do not know how to bind the two together. So if anyone has any information on how to do this it would be great. I'm writing a similar app using SQLDMO. Could you please give me sample code of how did you combine the two Thanks in advance. mct. ...Show All

• SQL Server How Can I Do This Better in SQL 2005?

  I have two tables, one contains ids(very small, less than 100) and the other contains history(very large, over 1000 mil); table a (id int) table b (id int, contact_datetime datetime, id2 int, id3 int) I need to pull latest contact date and other id fields from table b fastest possible. in 2000, I did following sql query, select a.id, b.contact_datetime, b.id2, b.id3 from table a inner join table b on b.id = a.id where b.contact_datetime = (select max(contact_datetime) from table b where id = b.id) Do you have any better ways to do this in 2005 That is probably the best way without modifying any code (assuming ...Show All

• SQL Server how to knw which column is primary key in a table

  hi all my question is which query shud i use in sql server 2000 to get which column or columns are primary keys of table i dont want to use any stored procedures only sql query sp_primary_keys_rowset is one of d stored proc in sql server 2005 but i couldn't understand which query they are using i only want to use sql query select o.name as TableName, c.name as ColumnName from sysindexes i inner join sysobjects o ON i.id = o.id and o.xtype='U' inner join sysobjects o2 ON i.name = o2.name and o2.parent_obj = i.id and o2.xtype = 'PK' inner join sysindexkeys i2 on i.id = i2.id and i.indid = i2 ...Show All

• Visual Basic Where to find BASIC help after downloading and installing Express with small option

  I thought I remembered being asked if I wanted to download a monster help file and since I wasn't sure about Express, I said no. Now I have used it for a while and want to avoid the online help - where do I find it Other learning resources can be found here: http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx The only place I saw to download the express MSDN library was with the express products...Download it again: http://msdn.microsoft.com/vstudio/express/vb/download/ Full Installation: 1.3 GB Also includes MSDN Express Library 2005 and Microsoft SQL Server 2005 Express Ed ...Show All

• Visual Basic Using VB2005 DLL in C++

  Hi, I am total beginner to C and C++. I wrote a VB2005 Class Library DLL which I can reference from VB and use its members. Now I would like to use it in a C++ program the same way. I read I need to reference it so I right clicked on the project ->references->Added a path to the dll -> clicked on Add New Reference and it came up with a blank form which didn't have a browser on it, wouldn't accept inputs and didn't have anything in it. Can someone tell me how to use a VB DLL in C++   Bill H123 wrote: Hi, I am total beginner to C and C++.  I wrote a VB2005 Class Library DLL which I can ...Show All

• Visual C++ linkLabel_LinkClicked

  With managed C++ what would I have to type on this linkLabel_LinkClicked code in order to make my link go to a website of my choice #pragma endregion private : System::Void linkLabel1_LinkClicked(System::Object^ sender, System::Windows::Forms::LinkLabelLinkClickedEventArgs^ e) { } }; } http://www.codeproject.com/system/newbiespawn.asp df=100&forumid=3298&exp=0&select=706737 ShellExecute is the answer. ...Show All

• Visual Studio Team System Advanced work item customization...?

  Hi all, I am attempting to create a custom work item type for our development methodology. Among other things, I would like to have a field that auto increments (a unique ID number for each work item) and I would like to have some date fields populate with the current date when a value in a drop down list box is chagned. Basically, I'm looking for any guide a little more advanced than the "step by step" ones I found in the help. A copy of the schema would be helpful too. We are currently using the most current Beta of TFS (updating to the RTM as soon as our IT gal gets back from vacation) with the RTM of VS 200 ...Show All

• Visual Studio Express Editions back button code

  code for generic back button: WebBrowser1.GoBack() as for the progressbar, im still working on it. Im close, tho. ...Show All

• Visual C# bubble sort

  I am kinda new to programming and need some help in completing an excercise I'm on. I have two bubble sorts to sort an array of structs into ascending or descending order on the users prompt. ie. the users types "A" for ascendng and "D" for descending then the data is displayed. Once this data is on the screen is there a way I could then toggle between the two (A & D) This is all being done in a Console App by the way. Thanks Thanks Paul, I think this will help alot. Cheers for the advice ...Show All

• Visual C++ Help with Extern Linkage

  Hi Everyone, I am new to visual c/c++ and i am using visual studio. I am working on a project that compiles with C. Now, i have to use some header files which have structures, templates, etc which are written in C++. I have no idea how to link these two languages together. The command that i give to run the compiler for my project (Ethereal) is "nmake -f makefile.nmake" and it compiles the file i have for C, but gives errors since the included files are in C++ . I would truely appriciate if someone could guide me on what to do and how! Thanks a ton. Best regards, Sahil Thank you! :-) the good part is that the C++ header ...Show All

• Visual Studio LocalReport.GetDefaultPageSettings NOT return correct RDLC values.

  Hi, How do I go about printing a landscape rdlc, the LocalReport seems to like portrait, I can flip the device info's width and height, but there must be a proper way to accomplish this. any help would be appreciated, also if I need to rely upon changing the DeviceInfo where would I find the properties of the rdlc that tell me its landscape. If I examine the LocalReport even with a rdlc landscape version, it thinks it is portrait.. I noticed that LocalReport.GetDefaultPageSettings returns a "ReportPageSettings object which also has two non-public variables called: m_pageHeight and m_pageWidth, both of these variable contain the correct ...Show All

• Visual Studio Express Editions Confirm after DeleteItem_Click on DataGridView?

  Visual Basic 2005 Express Edition: Is there any way to ask for confirmation after the user selects the "X" to delete a record The code below did not work, the records were deleted even if "No" or "Cancel"! Private Sub BindingNavigatorDeleteItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click GetFileName() Dim msg As String = "Delete Rx Record Permanently " Dim title As String = "Delete Rx Record Permanently " Dim style As MsgBoxStyle = MsgBoxStyle.YesNoCancel Dim response ...Show All

• Visual Studio Render PDF with ReportViewer Control

  I'm using ASP.NET 2.0 and Reporting Services 2005. I'm trying to use the ReportViewer control to generate a report in a PDF format server side. Here is the code to generate the report in HTML format: Dim params(1) As ReportParameter params(0) = New ReportParameter( "param1" , "param1" ) params(1) = New ReportParameter( "param2" , "param2" ) With rvDisplay .ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote .ServerReport.ReportServerUrl = New Uri( http://server/vdir/ ) .ServerReport.ReportPath = "/folder/report" .ServerReport.SetParameters(params) .Sho ...Show All