Jagjot Singh's Q&A profile

• SQL Server Evaluate as an expression

  I have just been brought in a project that is a huge mess....They have specked this project to allow for a user to create ad hoc calculated expressions using tags of data that are supplied by another system. This sort of looks like this ID | Formula | A | B | C | D | 1 A + B + C 1 2 3 4 2 C - D + A 1 2 4 2 3 D - A + 1 4 2 6 8 They want to then evaluate the formula expression using the corresponding column-row values to arrive at a value. As of right now I am a bit lost on how to do this, does anyone have any ideas Thanks! Josh Rogers Unfortunately they have 6 days now before release of the first phase and they are just now pulling me in as you said an oh **** last ditch maneu ...Show All

• SQL Server SQL Server 2005; Unique Constraint, Covering Index Question

  Hi, When I create a unique constraint, SQL Server automatically creates an index on this constraint. So when I run the following... ALTER TABLE PersonsProjects WITH NOCHECK ADD CONSTRAINT NoDupes UNIQUE NONCLUSTERED (PersonID, ProjectID) ...SQL Server will create a composite index on PersonsProjects called NoDupes on PersonIDand ProjectID. Thing is, I need this index to include a third column Status since most queries use this column in conjunction with PersonID and ProjectID. If there was no index on this table, I would have created it as follows: CREATE UNIQUE INDEX NoDupes ON PersonsProjects (PersonID, ProjectID) INCLUDE (Status) WITH IGNORE_DUP_KEY But this won't enforce the unique constraint on PersonID and ProjectID wh ...Show All

• .NET Development NegotiateStream...Server rejecting client credentials

  I have some networking code that I have modified to allow for using the NegotiateStream to authenticate clients when they connect. I am having a strange problem where the authentication is failing with " The server has rejected the client credentials " (Logon failure internally). The weird thing is that the same exact code works on another machine. On the machine where it isn't working I can pass the CredentialCache.DefaultNetworkCredential and it works but using a username/password/domain for an account on the very same machine doesn't work. I am running on XP not connected to a domain (both computers). I have tried using several accounts in the credential for the client auth but no matter what account is used it fails wi ...Show All

• .NET Development C# TCP Remoting Security Exception

  Hello, i'm having an issue with remoting... i'm attempting to create a simple chat application, where client(s) connect to a server and messages are sent back and forth (using windows forms)... I'm using events and delegates to initate the changes to the textboxes, the messages sent from the client to the server will show up fine, but if i try to create a new event handler from the remote object i get a security exception. I don't know much about security, so i was hoping someone can help me out... i'm not using a config file to set up remoting (one more thing that has to be with the program) here is the direct paste from the exception i'm getting. System.Security.SecurityException was unhandled Message="Type System.Delegate ...Show All

• SQL Server Open a DSN connection in TSQL

  I'm trying to update an SQL DB from data in Quickbooks. I am trying to find if I can open a dsn connection in a stored procedure, called from an ASP page, to the quickbooks db using odbc. The driver I have for odbc does not allow for linked servers. I'm very new to stored procedures and such so please bear with me. Thxs. You are correct, I don't know VB.Net either. I know ASP that is about it. I don't have an example for you, I can create a linked server to the Quickbooks db in Ent Manager but then I can't figure out how to access the db from SQL. If I am not mistaken you have to have four-part naming to access the db but I believe the ODBC driver supplied with Quickbooks does not support this, you ...Show All

• .NET Development Connecting to Access DB

  I started a new WEB Site and added a connection to an Access DB. Now when I edit this WEB site or open a new one I cannot connect to an Access DB. When I try to establish the connection it asks me for the ConnectString. Any suggestions Thanks. Moish Hi, Sorry for the delay, I've been quite busy these days. So what exactly is the problem If the contents are shown when you preview your database and your database changes are reflected so I think everythings fine. Is the problem of not being able to connect to your database occurs during publishing cheers, Paul June A. Domag ...Show All

• SQL Server SQL 2005 SP2 installation blocked

  I'm getting the following error when I try to run SQL05 SP2 on my server. When I get to the Authentication screen, I select Windows Authentication and check the box to use for all services. I am logged in using my personal admin account. I click the 'Test' button. Connection to Database Services, instance name 'MSSQLSERVER' is successful. However, connection to Reporting Services, instance name 'myserver\SSRS' fails. The error message is: "Login failed: HResult 0x2, Level 16, State 1, Named pipes provider: Could not open a connection to SQL Server[2]. Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server." I've had problems getting Reporting ...Show All

• SQL Server transfer database task error

  hi, I have created a SSIS package that does nothing more than loop through all DBs and copies the userDBs to another server. However, I keep getting an error after the task has created the database during its execution of "Create Role" statements. Here is the error: Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE ROLE [aspnet_WebEvent_FullAccess] " failed with the following error: "User, group, or role 'aspnet_WebEvent_FullAccess' already exists in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection ...Show All

• SQL Server SSIS interview questions.

  Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions. Thanks These are the questions that i might ask: 1) What is the control flow 2) what is a data flow 3) how do you do error handling in SSIS 4) how do you do logging in ssis 5) how do you deploy ssis packages. 6) how do you schedule ssis packages to run on the fly 7) how do you run stored procedure and get data 8) give a scenario: Want to insert a tect file into database table, but during the upload want to change a column called as months - January, Feb, etc to a code, - 1,2,3.. .This code can be read from another database table called months. After the conversion of the data ...Show All

• Visual Studio Express Editions only take text between two points

  i want to only take the text between the >text in here< <OPTION value=i1100161>chris - 0411532348<OPTION value=i978461> i want to take the text of "chris - 0411523248" and nothing else. How can i do this. This is what i came up with Public Sub address() If ran = False Then Dim word, myword, temp As String , start, finish As Integer Dim stoprun As Boolean = False Dim filllist As Boolean = False Dim namesinaddress As Integer = 0 Dim runonce As Boolean = True Dim count As Integer = 0 word = loginwb.Document.GetElementById( "completeAddressList" ).InnerHtml word = word + " ...Show All

• Visual Studio I have lost my S/N and i need help here?

  hello , i have microsoft visual studio 2005 standerd edition and i have lost the S/N but its still instaled on my pc is there any way to know my sn from the pc or from microsft becous i need to format my pc i hope someone answer me becouse its important and thanx Zaid I won it when i was at jordan from microsoft and i still know the prodact id any way i have traid this page but it gives me Sorry, the page you requested is not available. The page you were looking for is currently not available. The address may not be correct, or there may be a temporary problem with this site. Please try one of the following options: Check the address fo ...Show All

• SQL Server log shipping between sql 2005 clusters

  hi I am working for a small govt dept.We are planning to implement sql 2005. We will be having sql 2005 instance in active/passive cluster mode We will also have a standby sql server 2005 in active/passive cluster mode. i need to know how to configure log shipping between my primary and secondary Is logshipping the best option Thanks Is logshipping the best option for what Logshipping is a fine technology but there are other ways to get data to a secondary server. You can use database mirroring in SQL Server 2005. For failover purposes this is a great option. You can also use database snapshots on the same server for various reasons to. Logshipping is perfectly viable too. What are you t ...Show All

• Windows Forms auto scrolling

  hi i have a readonly richtextbox , I need that when the text changed on it , the vertical scroll bar go automatically to the lower side; how can i do it thanks................. Set the SelectionStart property. If the control doesn't have to focus, use the ScrollToCaret() method. Moved to Windows Forms General forum. ...Show All

• Windows Forms RowFilter property of the RelatedDataView

  Hi! Good day Why is it that the RowFilter property of the RelatedDataView class does not filter the records Is this a bug or not Here is my code snippet: CType(Ctype(Me.BindingContext(Me.GridView.DataSource,"MyRelation"),CurrencyManager).List,DataView).RowFilter="Amount>100" It does not filter anything on the RelatedDataView. Hoping for a positive response. :-) CostingDataSet . Inv_CostTypesDataTable dt = new CostingDataSet . Inv_CostTypesDataTable (); CostingDataSetTableAdapters. Inv_CostTypesTableAdapter da = new CostingDataSetTableAdapters. Inv_CostTypesTableAdapter (); da.Fill(dt); DataView dv = new DataView (dt); dv.RowFilter = "CostType = 'bank' " ; dataGri ...Show All

• Windows Forms BackgroundWorker - accessing controls outside of thread?

  Hello all. I am using the BackgroundWorker control in VS 2005 (System.ComponentModel.BackgroundWorker). I have implemented all three of its Event Handlers - DoWork, ProgressChanged, RunWorkerCompleted. The DoWork handler calls a method (we'll call it foo()) that is time consuming and access a database. I have a DataGridView and RichTextBox on the form. Within foo() I am adding elements into a StringCollection (using a DataReader). When the process is complete, I call the ProgressChanged event and pass it this StringCollection: while (dr.Read()) { //add items to StringCollection } worker.ReportProgress(-2, nonMatchingCollection ); I would like to be able to set the DataSource of my DataGridView to this StringCollection from within th ...Show All