r2d1's Q&A profile

• SQL Server Only functions and extended stored procedures can be executed from within a function.

  Hi, l've created an function [GSM].[KPIAging], and test it in studio by substitule declare value, i.e. DECLARE @sCellName VARCHAR(8) DECLARE @dDate DATETIME SET @sCellName = "CELL1M_1" SET @dDate = CAST('06/Jun/2006' AS DATETIME) EXEC GSM.KPIAging @sCellName, 'CSSR', @dDate It work fine and return the desired result, but when l used this function in SQL, SELECT DATEKEY, CELLREGIONKEY, CELL_NAME, CELL_ID, CSSR, GSM.KPIAging(Cell_Name, ' ...Show All

• Visual Studio Express Editions attempting to create a COM object.

  I am trying to create a dll to be used for sourcesafe 2005 automation. From the help there appears to be to ways to create a com object. First open a COM template. This option is not one of the available templates when i choose to add new item, after opening the class library project. The other option is to choose the Register for COM Interop check box on the compile tab. I do not have this box either. When i go to the build i also do n ...Show All

• SQL Server Sql 2005 SP1 (x86) upgrade failed....

  Installed sql 2005 sp1 on standalone Win 2003 Server box in workgroup. (sql 2000 is default instance, sql 2005 is named instance and sql 2005 Express is floating around somewhere).). Box does not have any prior CTP SP1 versions. When I reach the "Authentication Mode" dialog during the SP1 install, and click Next, I get "Your account information could not be verified for one or more instances. Ensure that you ...Show All

• Visual Studio There was a failure uploading the URL.... VSS 2005 Beta 2 Web Service

  Hi there, I hope someone is able to help me with a problem to do with VSS2005 Beta 2 Web Service. I've spent nearly a day trying to get it to work, however I've not been able to. Here is a detailed summary of the issue. I am trying to get  Visual Source Safe 2005 Beta 2  to connect to Visual Source Safe 2005 Beta 2 via the Web Service. I had problems actually getting the database to register in Visual Studio until I found this posting ...Show All

• Visual C# tEMPLATE CALSS LIBRARIES IN c#

  Sir, I am facing an certain problem , i am trying to convert a piece of code in VisaualC# .hope some body will helpme out about this how can it be done. ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// class grip: public wait<grip> {   public:   int make[5];   int rate;   grip(int x, int y, int s, int d, int t, ...Show All

• Visual FoxPro i just wanna do it like this

  can i do that thank you everyone. To anyone that'd use MultiSelectGrid class. Please use original unmodified version. Period. ...Show All

• SQL Server Saving large text file in table

  Have created an SQL Server 2000 table which includes two columns each data type varchar(8000) in order to accomodate a semi-large amount of text (want to avoid using text data type). I enter the max in the first column but I keep getting an error of "Cannot create a row of size 12066 which is greater than the allowable maximum of 8060" when I try to save any more in the second column of the table. What am I doing wrong ...Show All

• SQL Server Encrypted DB -- Restore Question

  Hi, I have a DB in which I encrypt a few columns in a table.  I am using a Symmetric key to encrypt and decrypt the data.  When I take a back up of this DB and restore on another server ... my decryption doesn't work.  I have dropped the master key and recreated it with same password and that didn't help either. What are the rules to follow when we restore a db on a different server that has encrypted data   Thanks. ...Show All

• Software Development for Windows Vista .NET IMAPI2 Code samples

  Here you will find code samples for the April 18th MSDN Webcast on IMAPI v2 . The samples will be posted shortly after the webcast Here is a VBScript sample that shows how to erase a disc. REM - REM - Erases the current media in the recorder REM - FUNCTION fnEraseMedia( byRef recorder ) DIM eraser REM the second argument hooks up the events with prefix "fnErase_" SET eraser = WScript.CreateObject("IMAPI2.Msft ...Show All

• Visual FoxPro VFP and SourceSafe 2005?

  I haven't tried it yet but does VFP's VSS integration "talk" to VSS 2005 ok   (at least as well as 6.0d did ) Also, how well does the conversion from 6.0d to 2005 on the server side go Yes, it does. You can also use VFP with Team Foundation Server using the recently released MSCII provider. You can download the beta here: http://www.microsoft.com/downloads/details.aspx FamilyID=87e1ffbd-a484-4c3a-87 ...Show All

• Visual C# Where can I find free chart components for VS2005?

  you may try one of these: http://www.codeproject.com/cs/miscctrl/CS3DCharting.asp http://www.codeproject.com/csharp/zedgraph.asp http://www.codeproject.com/cs/miscctrl/ChartControl.asp ...Show All

• Visual Studio Team System TF30177: Team Project Creation Failed

  Hi all, I install Team Foundation Server Beta3 in Single-Server mode, and I didn't have errors on the installation, but when I try to create a new team project the follow error appears: ------------------------------------------------------------------------------------------------------ Error TF30170: The Plugin Microsoft.ProjectCreationWizard.Portal failed during task SharePointPortal from group Portal. Explanation Plugin err ...Show All

• Visual Studio How to deal with large matrix ?

  Hi, I'm currently using Report Viewer in Local mode within an ASP.Net 2.0 application. I need to build report with a varaible number of columns and rows and i'm using Matrix to tdo this. Unfortunately when may dataset contains more than 10000 records it takes minutes (4 to 6 minutes on a medium server) for the Viewer's DLL to build the report. I worked on several methods to address this issue: use table instead of matrix (but it's no ...Show All

• Visual C# Killing an Excel process in debug mode

  Hi all. I have an application I’m working on and it has the standard VS generated InitializeComponent() and Form1 load() methods. I have a main() which has a try-catch-finally block like so: try { Application.Run(new Form1()); } catch(Exception e) { MessageBox.Show(e.Message.ToString()); } finally { if(excelObject != null) { excelObject.Quit(); excelObject = null; } } I have ...Show All

• SQL Server ReportServer - http://localhost/ReportServer - Error

  An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object. And my ReportServer log: <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product> <Locale>en-US</Locale> <TimeZone>Pacific Standard Time</TimeZone> <Path>C:\ ...Show All