Anand Raman - MSFT's Q&A profile

• SQL Server Issues with privileges

  I am having trouble with providing the minimum security to a user. After issuing the following: GRANT EXECUTE ON SCHEMA :: DBO TO skillsnetuser ; I test the permissions with exec as login = 'skillsnetuser' exec prcElmtList 1 , 1 , 102268 revert ; and receive this message Msg 229, Level 14, State 5, Line 2 SELECT permission denied on object 'Org', database 'SNAccess_Dev', schema 'dbo'. The principal that owns the dbo schema is dbo and is the principle for all procedures and tables in that schema. What can I do to shed some light on what is causing this access problem SELECT name , principal_id , schema_id FROM sys.objects WHERE ...Show All

• Visual Studio Express Editions Adding to listveiw on another form?

  I am making an application which has a parent and several children. I have benn using VB6 for years but the higher object coding is getting the best of me. I have a listbox on "form1" form and would like to add to it from another form "form2". I want to add to it when some serial data comes in. I have made a public property on the "form1" to add the value tothe listbox but it does not work. Any help would be awsome.. Here is the property that i call from "form2" to add to the listbox. Public Property Listbx1Add() Get End Get Set ( ByVal value) ListBox1.Items.Add(value ) End Set End Property You are right it will not w ...Show All

• SQL Server choosing a collation in SQL 2005

  I have been searching for advice on the 'right' collation to choose in SQL 2005. I am US based and can assume any language required not supported by Latin1_General will be in unicode. I have SQL 2000 servers using SQL_Latin1_General_CP1_CI_AS and SQL_Latin1_General_CP850_CI_AS. The ones using CP850 will be converted to whatever collation is chosen in SQL 2005. I do not know the implications of choosing the default SQL collation as opposed to choosing Latin1_General_CI_AS. I have seen warning messages when installing analysis services if the SQL_Latin1_General_CP1_CI_AS is chosen saying that analysis services will use the colaltion Latin1_General_... . I also use non-updating subscribers in transactional replication currently in teh SQL 2 ...Show All

• Visual C++ How do I pass cin values into a constructor function

  I'm right at the beginning of my C++ journey, and I'm having trouble modifying code to do what I want! readers of SAMS will be familiar with the code example, if not the problem! I have a Class (Cat) that can be used to create Cat Objects (Frisky, Shandy, etc.) from header file cat.hpp:- //this is cat.hpp #include <iostream> class Cat { public : Cat ( int initialAge); // Constructor - initialises the class with the variable initialAge ~Cat(); // destructor - does nothing int GetAge() const { return itsAge;} // inline! void SetAge ( int age) { itsAge = age;} // inline! void Meow() { std::cout << "Meow.\n" ;} // inline! private : int itsAge; }; ...Show All

• Visual Studio Express Editions Running Programs in Vista

  Im about to install Windows Vista on my PC . I want to know if my code will still work, especially code that gets information from the registry and the system. Wish me luck... It took 3 hours but Vista installed ithout a hitch, so far so good. When i run VB2005 i get an error saying: The proper type library could not be found in the system registry. An attempt to repair this failed because you do not have the permissions to write to th system registry or because the type library could not b loaded. This can be fixed by a system administrator running this program once which will cause the proper file to be registered.... VB2005 still runs properly and my programs as well. The only problem so far is the a ...Show All

• Visual Basic event launches a form but the form doesnt open completely

  I am trying to send data to a new form and the open the form. I have tried visible = true and the show() method but both seem to have trouble opening the form completely. The form semi appears but never finishes. i am very new to programming but i can make it open a msgbox no problem and clicking on a button also works.. PLEASE take a look Public Class PopUpStart Inherits System.Windows.Forms.Form Public WithEvents MyOB As EccoDotNet.OrderBook Public Mybuysell As String Public MyContract As String Public MyFQty As Integer Public MyOQty As Integer Public MyPrice As Integer Private Sub bPopUpStart_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bPopUpStart.Click MyOB = New EccoDotNet.OrderBook ...Show All

• Windows Forms Specifying the format for a column bound to an expression column

  I have a DataGridView displaying values which the user can format in Millions, Thousands, etc. I am setting the format like this: myDataGridView.Columns[4].DefaultCellStyle.Format = "#0,,.00" ; This works fine for all of my columns that are bound to a DataTable, except for ones where the DataColumn has an Expression specified (e.g. someCol.Expression = "Col1 - Col2";) In this case, no formatting is done on the value. Has anyone else encountered this Or is the DefaultCellStyle not where this should be done in the first place Thanks in advance. The format will only work with number data types. If you do not specify a data type for the new datacolumn c# will assume it is ...Show All

• SQL Server Another Mysterious issue in SQL 2005 & SSIS

  Explain this: Package runs successfully from BIDS It runs successfully in SSIS store It runs successfully when I manually execute the Job JOB FAILS EVERY FREAKING NIGHT TheViewMaster wrote: Jamie Thomson wrote: Scheduled Packages http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html Start by changing to the Operating system ( CmdExec ) sub-system. You should then get the full message output. How exactly are you suppose to change the Job subsystems When you setup the job step, select "Operating System (Cmdexec)" from the 'Type' dropdown box. -Jamie ...Show All

• SQL Server Passing multiple-values as a parameter

  I am trying to drill through to a secondary report passing multiple values as a parameter. For eg. I would like the user to select multiple years (2005,2006) from the drop-down parameter and pass that on to a secondary report. When I select multiple values and pass that as a parameter, the parameter in the second report defaults to 'All' or in some case the first of the multiple parameters (i.e only 2005 is passed). I don't have any problems passing single valued parameters. Any help would be appreciated. FYI - I am using an Analysis Cube as the data source for the report. Thanks Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=164056&SiteID=1 -- ...Show All

• Software Development for Windows Vista Adding largeicon to imagelist gives an error

  Hi, I have two imagelist with size 16 * 16 and 32 * 32 respectively. I add an icon to these two image list and it works fine on XP. Under Vista 120 DPI setting, It gives an error when i try to add the icon to the second imagelist. In the normal DPI setting it works fine. The error is, WFCException : cannot add an image smaller than the imagesize property. The code is in vj++. sample code is: smallImageList = new ImageList (new Point (16, 16)); largeImageList = new ImageList (new SIZE (32,32)); Icon icon = (Icon)LImage.getImage.... smallImageList.addImage (icon); largeImageList.addImage (icon); //error occurs on this statement. I appreciate your help on this. Thanks, vaishalli That exceptio ...Show All

• SQL Server unable to start Analysis services - sql server 2005

  Hi, I am unable to start Analysis services on my machine. Below is the message i am getting when i am starting from services.msc. Can some one answer how I can avoid this error. What i am missing please explain. -------------------------- Services --------------------------- The SQL Server Analysis Services (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service. --------------------------- OK --------------------------- Thanks in Advance. Chandra There are several things could be going wrong. 1. Check if your service account has access to the folders where Analysis S ...Show All

• SQL Server Help Needed in writing a function to help daily nightmare with Debugging.

  I debug SPS on a daily basis and I use SQL profiler to help me trace where the problem is. Once I have established which SP is the main problem I need to debug the line of code. What I do is Cut and Paste the SQL Profiler details and populate all the parameters,sometimes that can be 30 and more.. Now what i thought is to write an SP or Function where I pass : SP name and Parameters that profiler genererates and returns me Declare Statements and Set Statements with parameters filled. EG Profiler Returns Customer_INSERT,20,'JO',BLOGG','5 LONDON ROAD' I would call my new SP =PopulateSPParams and cut and paste the profiler's string PopulateSPParams 'Customer_Insert,20,'JO',BLOGG','5 LONDON ROAD' this will RETURN THE FOLLOW ...Show All

• Visual Basic File to Array and general Array help/information.

  Hi, I have been trying to get a file of data written in the following format:- 0001 – (16bit numbers in decimal) 0002 0003 0004 And so on (upto 25000 results) Into an integer array:- myFileContents(0) = 0001 myFileContents(1) = 0002 (and so on) My code is as follows: - Dim myFileContents(10000) As String Dim i As Integer OpenFileDialog.Title = "Load File" OpenFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*" OpenFileDialog.FileName = "" OpenFileDialog.FilterIndex = 1 OpenFileDialog.InitialDirectory ...Show All

• Visual Studio Passing value from database to report footer

  Is there any way to pass-off value of field to footer report.rdlc I try place Sum(Fields!X.Value) to textbox in footer, but displays following error: The Value expression for the textbox ‘textbox1’ refers to a field. Fields cannot be used in page headers or footers. Thanks for any help. ...Show All

• Community Chat Visual Studio and Design Patterns

  Is there a tool to develop, in an automated way, design patterns from Visual Studio 2005   Thanks a lot. I'm not certain there is a FREE tool for such ... but there is this: http://www.dofactory.com/Framework/Framework.aspx ...Show All