sc2003's Q&A profile

• SQL Server Back-up DB but keep the files for 3 days?

  Hi I have created a job to backup all our database. It works fine and creates .bak files in default folder. I have scheduled the task to run every 4 hours. My question is how can i modify or program this backup plan to keep the backup files for only last 3 days and delete older backup files Mits Thanks for the suggestion! I didn't know about that site. I see a closed item where the response was that "hours" would come back as a duration in SP2. I voted for that and the open item about the same issue. I also authored an item to make the cleanup task available through the wizard as it was in SQL2000. Thanks for taking time to listen to our concerns and point me to the right forum for ...Show All

• Windows Forms Updating PropertyGrid values

  This post has been moved to the C# General forum: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=922965&SiteID=1&mode=1 ...Show All

• Windows Live Developer Forums MSN Games

  Hi everybody, i would like to learn to develop games for MSN. Can anyone point me to the right place to start Any good docs, sites to visit Thanks in advance,Rod. Hi there http://download.microsoft.com/download/a/7/4/a7470441-4171-4c07-93ca-ef5f07e7a9c3/Casual%20Games.zip this kit has reference for MSN Games development ...Show All

• Visual Studio Tools for Office Task pane / Action pane needs to be available accross different workbooks but I cant make it!

  Hi I was wondering if someone could help with a problem on action panes / task panes in Excel. I have a task pane which is added via code (See below). I need the task pane to "stay put" as I navigate between different workbooks. If I load or add a new workbook, then the task bar is not available to these and remains only available to the worklbook in which it was added via code. My objective is to have an add-in which contains and controlls the functinonality of the action pane and have this available has I navigate between different workbooks. I hope some one can help. Many thanks for your help. David Edelman Public Class ThisWorkbook Public oActionPane As New ...Show All

• Visual Basic button_click on User Control setting property button on Form

  How could I set up a publish/subscribe event mechanism so that the user control button event below does not have a hard-coded reference to a button on the main UI form whose 'visible' property it should be able to set. What I want to do below creates a circular reference. Mainform references User Control User Control references Main Form. I don't want to do that. Private Sub User_Control_Button_Click( ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles User_Control_Button.Click MainForm.Button.visible = true End Sub Thank you, -Greg Hi, you could try it like this... 1. Put a button named mainButton on the form 2. Create a user control with a bu ...Show All

• SQL Server To make scheduling jobs as steps

  Hi, The schedules created in report manager are added as jobs in the SQL Server Agent. Is there any way to convert these jobs to steps, so that they can be added into SSIS. Thanks in advance Meenu ...Show All

• .NET Development How to create AppDomains when assemblies reside in IsolatedStorage?

  The project entails a server that hosts the running of user code in sub AppDomains. A specific directory in a non-roaming IsolatedStorageFile contains the assemblies the user code references. For file system security reasons, it is desirable to be able to point the new sub AppDomain's base directory to a sub directory of the isolated storage file. Is there someway of doing this - without copying files to the actual FS For example, by refering to the actual ISF directly via:<SYSTEMDRIVE>\Documents and Settings\<user>\Local Settings\Application Data\<ISFName> How would the ISF's file name be determined in this case More generally, a furture requirement for the server is to allow cabinets or zip archives to be us ...Show All

• SQL Server Reporting Services XML documents - no default namespace prefix - sp_xml_preparedocument requires one

  We have a process to verify Reporting Services report content: Run report and create an XML output file Import XML into SQL Server 2005 via OPENROWSET function Parse XML content using sp_xml_preparedocument and OPENXML to allow values to be inserted into corresponding tables The sp_xml_preparedocument function requires a prefix to exist for each namespace. However, XML files created via Reporting Services export option do not give a prefix for the default namespace. This prevents the data from being parsed. Does anyone know of a way around this For the time being we are manually inserting a prefix for the default namespace into the XML files. Thanks Neil Hi Neil The switch from ...Show All

• Visual Studio Express Editions virtual memory

  how can i increace virtual memory on a laptop. I think you would have to use API functions from the system dlls. I'm not sure, but I think system32 or user32, or some thing might have them I again, am not sure, but I don't think Visual Basic is even capable of accessing those things, although I may be wrong ...Show All

• Smart Device Development How to Maximize window when running external program?

  Hi, In my program, I have a menu option to open the Pocket PC Calculator program ("\Windows\calc.exe") which works fine, but I woud like to open it maximized so the user does not have access to the start button. Here is my current code: '** Code Start ** (Visual Studio 2005, .Net Framework 2.0, Visual Basic Code) imports system.diagnostics imports system.io ... Dim runCalc As New ProcessStartInfo() runCalc.filename = "\Windows\calc.exe" Process.Start(runCalc) '** Code End ** One potential problem with running calc.exe maximized, though, is that the user will not be able to close the program as the "X" button will not be there. Any ideas on how to do this short of writing my own ca ...Show All

• Visual Basic Compiler does not warn when assigning to readonly property (Restated, Microsoft responses so far inadequate)

  Dear Microsoft, I am afraid that the Microsoft respondents to my problem so far have missed the point! That is why I try it again in a new thread. My original problem statement was as follows: "compiler did not warn me even though, I was assigning a value to a public readonly property. Not only that, I have configured the project's compile settings to treat all warnings as errors. Option strict is on." Later, I provided following information in my replies in my first thread: I am using VB Express 2005. I am developing a solution with multiple dependent projects/modules/assemblies. The public readonly property is declared in one project, while I tried (erroneously) to assign a value to this property in a class contained i ...Show All

• .NET Development writing as plaint-text with StreamWriter

  Hello, I want to write an output file for my program.I write the data into it with StreamWriter and when I check it in MS-DOS with edit.com, I see that Turkish characters are not displayed correctly.How can I write the file as a plain text in which the characters are displayed correctly well MSDOS won't display any other characters than the standard system one's I believe. I guess you can specify the Encoding type in the StreamWriter constructor to the encoding you wish to write the file as. ...Show All

• SQL Server Using Triggers - Catch RowID

  Hellow everyone. I want to use trriger on table when every time one of the column change I want to insert some of the new data in the row (only one row handle each time), to another table. How can I know what is the row which update/insert I need the PK of the row. Thanks in advance Itai Triggers are fired by DML statement not per row, so you have to handle the multiple rows effect. The data of the old / new values are presented in the INSERTED / DELETED tables. INSERT --INSERTED Table DELETE -- DELETED Table UPDATE --Old data in DELETED table , new data in INSERTED table HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Remote connection problem

  I have SQL Server 2005. My system is in a local network. In the network others are able to access my database. I have the permission to access the database of others but still I am not able to access the others database. Can any body tell me that what can be the reason Best Regards, Kanhaiya Lal Please provide more detail info here, such as what error message you came across Did you see any clue in Server ERRORLOG Is it connection failure or data operation failure or others What is you configuration such as client connection string, server sku Remote/local client and server OS Thanks! Ming ...Show All

• Visual C# read HTML content using c#.net

  Dear all, I am trying to read HTMLcontent using C#.net, but its returning content as a unicode characters .so how can i read the characters form HTML. Thanks, Aya. hi, first of all i want you to check 2 things, open this webpage in IE then to go view menu and  check encoding and source, 1. encoding i have it here saying Arabic(ISO) not utf8, 2- for  source your will find this in the page head <META content="text/html; charset=Arabic Mac" http-equiv=Content-Type> 3- when you read this page using streamreader and check encoding it will print this value using ( StreamReader sr = new StreamReader (stream, Encoding .Default)) { enc = sr.Curre ...Show All