Grayson Peddie's Q&A profile

• SQL Server Transaction Log does not truncate and shrink using a SQL Server 2005 Maintenance Plan

  We are using SQL Server 2005 (SP1). I have created a maintenance plan that backs up up the datebase every night. The problem is that the transaction log is continuing to grow. I have been told that a full backup will automatically truncate and shrink the transaction log. However, this is not happening. How can I truncate and shrink the transaction log after a full backup as part of our maintenance plan. Thank you. I experience the same thing as davidg12. We also do a full backup every night (including of the transaction logs!!) - using the Full recovery model. However, no truncation is being done. Please post the solution if you find one...! ...Show All

• Visual C++ Visual Studio 2005 - Do I need VS2005 Team System in order to build ia64 executables now?

    I am a little confused, when I read this: http://msdn2.microsoft.com/en-us/library/hs24szh9(VS.80).aspx Does this mean I need to buy VS2005 Team System in order to build ia64 executables now or does this mean I need VS2005 Team System if I want to build on the itanium platform Anyone know It wasn't like this before. Why this change Does this mean even if we have an MSDN Universal Subscription... we need to purchase Visual Studio 2005 Team System separately in order to develop and test on IA64 environments ...Show All

• SQL Server how to find out minimum size

  hello i have one doubt.can anybody clarigy it. every time i am doing my database shrinking manually. what i am asking i find out every time when i shrink my database that sql is showing minimum size of database to shrink.how can its getting minimum size but i need to find out how to get minimum size of particular database programatically. thanx excuse my poor english "every time i am doing my database shrinking manually." Bad planning. Disk is cheap. You probably don’t backup your database acording to the recovery model of it. Shrinking database files drives to disk fragmentation on it, witch goes to low performance. Never think about "shrink" as one of the "best pratices&q ...Show All

• Visual Basic Basic Programs

  Are there any good sites that tell you how to do some fairly simple but fun programs Not like a tutorial that walks you through what each little thing does, just something that shows you how to make a certain kind of program What you are describing is a tutorial All you have to do is apply a bit of understanding to change the application to do something slightly different. If this is a learning exercise to get you developing in VB.Net then I would recommend watching the tutorials http://msdn.microsoft.com/vstudio/express/vb/easytolearn/ This will get you going - Once you start understanding how the language works and how a solution is build then you can come up with your own ideas of things to bu ...Show All

• Visual Studio 2008 (Pre-release) lambdas, statements, and expressions

  Does it seem a bit odd that lambdas with statement blocks are supported, but cannot be converted to expression trees Will statement blocks be supported as fully comnvertible to expression trees at some later time Hi, I asked this question some time ago ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=466982 ). I was very disappointed when I was told that it won't be supported in the final release :-(, because it limits the subset of C# language that you can translate to different language (like T-SQL in case of DLINQ) or analyze or whatever you like... We can only hope that it will be added in the C# 4 or so... ...Show All

• Visual Studio HELP!!!...There is no: File > Export Template

  Hi everyone, i need some help here, i'm doing some examples with Minimal Language template, well...after the Start without Debugging...in the experimental VS 2005 i need to use the Export Template option in the File > Export Template...BUT!! there is no Export Template Option ...someone can help me plz ! > If it is grayed out, then please provide some additional details: >Which version of the DSL Toolkit are you using Not using it, as far as I can tell. > Does this happen for any other template as well Enabled for VB projects. Disabled for VC++ > Do you get any package load errors When >Can you export templates from the actual Visual Studio instance or is it disabled even there I don't unders ...Show All

• Visual Studio Can I change position of subtotal row(column) in the matrix?

  so, by default I have this : corner | dynamic group columns headers | subtotal column but in Exel document I want somthing like that: corner | subtotal column dynamic group columns headers it's possible You can not change the position based on the output format, but you can change it in general for the report: The subtotal element has a property which tells whether to put the subtotal column before or after the matrix column group. To set the subtotal properties, click the little green triangle at the upper right of the subtotal cell in the matrix. In the property browser, go to the "Layout" property category and set the "Position" property to "Before". -- Robert ...Show All

• Windows Forms Error 1324: The folder path 'n/a' contains an invalid character?!

  Hi all, I'm trying to build a setup application with Visual Studio 2005. Everything seems to work well, except when i run it, i got the error 1324: Error 1324: The folder path 'n/a' contains an invalid character. I really don't know what is wrong with it ! Any ideas ! Thanks ! Jonathan It seems that you try to create a folder, or access a folder called n/a , which is not possible since the slash (and the backslash) are invalid characters for folder-names and thus, they cannot be used to specify a folder - name. (Try to create a folder in Windows Explorer that's called n/a). Can't you debug it, and see where it's exactly going wrong ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. HLSL effect syntax highlighting

  Hi everbody :D, I just wanted to know if it is possible to have this feature inside c# express, that way no need to always launch another application (Renderisland || Fxcomposer). By the way thank's a lot MSFT for making such cool tools and frameworks. Currently, it is not possible to get syntax highlighting for HLSL in C# Express. This is a feature that we may introduce in the future. No promises, though. --Stephen ...Show All

• .NET Development Q: DIA SDK not finding SymTagUDT in .NET 2.0 programs

  Hello Everyone: I have been working with the DIA SDK 8/VS 2005/.NET 2.0 for a while now. My ATL/C++/DIA SDK project can interrogate non-.NET project .pdb files just fine, but whenever I try it on .NET 2.0 projects, it never finds any of the user defined types - the SymTagUDT typed in the .pdb. Initially the project started in VS 2003. When VS 2005/.NET 2.0 came out I upgraded. As part of my testing I have removed VS 2003, .NET 1.0 and 1.1, msdia20.dll and msdia71.dll, as well as removing all references to msdia20.dll and msdia71.dll from the registry. (msdia80.dll is installed and registered.) To the best of my knowledge the project settings for the .NET 2.0 programs I want to examine have the proper settings - optimization is ...Show All

• Visual C++ strtol strangeness?

  I'm probably missing something very simple, perhaps I'm tired. Why is it that the line of code "DWORD DWordValue = 0xF988FA1F; " places the proper hex value into the DWordValue variable (4186503711, 0xF988FA1F), but this line of code "DWordValue = strtol("0xF988FA1F", NULL, 16);" places the unanticipated value (2147483647, 0x7FFFFFFF) Don't Long and DWORD size to 4 bytes What am I doing wrong I am testing this because I need to read hex strings in from a file, and then write them as REG_DWORDs to registry sub-key named values. (Any easy ways to do that would also be useful). So here's an intersting problem that has caused me much heartache today. I have a C# web ...Show All

• SQL Server SQL 2000 Server Upgrade

  I have: Server x with windows 2000 server sp4 It was SQL 2000 STD, when it was originally installed. Now is SQL 2000 Personal edition SP4. We dont know how it became sql 2000 personal edition. We are assuming that an administrator had to re-install SQL and used the wrong CD. Anybody know of any problems I can find when trying to upgrade to SQL 2000 STD Should I un-install and then re-install Hi, take a look here: http://groups.google.de/group/microsoft.public.sqlserver.setup/browse_frm/thread/2bdff4310599abe5/aca749472f190d0f lnk=st&q=personal+standard+Jens&rnum=1&hl=de#aca749472f190d0f http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=349691&SiteID=1 HTH ...Show All

• Community Chat Convert Money value to its Textual Representation

  Code Competition I had answered a post Convert to letter format a number value and provided a response that went counter to the logic of the threads up to that point. The two code examples provided to the poster used enums. I posted with a title Enums make me E-Numb and provided a code sample that use no enumerations. One of the other poster's code sample was .Net but based on a previous process he had written in a non .Net language. He commented that he had run my sample and after 100K operations mine was four second faster. He requested that I add some features to the code and repost so he could retest. I accepted his request and that is what this is...a place to post the code away from the original post so it does not become an OTP fro ...Show All

• Windows Forms Datagrid editing!

  hi there! could some one help me wit the issue of doubleclicking on a datagrid and when you dobleclick it can send you to a another winform the idea is that I fill my datagrid form a table and i want to edit the info of the line that I selected, not in the datagrid i wan to edit it in another form, so when i doubleclick that line it can open the form where i gonna edit the info. thanx Well in the case that you want to use a different form, you would have to create your form, then databind the UI Controls to the dataSet (where you filled your data results from SQL) Now you would have to filter out (query) the data/record the user selected on so you can appropriately bind the data to the UI Controls on your "edit" ...Show All

• SQL Server Missing table in Datasource View dropdownlist of ProcessAdd config form of AS Process Task of SSIS

  I made 12 facttables and set them to the 12 partitions. the 12 facttables are the same, and I only build measures on facttable11. My first question is , will this be ok You know, when you build a measure group, it ask you to chose a facttable. I could not chose all the 12 facttables, right I only need to chose ANY one of the 12 tables,right If the answer is YES, could I chose diffrent tables for diffrent measure group and get the same result Nothing mentioned in MSDN. My second quesiton is, when I drop an AS Process TASK in SSIS, and chose to do a ProcessAdd on a partition, on the config form it ask me to chose a table or view that point to the partition i need to Process. On the Datasource View dropdownlist, If I chose the Datasou ...Show All