Ted.'s Q&A profile

• SQL Server .NET FW SDK QuickStart SQL-Express Error: Msg 102 ... Incorrect syntax.

  Hi, I have followed the steps from the .NET FW SDK QuickStart Configuration (C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Samples\Setup\html\ConfigDetails.htm), and have got an error message trying to grant the ASP.NET User account access to the databases by the command sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin LEONEW\ASPNET" where LEONEW is my local machine name, and the ASPNET account exists in the Users group. I am getting the error message: Msg 102, Level 15, State 1, Server LEONEW\SQLEXPRESS, Line 1 Incorrect syntax near '\'. Please help if you know how to resolve this. Thanks in advance. Alex. I have tried with no success sqlcmd -E -S (local)\SQLExpress -Q "sp_grantl ...Show All

• SQL Server SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana Yes, you mentioned ' derived column '. But I already used ltrim(rtrim( )) before 'Data Convertion'. The same problems happened.   What is "The data value cannot be converted for reasons other than sign mismatch or data overflow."     Thanks ...Show All

• SQL Server SQL Server 2005 - Log Shipping - Missing sp_change_primary_role and sp_change_secondary_role

  I have installed SQL Server 2005 and setup a cluster and log shipping. I decided to perform a planned failover and realized that there are no sp_change_primary_role and sp_change_secondary_role stored procedures. I checked on both the SQL Server 2005 installations and could not find them. My question is : "Is it safe to get these stored procedures from a SQL Server 2000 database and run them on the SQL Server 2005 database " "Has anyone come across such missing stored procedures in SQL Server 2005 and know the reason why it is so (so that I can avoid it in the future if it due to a faulty installation) " Cheers NEVILLE GEORGE Refer to SQL 2005 books online for ms-help://MS. ...Show All

• Visual Studio Team System About The Method AddProblem

  Hi all: This is a method called AddProblem Its defination is AddProblem(string[] items, Method method, SourceContext context) What is stored in the fist argument 'string[] items' How to use it Hi sammy, The items argument to this method was used by our dataflow analysis component to pass additional information about the violations found to rules. This was used in cases when knowing only the method was not sufficient to give a meaningful resolution to the user. We have changed our dataflow analysis for the next release of FxCop and VSTS, and this class has been removed. I hope this is helpful. -Brett Wortzman ...Show All

• Visual C# Build Events Error

  Hi all trying to use the Build Events that are on the property page of the project I wish to copy a Directory so it's placed within the release folder when i compile. I write the following post build. [code] copy"$(ProjectDir) Reports" "$(TargetDir)" [/code] It works and my code complies but i get the following error message any one now why Error 1 The command "copy"C:\C# Work\ReportTest\ReportTest\ Reports" "C:\C# Work\ReportTest\ReportTest\bin\Release\"" exited with code 123. ReportTest Thanks!!! Add the /I option and see if the problem goes away. Michael Taylor - 2/8/07 http://p3net.mvps.org ...Show All

• Visual Studio Express Editions create numbers

  Hallo I 've got a problem with a kind of numbers. I want to have the code to create the following: 1: 1 2: 12 21 3: 123 132 213 231 312 321 4: 1234 1243 1324 1342 1423 1432 2134 2143 2314 2341 2413 2431 3124 3142 3214 3241 3412 3421 4123 4132 4213 4231 4312 4321 5: 12345 12354 ... So al the possible numbers you can create with a limited number of numbers. I want to do this until 9: 123456789 .... 987654321!!! Is there someone who can help me to get the code to create that list of numbers Thx PS: sorry about my english So, what code do you have so far Which part is giving you problems You should have, at least, a loop which goes from 1 to 9... ...Show All

• Visual Studio 2008 (Pre-release) Get at Binding from inside IValueConverter?

  I am writing an IValueConverter that needs access to more than just the value to convert. Specifically, I need access to the DataContext (source object) and Path (property name) so I can check to see whether the user is authorized to view the data. If they aren't, I want the converter to return "n/a" or some similar neutral value. Obviously this sort of thing is somewhat possible, because the ExceptionValidationRule is aware of the data flow and whether an exception occurred. But it isn't obvious to me, or google, how you might get at these details from inside the Convert() or ConvertBack() methods. Anyone have any ideas Use an IMultiValueConverter whose inputs are (a) the real data, (b ...Show All

• Visual Studio Express Editions How to loop buttons to enable/disable

  Having problem doing a simple loop through 10 buttons on a form, what I want to do is loop through the buttons and turn on or off depending on user input. The for loop works in that it loops 10 times but I want it to call btn0-btn9.Enabled = False to turn off buttons. Hi, you can access controls by name using the code similar to this: For i As Integer = 0 To 9 btnControl = "btn" & i Me. Controls(btnControl).Enabled = False Next Just make sure all buttons are put directly on the form (not contained in other containers, like panels, etc.). If they are not, you'll have to change the Me.Controls part of the above code... Andrej ...Show All

• Visual Studio Express Editions data query

  hi all im trying to find out how to pass a value to a query to use as part of the search something alomg the lines of WHERE (Customer_lastname LIKE textbox1.text & '%') the value im trying to pass is from the textbox any ideas would be apreaciated   ti_m wrote: hi thanks both of you for your help but as im quite new to vb im having some small problems first if i just copy your example i get an error saying i havent defined myparaemeter However from the link i managed to write this but it doesent seam to be working thanks again Dim mySelectQuery As String = "SELECT Customer_lastname, FROM customers WHERE (Customer_lastname LIKE TextBox1.Text & 'a%')" Dim myConnection As New ...Show All

• SQL Server Character count limit?

  Does anyone know what the character count limit is for a SQL table We have a table with a column called body_text. It contains characters from a story we publish every day. Example: News from Canada and Turkey We get our weekly news update from our Canadian correspondent, Vaughn Palmer. Plus, the Pope is in Turkey. The visit is provoking opposition from secular nationalists and Islamists. We talk to a reporter in Istanbul. Also, our weekly listener's forum. I did a word count in MS Word. This paragraph is 275 characters long. I found this in the only SQL book I currently have called Beginning SQL Server 2005. I found a snippet I thought might be related to my question. Char The char data type is fixed in length. If you define ...Show All

• Visual Studio Express Editions problem with .exe file of vb.net project

  why cant i open my vb.net project .exe file on another computer(were connected on a network) How can i make an installation file for my vb.net project so that i can install it on a remote pc. thanks very much The .NET Framework should be installed on the remote PC. Without it the PC will not be able to run .NET applications. Just install .NEt Framework Redist. package (download from microsoft). ...Show All

• SQL Server SECURITY ON MULTIPLE DIMENSION MEMBER COMBINATIONS. OLAP Experts, Please Help me

  Hi, I have got 2 dimensions to enforce security . 1. Company 2. Division Data in Fact table is available as mentioned below. Company Division Amount Company 1 Division 1 100 Company 1 Division 2 200 Company 2 Division 1 300 Company 2 Division 2 400 I have got a user. So I need to create a role with following options. ([Company].[1],[Division].[1]) and ([Company].[2],[Division].[2]) He should not be able to see ([Company].[1],[Division].[2]) or ([Company].[2],[Division].[1]) In Summary, My question is, How to implement dimension security (Static/Dynamic) on multiple dimension combination (MSAS 2000 or MSAS 2005). I am to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. fireballs follow character?

  ok, im not sure what im doing wrong... but when I stop press space bar(character is facing right) to fire and then decide to move my my character left the fire ball moves backwards with the character and vice a versa I can move my character left, right, left right repedatly and the fireballs stays with the character until I stop moving and they finish the x distance and disappear here are two methods im using protected void AddFireball() { if (_fireballsElapsed == 0) { bool _addFireball = true ; foreach ( KeyValuePair < string , Sprite. Sprite > aFireball in _fireballs) { if (aFireball.Value.Visible == false ) { aFireball.Value.StartPosition = new Vector2 (_tif.Position.X + 50 ...Show All

• Visual C++ Has casting to int from double changed completely in VS2005?

  Has casting to int from double changed completely in VS2005 Numbers that are too big are always -1 now. Which has caused me much pain to track down and is not compatible with code we currently use. Here is an example, it used to be that if you cast a big number to an int, you would some value that was related to it in some way: (int)1.0957837e+011 => -2090779696 But now it is always -1 if the value is out of the range of the int: (int)1.0957837e+011 => 0x80000000 Is there anyway to make Visual Studio 2005 use the old style of casting Thanks John Petritis The version of Visual C++ 2005 that I have has 3 options for "Enable Enhanced Instruction Set": Streaming SIMD Extensions (/a ...Show All

• Visual C# Creating a Generic class with constraints and also Inherits from a base

  Is it it possible to have a generic class inherit from a base I can't find an example of the syntax, so I don't know if it's possible or not. I want to do something that looks like this: public class MyClass<TInterface, TView> where TView : TInterface : BaseClass {} So the class declaration should create a generic class with two generics where TView is of type TInterface, but then the generic class MyClass should inherit from BaseClass. Thanks for any help. Trevor_B This test is compiled: class Class1 { }; class Class2<T> : Class1 where T : class { }; ...Show All