Ray C's Q&A profile

• SQL Server Question on Internal Activation Stored Procedure Security Context

  CLR function has the following few lines which is invoked from Internal Activation Stored Procedure: SqlCommand command = Connection.CreateCommand(); command.CommandText = " CREATE ASSEMBLY " + "\"" + AsmName + "\"" + " AUTHORIZATION [dbo]" + " FROM " + "'" + regasm.UncPath + "'" + " WITH PERMISSION_SET=SAFE"; command.ExecuteNonQuery(); I am getting the following error: "Could not impersonate the client during assembly file operation." The CLR function is invoked from Service Broker internal activation stored procedure. "SELECT user_name()" returns dbo just before CREATE ASSEMBLY executi ...Show All

• SQL Server Could not create Maintenance Plan

  Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/ LinkID=57083 . (ObjectExplorer) For help, click: http://go.microsoft.com/fwlink/ LinkID=57083 On my loca ...Show All

• Visual C++ Linker Error with STL on Release Mode

  Hi, I'm using Visual Studio 2003. Each time I use some STL library like string, fstream... I get many linking errors but only when compiling in Release mode. I get LNK2001 and LNK2019... I've been looking in the forum for some answers but I don't get it right. PLEASE, HELP Pintu, he says the link errors occur only in Release, so it can't be a spelling issue. To solve this problem, it would be best to turn off the /nologo (supress banner) flag on both the compiler and linker and give us the output so we can see what flags are being used.  Typically, the compiler flags /MDd and /MD are used to specify the CRT/C++ Lib dependency for debug and release, respectively.  /MTd and /M ...Show All

• .NET Development custom plugin questions!

  Hi there. I have no idea but had a sudden urge to ask about things like this, I guess its good for the knowledge! I have an app created in .NET 1.1 I *may* wish to implement plugin's with the application, so developers can create their own plugin's for the application. Question 1) If a plugin was created in .NET 2.0, will it still work with the .NET 1.1 application (obviously assuming they have both frameworks installed) Question 2) How would one go about creating plugin's for their application Question 3) Is it possible for this plugin to implement/"subscribe" to public events exposed by my application, so when I raise an event, any of the plugin's who have a subscription to the event, is notified Th ...Show All

• Microsoft ISV Community Center Forums question about word automation(how to insert header)

  hello i am trying to develope an application for word automation.the application should generate a word document and need to insert a header into document.i have find the code from msdn and it works well.but i can't insert header.(i have found the code for inserting header from msdn too) but it doesn't wrok this is the code i user for header: foreach (Word.Section section in oDoc.Sections) { object fieldEmpty = Word.WdFieldType.wdFieldEmpty; object autoText = "HELLO THIS IS HEADER"; object preserveFormatting = true ; //section.Headers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range.Text section.Headers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range.Fields.Add( ...Show All

• Windows Forms C# - ListView

  Hi... In my ListView code i have 10 rows & 10 columns. I want to search 1 word say "Search" in a perticular column(& all rows) & then if i have that word in that column then only i have to select that perticu;lar row or else i have to delete that row from completely ListView . (e.g. I am searching for word "search" in column 5 & i found that word in row no. 1 , 3 , 5 , 7 then on my form i have to display only 1 , 3 , 5 , 7 rows of that ListView) How i can do this in C#... Thanks , Vinay Thanks for immediate reply... But i modified the code slightly but still i am getting following errors on red line shown below... The best overloaded method m ...Show All

• .NET Development can we generate sql server table from dataset

  The purpose is to avoid typing all the field again in sql server when we have them in a dataset. 2/ can we do the same thing fro an xsd file Thanks. Hello, i am playing with the idea to use the XSD that contains the datadefinition as a source for an XML transformation that generates the required CREATE queries. These could then be added to a VS Database Project and be used to construct the database. I haven't figured it out completely, but guess that such a setup would in fact keep code and database structure in sync. I think this is one thing that is absolutely required for all projects of an respectable size. Just my two pennies... Peter Vrenken ...Show All

• Visual Studio Tools for Office Iam merging lot of word documents into one single document and atlast doing a pdf

  Hi, My problem while doing this is, first i will tell what i use, i use range.insertfile command to insert all the file into my template document while doing so the documents that i am inserting are lacking their orginal alignment ,some justified ,are changed to left aligned like that what should i do to keep the target file contents alignments same as the source files Thanks. One more doubt for me. I did one test, i took the template in which i am inserting all my documents outside my application and using the insert menu of that and inserted the files into it manually,the files are properly aligned in the template(original alignment as in the file) ,but when i am doing the same with range.insertfile in c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you draw text?

  Since the XNA documentation is lousy, I'm gonna ask here. How do you create text in XNA I want to use it for debugging purposes :( Thanks a lot, fellas. I already uses BitmapFont the first time one of you fellas posted a link. It works great. I use Comic :) ...Show All

• Visual Studio Team System Schema Compare issue

  Have an issue with schema compare. When I do a compare I have objects the tool is saying does not exits in the target but it is exactly that same based on Ultra Edit compare. I let DBPRO update the target and then do a refresh I get the same object back as not in the target schema. Comparing a database as the source and the database project as the target. Has anyone run into this issue Let me make sure I understand what is going on. First you import a database into a dbpro project. Then you compare the project with the database you just imported and the project is the target of the comparison. After the compare, it shows that table are procs are missing in the target, i.e. you ...Show All

• Windows Search Technologies How to make search companion default while using wds 3

  Hi, I installed WDS 3 and to my surprise I found the option to make search companion the default search in explorer missing and wds pops up whenever I select the search from windows. In my opinion, both have its own place as WDS still lags behind in many aspects and with limited choices. Yes, there is a choice to use search companion, but I dont want WDS to pop up when I hit search. I've uninstalled wds 3 and went back to 2.6.5. If somebody has any idea, pls let me know or else please take this as a request to re-introduce the option back. Thanks Does this help http://www.hanselman.com/blog/HowToDisableWindowsDesktopSearchExplorerIntegrationAfterInstallingOffice2007.aspx ...Show All

• Visual Studio Express Editions How to get the filename into the "Insert Pictures" dialogue??

  Our company written a marco that as same as the "insert -> picture -> from file" dialogue, but we want to enhance it to get the filename automatically when the dialogue box is opened. These forums are for VB.NET questions. VBA (Visual Basic for Applications) then this is a very different product from VB.NET and there are some other locations where you will get a quicker and better response to your VBA questions. You may find more assistance in following which specifically deals with MS Office development. Office Automation: office.developer.automation newsgroup http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US Or the Offic ...Show All

• .NET Development How to get all the cookies

  Hello, I have a problem with getting all the cookies. I use HttpWebRequest and Ethereal shows the following HTTP/1.1 302 Found : Hy There, Well if the path of the URL changes you also have to change the path of the cookies. For example if you logged using this url: www.site.com/login.php and you want then to access another location with different path www.site.com/subdirectory/file.php then you have to modify the cookies got from the first request: wresponse = (HttpWebResponse)wr.GetResponse(); if (wresponse.Cookies != null && wresponse.Cookies.Count > 0) { foreach (Cookie c in wresponse.Cookies) { c.Path = "/subdirect ...Show All

• SQL Server Problem with matrix headers

  hello, I'm having a strange problem with a matrix headers. I can't put column headers above each row group header. There is a merged cell above them, which can't be split. If I have several row groups, including Customer ID and Zipcode, I can't put headers above them to identify them in the matrix. Since both have 5 numerals, they can be confused. Does any body know how to solve this Thanks in advance, Juan David Juan, Instead of this way: Customer Id 112233 22222 333333 33333 Zip Code Id 55443 55443 66776 22334 Can you just add a column to the left of your rows groups and place your headers there CustomerID 112233 22222 333333 333333 Zip Code 55443 55443 66776 22334 Ham ...Show All

• SQL Server delete statements deletes more rows than select using the exact same criteria

  I have a situation where a select statement returns about 30 rows of data but a delete statement using the exact same criteria deletes 190 rows from the same table. Here is my select: SELECT * FROM PS_COST C WHERE C.ASSET_ID = '000000000315' AND C.BUSINESS_UNIT = '00010' AND EXISTS (SELECT * FROM PS_OPEN_TRANS OT WHERE OT.CALC_DEPR_STATUS = 'P' AND OT.DTTM_STAMP = C.DTTM_STAMP AND OT.TRANS_TYPE = C.TRANS_TYPE AND OT.ASSET_ID = C.ASSET_ID AND OT.BUSINESS_UNIT = C.BUSINESS_UNIT AND OT.BOOK = C.BOOK) Here is my delete: DELETE PS_COST WHERE ASSET_ID = '000000000315' AND BUSINESS_UNIT = '00010' AND EXISTS (SELECT * FROM PS_OPEN_TRANS OT WHERE OT.CALC_DEPR_STAT ...Show All