Esp_99's Q&A profile

• SQL Server FileGrowth changes after the execution of DBCC SHRINKDATABASE

  Using sp_helpfile to my database (SQL Server 2005,SP1) I get the following results Data File size=5103616 KB, maxsize=Unlimited, growth=204800 KB Log File size=504 KB, maxsize=Unlimited, growth=204800 KB I execute a maintenance plan having only a Shrink Database Task . This task produces the following t-sql USE [myDB] GO DBCC SHRINKDATABASE(N'myDB', 10, TRUNCATEONLY) Now, executing sp_helpfile I get the same result but if i restart sql server I realize that the Data file's growth changes to growth=25600% (there is no other action or job using my Database) What could cause this Thanks in advance This problem disappears if I choose growth=10% and not growth in MB Restarting SQL ...Show All

• Visual Studio Team System Load test with Unit Test

  Facing the error when trying to run the load test. Error Description :Error LoadTest1 TestProject1 (Computer Name) Could not access the load test results repository: The number of rows inserted or updated by an operation on the results repository (1) did not match the expected number (-1) . Tried setting up the store repository using SQLCMD /S localhost\sqlexpress /i loadtestresultsrepository.sql as I am using the Sql Express. Provided the correct connection string using the "Administer test Controller" yet not able to run the Load test. Help on this highly appreciated. Thanks, Mazzie 1. Are you running the load test on the local machine or using a load test controller I am ru ...Show All

• .NET Development Error when 2 programs connect to one MDF database file simultanously.

  Hi I have a web application (ASP.NET) that connects to a database file the connection string is : " Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" and I have a second application that uses the same connection string to connect to a database but if I run both projects I get the followind error:- 2006/11/06 03:36:00 PM : System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\iBaseService\bin\Debug\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owni ...Show All

• SQL Server Printing Mining Model Viewer diagrams

  Is there anyway to print the mining model diagrams (dependency network, decision trees etc) Thanks, Carrie In the viewers, you could copy the picture (right-click + Copy), then paste in in, say, Word and print. We will release very soon a set of add-in for Office 2007, including a Visio add-in that renders trees, cluster diagrams and dependency nets, giving much more control over printing ...Show All

• Gadgets Access to other objects on page

  Hi, I learn to write a simple gadget, it has a button, when you click this button, it will get the object already existed and alert it. However, seems that getElementById does not work, object returned always null (this object existed). The source code below:  this.initialize = function(p_objScope)  {....      var m_btnDoIt = document.createElement("input");         m_btnDoIt.onclick = this.doIt;         m_btnDoIt.value = "Click me!";         p_elSource.appendChild(m_btnDoIt); ....  };  this.doIt = function()  {            &n ...Show All

• Visual C++ Hexadecimal Representation of an object?

  Hi, I would like to get the hexadecimal representation of an object and display it as a String, how would this been done using C++ .Net (VS 2003) Thanks! Well yes, there are ways to do this through the marshalling classes. I've only done it in VS2005 (.Net 2.0), though. I haven't got 2003 installed now, so I can't really be of much help with an approach for that platform. My suggestion, however, is that you try searching for serializing solutions. Those are often made up by functions which retrieve the binary representation of an object. ...Show All

• SQL Server SSAS 2005 -linking Multiple Dates in a Person Dimension using a single Date dimension

  Hi there, I have two database tables acting as dimensions, Dim_Person and Dim_Dates. Dim_Person table has DateOfBirthKey and RetirementDateKey columns. These are linked to Dim_Date table using Dim_Date.DateKey column. These keys are integer values and are used to lookup the dates from dim_date , ie 21345 = 31/07/1985 Now to my problem; I want to create a single Person dimension that includes both DOB and Retirement Date attributes. If I only have one date attribute in the dimension, say DOB, there is no problem because SSAS automatically links DOB to the Dim_Date based on the Dim_Date.DateKey relationship. As soon as I try and link a second date, SSAS is now unable to tell which of the date fields (DOB or RetirementDate) ...Show All

• Visual C# How can I decleare a function with parameter like int or string keyword?

  I wish to make a function. it has parameter like as int or string. I know typeof keyword. but if typeof keywork use function will be long. ex) testFunction(Type type) { if(type == typeof(int) Console.WriteLine("int"); } this.testFunction(typeof(int)); I only want to use int keyword as parameter. ex) testFunction( type) { if(type == int) Console.WriteLine("int"); } this.testFunction(int); How can I do Sorry, My english skill is low. I wish to make a function that it act differently according to a parameter and the parameter is int C# keyword or string C# keyword, not int type variable or string type variable. function ...Show All

• SQL Server Sending reports through email from aspx page

  Hi friends, I have a datagrid on a aspx page. Each row has fields along with a link for executing the report. On click of this link, I want to execute a report and email the report to the receipents in pdf format. can anyone help me in this regard. Thanx ...Show All

• SharePoint Products and Technologies Displaying Graphs

  How do you display graphs in WSS 3.0 Hi, You can use a free web part to do this. See http://www.wssdemo.com/Pages/chart.aspx Regards, Ian ...Show All

• Visual C# 同 How to use c # to write shrinking algorithm?

  Algorithm use c # language is described shrinking Can write the code example thanks ----------------------------------------- 1: 0,1,9 　 2: 4,8,4 　 3: 7,3,3 　 4: 3,1,3 　 5: 7,3,6 　 6: 2,5,5 　 7: 4,5,9 　 8: 5,5,8 　 9: 5,0,4 　 10: 7,3,5 　 11: 1,9,3 　 12: 0,3,5 13: 5,5,0 　 14: 8,1,4 15: 9,1,6 //estimate next number through these datas --------------------------------- 16:( ),( ),( ) ...Show All

• Visual Studio 2008 (Pre-release) Design Question - What is the best way to implement a human readable string mapping for enum values?

  We have various enumerated types in our system and we obviously want to present human readable values that can be easily configured by our UI folks rather than the cryptic identiofiers that we use in the code. Just wondering what facilities are available in .NET 3.0 to accomodate this kind of thing. In the old days, I would use some sort of string resource and a mapping table for the lookup. Anybody got any cool/slick ideas on this Thanks NIK This all great stuff guys, Thanks. Luckily 1) Localization is not an issue - probably the last English-only app. in the world, but I'm not complaining. 2) We own the code for all the enums. Seems like whether or not I use XAML resources or traditional string resources ...Show All

• Windows Forms Print Preview problem(Bug)

  Hey, I have this code in the PrintDocument control under the PrintPage event: private void printDocument_PrintPage( object sender, PrintPageEventArgs e) { RtextboxUC thisrichtextbox = GetCurrentTextBox(); //Start printing text and store last letter... checkPrint = thisrichtextbox.Print(checkPrint, thisrichtextbox.TextBox.TextLength, e); //Check if there should be more pages if (checkPrint < thisrichtextbox.TextBox.TextLength) { e.HasMorePages = true ; } else { e.HasMorePages = false ; } } There are no errors, but when I test it on my program and click print preview...when it opens the PrintPreview dialog It shows the dialog that is telling you how many pages it is det ...Show All

• Smart Device Development Connecting to WebService from PDA via ActiveSync problem

  I have a PDA running WM5 using CF 2.0, written in VS2005. SQL Mobile (or whatever it is currently called is installed) My application connects to a Web Service (running on an out of state server, via the internet) to upload and download data. The Web Service was added to the application using “Add Web Reference” in the solution explorer. wrServiceMain is the name of the added reference. It just returns a dataset of needed information. The PDA App can upload/download data under the following conditions: - Running in the emulator - Cradled on my Work PC using ActiveSync 4.2 (Windows XP) - Cradled on my Home PC using ActiveSync 4.1 (Windows XP) - Free internet hotspot at local coffee shop via Wireless - Surf ...Show All

• Windows Forms Making a decent OO app with DataGridView ?

  Hi, I'm wondering if it's possible to make decent OO based apps with the DataGridView. How does one keep the data and view seperated because right now every update in the back-end data has to be executed in the gui thread, which is quite annoying and makes for very bad code. Does anyone have any tips on how to make a DataGridView containing objects that will be changed both thru the gui as well as code in many different threads (4+) I had tought of using a BindingSource and Objects implementing the INotifyChanged interface, but this only makes it so that the BindingSource cannot be altered except on the gui thread. My only option seems using a List in the back end and using this as basis for the BindingSource and keep working o ...Show All