ryan.rogers's Q&A profile

• SQL Server Stored Procedure - Insert with table name from parameter

  First of all hi for all, I m trying to make insert stored procedure with parameters, i want to send table name and insert values with parameters, i m trying that below stored procedure but it gives syntax eror to me what shoul i do to correct it set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [insertalepform] -- Add the parameters for the stored procedure here @type nvarchar ( 15 ), @talepbrmno int , @birimisteksayi bigint , @birimistektarih datetime , @aciklama nvarchar ( 50 ), @onay int , @seviye int , @talepformno bigint , @taleptarih datetime AS BEGIN SET NOCOUNT ON ; exec ( 'INSERT INTO [BelediyeWork].[dbo].[' + @type + 'TalepForm ...Show All

• Visual Studio 2008 (Pre-release) netMsmqBinding using WAS

  Hi, I'm currently testing WAS running "Longhorn" build 6100. When hosting services using net.tcp everything is running fine. However, when I attempt to start a service using netMsmqBinding the application pool used by WAS process "freezes". The only error message I get is an entry in the windows event log indicating that the WAS process "hasn't responded to a ping". The service I'm trying to test works fine when running on Vista Ultimate machine. Any ideas Hi Henny, Could you please answer these three clarifying questions 1. When you say "Longhorn" build 6100, are you referring to Windows Server codename "Longhorn" I wasn't aware build 6 ...Show All

• SQL Server Create Subscription For Rpt Service with Windows integrated security !!!

  hi All, I m nicky here. I have problem on Create Subscription for my report if my Data Source is use Windows Integrated Security, with this error message: "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report , the linked is no longer valid" Please Help .... Thank you From nicky Yep, it sure does. A big pain. You could have multiple copies of the one report and change the data source of each report. Then secure the report via user groups. A pain, but if you only had a few users it might be ok. If you have hundreds however...... ...Show All

• Visual Studio Express Editions beginner to c#

  hi , i m beginner to C# n wanna know that any windows application can be made by using C# only can we make an application in C# to control hardware thanks for your response but i don't want to do that as u r thinking but i want to make a software for changing the functionality of hardware or you can a software that will add functionality to some the input device, like changing the function/work of a keyboard. i want to make a software for changing audio signal to digital signal. please reply. ...Show All

• Visual Studio Express Editions Mixed types

  Hi! I have an issue with mixed types. I have written a very simple example : #include "stdafx.h" #include <iostream> public ref class R { public : FILE* textFile; R() { fopen_s(&textFile, "sample.txt" , "r" ); //error C2664 } ~R() { this ->!R(); } !R() { fclose(textFile); delete textFile; } }; This example generates the following error: 1>.\test.cpp(9) : error C2664: 'fopen_s' : cannot convert parameter 1 from 'cli::interior_ptr<Type>' to 'FILE **' 1> with 1> [ 1> Type=FILE * 1> ] 1> Cannot convert a managed type to an unmanaged type Actually is 'textFile' an interior pointer I thought it was a nat ...Show All

• Visual Studio Team System Can't Change the Update Action for certain objects in Schema Compare

  I don't know if this is by design or not, or whether I am doing something wrong, so any help will be greatly appreciated. I've imported an existing database schema into a new project. I then used the schema compare tool to identify differences between my project and another copy of my database. The comparison tool works fine, identifies all of the differences. The issue I am experiencing is that for certain objects (this happens for tables, views and sprocs) I am unable to change the Update Action from Create \ Update to Skip. For other objects (again, tables, views and sprocs) I am able to change the Update Action at will. I am not sure what the difference is between the objects whose Update Action can be changed and the one ...Show All

• Windows Live Developer Forums Msn Web Messenger

  I need Msn Web Messenger any can give me script. ...Show All

• Visual Studio 2008 (Pre-release) autocomplete (using a combobox?)

  It seems Textbox does not support autocomplete (or is TextComposition used for this ). So I'd like to use a combobox as input field for autocomplete text. Problem is, my data contains 114964 items, and if I open the dropdownpanel of the ComboBox it will eat up all my memory trying to show all these items at once (== no good). Can anyone point me to a working example or some hints how to do this, how to have autocompletion in WPF I'd love it to be a combobox so you can select the few items left, or even better it would show a small popdownpanel with the next four or so items, just like IEs address bar. thanks, Sam Sheva, you misunderstood: as I said, I don't want to show the data. I just wa ...Show All

• .NET Development Replace xml schema in WSDL file

  Is it posible to replace the schema in the auto generated WSDL file in a Web Service, with or without WSE 3.0 I need to make more specific constraints/restrictions to it. Or is it normal to just leave the WSDL file with the standard auto generated types and then validate against a more strict schema when the request is recieved From this: - < s:complexType name =" Supplier " > < s:sequence > < s:element minOccurs =" 1 " maxOccurs =" 1 " name =" SupplierNo " type =" s:int " /> < s:element minOccurs =" 0 " maxOccurs =" 1 " name =" SupplierName " type =" ...Show All

• Visual C# i Console.Write problem

  I want to punctuate every call to a certain procedure which is a part of a Class separate from the calling procedure Class with Console.Write ("."); statement. I need a simple dot positioned at a line. It is primarily a debug situation but still I want it to be compact. I want all the calls being marked on one line, not 200 lines or so. In the setup like this Console.Write ("."); refuses to do what I expected. It acts pretty much like Console.WriteLine ("."). In other words it feeds in end of the line charactes. Is there a way to avoid it Thanks. I dont think that there is something like what you are saying. Console.WriteLine() puts a carrieage return at the then but Console.Write() doesnot. The ...Show All

• Audio and Video Development Windows Media Encoder 9

  I hope someone can help me. Im broadcasting using Windows Media Encoder 9. Im doing a screen capture off of another computer. But today, its only using black and white screen. Its allways been color. Anyone know how to switch this back Thanks for your time guys. ok, somehow i got that problem fixed but now i have another one. When im switching sources, while encoding, sometimes the sound bugs out, and goes to a complete screeching sound. If i switch to another source, then back to the live source im using, sometimes the screeching sound goes away. Any idea what is causing this ...Show All

• Visual C# Excel files are accessed by more than one application or not ?

  I am using Excel Files to store my application data. Please tell me Can Excel allow more than one apps access it or not (like SQL Server,...). Thanks so much! I believe it wont allow you to open the file when its already connected to by another application. It's locked when a connection has been opened to it and wont release it until the connection has been closed ...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

• Visual C++ basic (default) Console ap using STL has Manifest error on DEBUG but not RELEASE.

  I am using MSVC 2005, and I added VCRedist.exe and SP1 recently. It is running under WinXPpro (version 2002, SP2), on a Pentium 4 3.40GHz machine. I created a basic Console application using defaults in the wizard. - manifests were turned on by default (Linker property: Manifest File: Generate Manifest = YES) When I added my test code to _tmain(), and compiled it under both DEBUG and RELEASE, it looked fine. std::string hello("Hello, world"); printf( "%s", hello.c_str() ); But when I ran it under DEBUG, it gave me an R6034 error ( attempted to load the C runtime library without using a manifest ). But when I run the RELEASE mode, it looked like it ran fine (ctrl-F5). What is wrong I tried to look at the R6034 p ...Show All

• SQL Server Foreach Loop and distributed files

  Hi - I'm new to SSIS and am having problems figuring out how to do the following. I need to load data from flat files into SQLserver 2005 and have created the data flows ok, but my data files are *not* located in a single directory so I cannot use the foreach file enumerator option in the foreach loop container collection. Please correct me if I'm wrong My approach has been to execute a SQLcommand to get the filenames from another database table and to use the foreach ADO enumerator option and mapping the returned filenames to a project scoped variable (data type object since it is a rowset). My problem comes when I edit the properties of the connection manager to try to use that variable for the connectionstring property in the e ...Show All