Poolius's Q&A profile

• SQL Server Stored procedure parameter position

  Is there a way to determine the positional index of a stored procedure's parameters from within the stored proc The reasoning is this: I use raiserror state to return the index of any parameter values that are invalid or are otherwise not acceptable; like... if( @RequiredParam is null ) raiserror( 'blah blah blah', 16, 4 ); Currently I'm harcoding the parameter position which is a bit of a pain to maintain. I thought there may be a way of retrieving it so that it is robust against parameter changes; kind of... if( @RequiredParam is null ) raiserror( 'blah', 16, ufn_getpos( 'RequiredParm' ) + 1 ); Is sys.all_parameters and sys.procedures the way to go on this Hi, no this is true. YOu should always stick to the ca ...Show All

• Visual C# Learning C#

  Hi, I would like to ask anyone here for their advice on where I should start with C#. I have been programming for nearly a year now and dont know any other languages other than the VB family, such as vba, vb6 and vb.net. Since i have been programming with .net I have learned alot from the msdn library that comes with the installation of Visual Studio, and whenever looking at the example of code I still am always drawn to read the C# code. Something is just making me want to learn this language, However a good friend of mine is trying to alter my path by suggesting I learn C++. Learning C++ I would like to do, and also think I would benefit with the fact my friend knows the language. But may it not be a good path to learn C# then g ...Show All

• SQL Server Web Sync Wizard On XP Box

  I have (finally) successfully gotten through the maze and 'published' my database to a folder: Physical path: I:\SqlReplication unc: Warrenassoc\SQLReplication Since I'm running XP pro, I don't have the options of assigning specific read/write permissions to a folder. However it appears the problem is with accessing the snapshot and the logon's there. When I run the IIS Web Configure wizard I error out at the snapshot share permissions step (see report below) Wizard Settings: Click Finish to perform the following actions: Modify a virtual directory immediately. Copy the ISAPI dll 'sqlcesa30.dll" to 'I:\SqlReplication" immediately. Set NTFS permissions immediately. The virtual directo ...Show All

• .NET Development How to display table with attribute values

  Hi All, I am trying to display a table report using XML and XSLT, but could not get it to work. Here are my files: XML File: < xml-stylesheet type="text/xslt" href="..\testlog.xslt" > <LogMessages> <LogMessage EntryNo="000000000001" EventNo="30000" User="System" Interface="" ProcessId="608" BytesTransferred="0" BytesReadWrite="0" Time="20061026202051825"> <![CDATA[ Program starts.... ]]> </LogMessage> <LogMessage EntryNo="000000000003" EventNo="30001" User="System" Interface="" ProcessId="608" BytesTransferred="0" BytesReadWrite ...Show All

• SQL Server Can't drop SQL Mobile subscription at Publisher

  I have a program running on Pocket PCs that synchronizes with a desktop SQL database using SQL Mobile. My problem is that I can't delete old subscriptions from the publication; now the publication has 25 subscriptions and won't accept any more (limit of SQL Workgroup edition). I can delete non-SQL Mobile subcriptions just fine. Running sp_replmonitorhelpsubscription provides this information: subscriber: LVCONTACTSMERGE - 5FA305234F0C subscriber_db: Program Files\PocketLVContacts\LVContacts.sdf publisher_db: LVContacts publication: LVContactsMerge So I set up this bit of code: USE LVContacts EXEC sp_dropmergesubscription @publication = 'LVContactsMerge' , @subscriber = 'LVCONTACTSMERGE - 5FA305234F0C' , ...Show All

• SQL Server SQLCLR-Patterns&Practices/"Object Builder" error: "operation that was forbidden by the CLR host"

  Hi, Using the Microsoft Patterns and Practices "Object Builder" (Dependency Injection/Builder library), I wrote an SQL CLR Stored Procedure (using VS 2005 Professional). All compiles and deploys ok (to SQL Server 2005 Express). However, at run-time, I get the following error upon a "BuilderContext" object's instantiation: {"Attempted to perform an operation that was forbidden by the CLR host."} Thoughts on how to get ObjectBuilder working in the SQLCLR Thanks! Andy (posted below is the sample code...with the run-time exception occuring on the ...BuilderContext cxt = new ... call) Microsoft.Practices.ObjectBuilder.BuilderStrategyChain chain = new Microsoft.Practices.ObjectBuilde ...Show All

• SQL Server "Pro SQLCLR 2005 CLR Stored Procedures, Functions, and Triggers" TOC

  For those intersted here is our TOC and the book's link. You can preorder at this point. We are sticking to the Nov. timeframe, but we may get it done sooner. Chapter 1   Introducing SQLCLR Chapter 2   Building a Procedure Chapter 3   SQLCLR Strucutre & Common Tasks Chapter 4   Creating Objects Chapter 5   Compare & Contrast Chapter 6   Replacing TSQL Objects Chapter 7   Using the Base Library Chapter 8   Using Procedures in Apps Chapter 9   Error Handling Chapter 10 Administration Chapter 11 Case Study Here is the link: http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470054034.html Enjoy, Derek ...Show All

• SharePoint Products and Technologies Why take long time to open WSS site?

  Hi, When first time to open WSS site, it always takes long time to open, Why Any way could improve this issue and how Thanks for any advice! Angi It's because IIS has to compile the code and pages to display. After that it gets cached, that's why subsequent requests don't take as long. You can try a server "warm up" script: http://blogs.msdn.com/joelo/archive/2006/08/13/697044.aspx ...Show All

• Gadgets Control toolkit in a gadget

  It's all here : http://blog.khamlon.info/ p=26 thanks to share your feedbacks ...Show All

• SQL Server An error has occurred during report processing.

  While creating a new report in the report designer I can pull all the information from my cube, however later after it is created i get this message: An error has occurred during report processing. Query execution failed for data set 'MedContv15S'. Unable to recognize the requested property ID 'ReturnCellProperties'. anybody a clue I meanwhile tried to set "ConnectTo" to 8.0, however after that i get this error:   An error occured during local report processing An error has occured during report processing Cannot create a connection to data source 'MeD'. The LCID or Compare String flags have already been set by an existing connection. They cannot be changed ...Show All

• Windows Forms Returning data from Control to Owner form? (C++)

  Hi,   I am coding in C++, using VC++ Express Edition. I have a form(Form1) which is a MDIParent form. I am creating a second form, and launching it as a dialog with the following code: private : System::Void Form1_Shown(System::Object^ sender, System::EventArgs^ e) { NewQuest ^ dlgNewQuest = gcnew NewQuest(); dlgNewQuest->ShowDialog( this ); }   NewQuest is the Name of the Form for this Dialog. It has a few controls on it. I want to return the value of a textbox control located on NewQuest to its Owner form, Form1, and then set the text of Node0 of treeView1, which is contained within panel1 on Form1, to the value of this textbox control located on the NewQuest form.   I have se ...Show All

• SQL Server format issue

  I've created a new calculate member in (SQL Server Business Intelligence Studio 2005) with the following format string: "#,#0.00". This measure is displayed like this: 22,250.22 Then I created a Measure in the Cube structure menue and used the same format string:"#,#0.00" and this measure is displayed like this:0,66 --> Comma and decimal point are changed in the display of the measures!!!! Can anyone help me with this I just like every measure to use a decimal point for the decimal place or the other way round. But I want every measure to be displayed in the same format! Thanks a lot! Hello, I had this problem because the collation of my AS2005 server was diferent from the collation of my cube. Can you ...Show All

• Visual Studio Tools for Office Can't install VSTO 2005 SE on Office 2007

  What this doesn't address is that one can't install the VSTO SE package without already having the first version installed. This requires an Office 2003 SP1 product. The only Office 2003 item we used was Outlook, but since that was part of our Exchange 2003 license (even though it included all the secondary office appliations - ie - scanning, etc.), it won't allow us to install the original VSTO 2005 product. We purchased the Office 2007 upgrade so we are currently running the full 2007 Small Business license. So we now have a situation where we just bought the development environment for which we intended to run only the VSTO SE upgrade, since we have no need for 2003 support, only 2007. Sounds like it should work, but the point is we can ...Show All

• Smart Device Development using font strips on windows mobile devices

  hi,   we need custom fonts for our application. one way is using font scripts i.e. use bitmap iamges to display text e.g. when we want to display 'A' use corresponding image for 'A'. Question 1. :- How to do this for controls that accepets input from the user e.g. text control also for controlls like soft keys, window titles and menus. Question 2:- what are possible concerns or disadvantages of doing this as this is not a standard way Question 3:- Is this cause any problems in logo certification Note : our target devices are all possible smartphones and pocket pcs (2003 as well as 5.0) regards Rashmi Todkar   yes but this was just for knowing that is it posible fontstrips ...Show All

• .NET Development Issue with DateTime class

  I've got a program which uses DateTime to get the year, date (ie, 12 or 13) and the month to put into a string. This is the code: DateTime now = new DateTime(); now = DateTime.UtcNow; string year = now.Year.ToString(); string month = now.ToLongDateString(); month = month.Substring(3); month = month.Substring(0, month.Length - 5); string day = now.Day.ToString(); string datetoday = year + " " + month + " " + day; Although it works well on my system (and on those of many others), some users of the program have reported that the string "datetoday" appears as " 2006 rsday, 28 December 28". These users have been running .NET 3.0 an ...Show All