Dark Pontiac's Q&A profile

• SQL Server Cannot Reference and SUM fields from Table Group in Footer Expression!

  I'm gonna try this again, Microsoft, Please help! There has to be a solution for this!!!!  How can I get around the limitation in SSRS 2005 of being able to SUM on a Table's Group field from my group footer expression! Keep in mind, I'm talking about a table here, not the global Report Footer, a Table object's footer! It's driving me nuts My table footer GrossGoal_gt   's field expression (non of these work and throw the error below): =SUM(Fields!GrossGoal1.Value, "CustomerNumber_Grp" ) neither does this: =RunningValue(ReportItems!ProjFee_AZ.Value, Sum , "CustomerNumber_Grp" ) neither does this: =SUM(ReportItems!GrossGoal1.Value, "CustomerNumber_Grp" ...Show All

• SQL Server Dropping an auto numbered primary key and add a new one

  The table I am using have a column called Key which is the primary key of the table and a auto number. This primary key is not a foreign key in any other table. I need to write SQL to drop the current primary key and add a new one Say "RecordId" as the new primary key and which should be a autonumber too. any idea. thanks in advance What's the point It is easy enough, just drop the column and add another one, but there might be an easier way to do what you are wanting to do. Here is a script that does it: set nocount on drop table test go create table test ( testId int identity constraint PKtest primary key, value datetime default (getdate()) ) insert into test default val ...Show All

• Visual Studio Team System CTP import SQL 2005 schema errors

  First, great job getting CTP5 out early ! Second, as promised, I'm reporting back the errors I received (if any) when importing my four new SQL 2005 databases into CTP5 (see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=638221&SiteID=1 for original post). Total of 37 errors (much better than the 230 :): 2 errors on first database: 2 - Incorrect syntax near CONNECT. (this is on a user script for both users in the db, the script contains a create user followed by a grant connect to) 1 error on second database: 1 - Incorrect syntax near CONNECT. (this is on a user script for the only user in the db for the only user in the db, the script contains a create user followed by a grant connect to) 6 errors on third data ...Show All

• SQL Server Deleting Older rows in the table

  Hi, I have a table which has around 50,000 rows. Can I delete the rows older than one year If no, Can I delete the last 25,000 rows (older rows) from the table Can you assist me with the SQL Statement to do this Thanks Santhosh You're correct Jens, it was intended only as a trick, a workaroud to use before start operating with a solid solution. Clearly, as many tricks, it maybe not usable in that case. ...Show All

• Visual Studio Tools for Office Get The text of Words from a word document

  This may be a topic for some other group, but this group gets replies faster then then Automation or some other Word groups, so maybe someone here knows this. I really want to thank Cindy for pointing me in the right direction for what I wanted to do. I ended up using the DsoFramer control to host my word doc, and now I have the document loaded, when I first saw the Word.Document.Words collection, I thought cool a collection of string variables for words. Microsoft would never make it so easy. Does anyone know how I access the words in the document, and highlight a word that matches my search criteria (similiar to the way Google highlights your results). I am heading to the book store to buy an Office book next, but if someone has ...Show All

• .NET Development Simple encryption

  I really hate to bring this up. I have been searching the forums, websites, all kinds of cross referenced blogs... only to be totally confused. :( I have a simple application, it is not rocket science, it doesn't deal with bank data or anything that could be considered critical. There is no real need for public keys and private keys or using anything that will take people months to break. I am using the interal "my.settings" for storing a user name, password, a few dates and colors. I want to be able to put the settings xml file into a folder based on the user name they login to the program with, which is a totally different topic. (Why MS put all of this work into making such a useful feature and then not allowing it to be ...Show All

• SQL Server transaction log size growing very large

  hi all, my tlogs at the subscriber are growing very large irregardless of my recovery mode. any help using snapshot-push replication thanks, joey If you want data to be bulk-loaded in small batches while the snapshot is being applied to the subscriber, you can: 1) Specify the unofficial /DisableResumableSnapshot parameter on the distribution agent command line, this will prevent each bcp file from being applied in an atomic transaction 2) Specify a smaller batch size via the /BcpBatchSize parameter Alternately, you can try to get the benefit of minimal logging by taking advantage of partition switching support as follows: 1) Deliver snapshot to an empty staging table 2) Switch the staging tabl ...Show All

• Visual C# closing an application from a command line

  Hi guys, I was wondering if there is a way to close a csharp application from outside the application so that it will still raise the form.onclosing() events. Basically, I don't want any signs of this application to appear on my desktop, so I cannot close the program from the taskbar. I also cannot close the program from the windows task manager, because this will not raise the form.onclosing() events. I'm wondering if there might be a way to do it otherwise, like from the command prompt or run bar. If anyone has any good solutions or alternate suggestions, it would be greatly appreciated. Thanks. geraud c wrote: Well, I know the answer isn't no, because I've been thinking about it and you could do this by having the applicati ...Show All

• Community Chat Ram update for a pc with an oem version of windows

  I have a Genuine OEM version of windows XP Profesional installed on my PC and I am thinking about installing more ram and mabey a new graphics card. Will this render my copy of windows as a non genuine copy or will it still be a valid copy Hi, Please post your question in the following forum: http://www.microsoft.com/windowsxp/expertzone/newsgroups/reader.mspx dg=microsoft.public.windowsxp.general Thank you, Bhanu. ...Show All

• Smart Device Development DataGrid issues

  Hi, I've installed the CF2.0 SP1 patch so that my DataGrid could be align to the right (I'm writing a RTL program.. hebrew) But I didn't understand how to get the headers to be align to the right aswell, another question regarding the binding of the SQL MOBILE and the DataSet, I have a table, and i want the user to see only 3 columns in the datagrid, but the problem is that one of the columns vary in the DB, I need to display in the datagrid somesort of the "final" column, which i need to manipulate data into (For example: I have a weight and quantity fields, and the user can choose which one to enter, the other can stay as NULL, and when he sees it in the datagrid, he needs to see only the number he enter ...Show All

• Visual Studio Express Editions How to delete this registry key

  reg add HKLM\Software\Microsoft\Windows\CurrentVersion\Run /v hellobob /t Reg_sz /d C:\bobby.exe /f > nul Dim Path As String = "Software\Microsoft\Windows\CurrentVersion\Run" Dim rKey As Microsoft . Win32 . RegistryKey = My . Computer . Registry . LocalMachine . OpenSubKey ( Path , Microsoft . Win32 . RegistryKeyPermissionCheck . ReadWriteSubTree , RegistryRights . FullControl ) rKey . DeleteValue ( "HelloBob" ) ...Show All

• Visual Studio 2008 (Pre-release) Image formats for toolbars?

  I'm curious what people are using for images on WPF toolbars Are you using icons, bitmaps, a geometry in XAML, or It's nice that you can easily make an interface scalable with WPF, but that implies that some sort of vector images would be best. But how do you make those look good when sized down to small areas like 16x16 I'd like to hear from some developers/designers that have been working with this awhile on what's worked best for them What gives you the best tradeoffs between ease of creation, good looks at larger sizes, and good looks at smaller sizes Not sure if others are doing the same, but I'm finding myself using png for icons, etc, anything other than basic shapes. You can make the original pngs larger than you need (as ...Show All

• Customer Care Framework CCF samples

  Hi Chad Ra thank you for your help keep in touch with us by this forum i'm very happ to found someone reply to me about CCF after installing CCF i want to begin to use it I I can't run the samples because some missing DLLs where will I begin ...Show All

• Visual C# Setup Creation Problem 'donetfx publisher not verified'

  I want to create a setup, and include dotnetfx as part of my application and when any system need dotnexfx then it is installed otherwise just my application be installed, for that i practised alot but faced a problem which is when i am creating setup or publising my application and Including prerequests (windows Installer and dotnetfx) during installation of dotnetfx i am encountring an error which is "the publisher of dotnetfx is not verified ", what i to do that setup dont give these type of errors and my setup do not download prerequest from vendor website thanks The linkes to which you refered me i practised but it is same as i was doing before, kinldy create setup on your own system and then install on othe ...Show All

• SQL Server Create Multiple Store Procedures in 1 SQL statement

  Hi guys , may I know is that possible to create multiple store procedures in 1 time using 1 SQL statement Thx for the assistance. Best Regards, Hans The 'GO' isn't part of a T-SQL statement, it's just a marker that identifies where the end of batch is. So, the above is, if you save it all as one file, and run it all at the same time, still two batches ( or statements if you will ), but it looks like it's working for you wanted anyway =:o) /Kenneth ...Show All