AlbertG's Q&A profile

• SQL Server SQLCMD outfile as tab delimited text file

  Hi, How can i create tab delimited text file output from SQLCMD Any help would be much appreciated. Thanks! Raju There isn't a great story around this... but I got it to work by doing the following: 1) Open Notepad 2) Paste this: sqlcmd -S (local) -E -s"<TAB>" -Q "select * from sys.dm_exec_query_stats" -o MyOutput.txt -h-1 -W 3) Highlight <TAB> , then hit the tab key 4) Save the file as MyBatch.bat 5) Run MyBatch.bat Let us know if this works or if you find a better way. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ ...Show All

• Visual Studio Tools for Office Newbie Question: Is VSTO what I need?

  Background ... I am working on an application for creating a sort of help guide. The user drags files (from explorer) into a hierarchy tree in order to add them to the help guide. The files can be of many types and they will be viewed in a WebBrowser control after being converted to web page (.mht). Most of the files will be Word Doc's, and I want to allow the user to create hyperlinks between these files after they've been added to the guide. I initially tried using the IHTMLDocument2 interface to create the hyperlinks but I ran into some problems. Then I thought that it would probably be better to show these documents using the embedded Word that the WebBrowser loads, and use Word tools to add my hyperlinks. Question ... I ...Show All

• Commerce Server Commerce Server 2007 catalogwebservice and bizTalk 2006

  Hello, I would like to update stock items in Commerce Server 2007 using BizTalk 2006. What I can see so far is that I should be using the Commerce Server Inventory BizTalk Adapter. I am not sure how you would use this Adpater to update the quantity and query the quantity of Products in the Commerce Server catalog Can anyone shed any light on this issue Thanks Dom Hey Dom, Yes - You can use the Inventory Adapter to update the inventory in your system. The inventory adapter works on an incoming xml file. It will use this file to import the inventory into the system. To have that file be an update, you would need to make sure that you have the import mode set to incremental (not replace). You also need ...Show All

• Visual Basic PrintForm bug with MDI code

  I have an mdi application into which I slotted PrintForm. This seemd to work well until suddenly I was getting only part of the form printed or previewed. Further testing revealed that this only happens when the mdi container is NOT maximised AND the PrinterOption is ClientAreaOnly or Scrollable (or CompatModeCAO). What appears to be printed is the portion of the form that falls into the rectangle that equates to the position of the form if the mdi container was maximised. It’s easy to replicate this. - Start a new windows application project in Visual Studio - Change Form1’s IsMdiContainer to True - Make the form quite a bit bigger than the default (so there’s no implication of scrolling proble ...Show All

• Visual C++ Problems in debugging

  I encountered the error message below: First-chance exception at 0x7c812a5b in mda2.exe: Microsoft C++ exception: std::bad_alloc at memory location 0x0012f764.. Unhandled exception at 0x7c812a5b in mda2.exe: Microsoft C++ exception: std::bad_alloc at memory location 0x0012f764.. Any possible answers Am I out of memory It occurred at this line m1pos [ i ] = new int [m1[0]+1]; //allocate new array where m1pos is an array of pointers. When my input file is small, there is no error. When my input file is large, I will have this error. If you were out of memory then you should get a null for return value. Right When debugging, can you determine what it is that is at memory location 0x0012 ...Show All

• .NET Development System.ComponentModel.Win32Exception:Incorrect Function error in Windows Service using a FileSytemWatcher

  Hello! I have a windows service which monitors a UNC share path for any incoming files and moves them to a new loaction on the same UNC path. The problem is that the windows service is not monitoring the folder( \\AA-11\Infofiles ) for changes but is able to write the changes to another folder on the machine( \\AA-11\Infonewfiles ) when I change the path to monitor as another UNC( \\BB-12\FolderfilesToMonitor ) or local folder(C:\Myfolder). I wrote an eventlog EventLog.WriteEntry("FSWError detected error: " & e.GetException.ToString) in the FSW_Error sub routine and when I checked the eventViewer it had the following entry. "FSWError detected error: System.ComponentModel.Win32Exception:Incorrect Function" I'm not su ...Show All

• Visual Studio Team System TF10216. I changed my DB from an old server to a new one and didnt work...

  When trying to see the report website: Error The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Obtener ayuda en pantalla Obtener ayuda en pantalla Inicio When we try to open any webservice: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. Did you follow the steps for moving to new hardware here you have the article on MSDN http://msdn2.microsoft.com/en-us/library/ms404869.aspx ...Show All

• SQL Server count of null values in columns

  Hi, I would like to ask how can I get count of null values in each column together I know I can use COUNT(*) - COUNT(<col>), but I need to explicitly name every column in the query.... is it possible without it This still requires you to know col01 and col02 names. imagine table A B x NULL NULL NULL x NULL What I'm looking for is something like SELECT COUNTSofNULLSinCOLUMNS(*) FROM MyTable which would return 1 3 You know I need to not specify any column names since I don't know them. ...Show All

• Visual Studio Team System how i can add licensed user to tfs workgroup

  hi i have installed tfs for workgroup , But when I start adding the licensed users I found that it’s accept only accept 5 users What should I do We are Microsoft partner and I have TFS beta 3 refresh CD Should i install the tfs beta 3 and upgrade it Or should we buy the more licenses If yes how and how match Thank you if i install the TFS beta 3 and then update it using TFSUpgradePackageRTM.exe from http://download.microsoft.com/download/7/B/B/7BB60747-28BE-43AE-B97A-CFDE02CC7788/TFSUpgradePackageRTM.EXE what i will get ,A full version and another information we are a golden partner thank you   ...Show All

• .NET Development Folder Integrity

  Hi All I want to performa Folder Integrity check on local machine. I have Several folders to guard on a local machine. I dont want anyone to temper the contents of this folder. I want my program to generate a Hash Code of the folder when copying the folder from the Sync Server. When my programs tries to access the Folder content , it should calculate the Hash again and check it against previous value. Computing Hash value for each file is not required, As a folder may have number of files ranging from 1-10. Any help in this regards will be highly beneficial. Thanks Sumit Hi Thanks for the reply. Yes you are right .. I am only going to give the path of the folder . I can ...Show All

• SQL Server Receiving Cross Join Result in Error

  Hello, I'm getting a cross join result from the following query; SELECT DISTINCT RTRIM ( DA . AcctCode ) AS DaAcctCode , cy . JanRev AS CYJanRev , PY . JanRev AS PYJanRev FROM SalesCommissions . dbo . DailyAccountsDownload DA INNER JOIN SalesReporting . dbo . PriorYearSales PY ON CAST ( RTRIM ( DA . AcctCode ) AS varchar ( 8 )) = RTRIM ( PY . AcctCode ) INNER JOIN SalesReporting . dbo . CurrentYearSales CY ON CAST ( RTRIM ( DA . AcctCode ) AS varchar ( 8 )) = RTRIM ( CY . AcctCode ) WHERE RTRIM ( da . acctcode ) = 'am940' ORDER BY cy . janRev , py . JanRev --************************************************ The result looks like this; DaAcctCode C ...Show All

• SQL Server Association Scenario

  Hi, I have a product basket scenario in where I have to recommend contracts to a customer based on the product and the quantity he/she buys. Product Quantity is an important factor which administers the user in the purchase of a particular contract I have the following tables with me. Customer product transaction table, Customer Contract transaction table but there is no direct relationship between contract and product in the database. The only way the two can be linked is through the customer. If I create a mining structure with Customer-Product information as the nested table and Customer-Contract information as the nested table with customer being the link between the two, the model is showing some irreverent contrac ...Show All

• .NET Development Unmanaged to managed callback through wrapper: this works but is it good?

    I implemented callback in mixed mode the following way and it works fine but I wonder if this is the right way to do it. In particular, is this 100% safe I mean could there be some obscure GC/CLR "event" that would make it crash at some point, for instance should not I be using pin pointers It works this way: a delegate is declared in C# and used as argument to the setCallBack() function of a C++ .net wrapper. This function casts this pointer and use it to initialize the callBack pointer value in an unmanaged C++ class (it also keeps its value so the Wrapper can also call the callback). The C++ .net wrapper is shown below: public ref class WrapperClass { public : delegate int CallbackType(); ...Show All

• Visual Studio 2008 (Pre-release) DLINQ question

  I just finished watching the "The LINQ Framework What's New in the May CTP" presented by Luca Bolognese. The video discusses DLINQ. question #1 I am a student and just starting to learn stored procedure of SQL. Correct me if i am wrong but my interpratation to the demo is that this DLINQ prevents you from creating sql stored procedure and your database query will mix up on your c# code or the business logic of the program. is that manner ideal would it be better if the sql code or the dlinq code is in a separated file and not mixed up with the business logic code quetion #2 would this DLINQ work with other database like MySQL, Oracle, etc this is my first time i have seen a video of LINQ. please correct me if i am wrong with my interpre ...Show All

• Visual Basic Menustrip shows up as gray rectangle on some computers

  I have created a small application that uses a MenuStrip in VB.net 2005. This menu attaches itself to a specific application running on the users computer and gives printing options. On one computer, this menu shows up as just a gray rectangle, there is no text and the menu does not drop down. This is a Win 2000 machine. Other Win 2K machines are OK. Anyone have any ideas Thanks. We got it! - the user had their display properties set to 'Red White and Blue <VGA>'. We reset them to 'Windows Standard' and if fixed it. ...Show All