In Program.cs I have the below method that is checking and the Syncing 5 SQL db's with the central server. Each one is separate from the other so I thought to speed up my program's load time by having them all run at the same time. Unfortunately it is very flaky working one time then not the next. The local DB is SQLExpress 2005 and the...
How can I find the order of nodes in an XML document? What I have is a document like this: <value code="1"> <value code="11"> <value code="111"/> </value> <value code="12"> <value code="121"> <value code="1211"/> <value code="1212"/> </value> </value> </value> and I'm tr...
I have stored procedure, i want to send it an array of values. When i send more than one i'm getting an error Error converting data type varchar to numeric. Here is the code. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_getTransfer] @TRANSFER_ID int = null, @COMPANY VARCHAR(5),@FORMTYPE VARCHAR(30), @TRANSF...
The server hosting csharpindepth.com has recently been migrated. Most of it is working fine, but I can't get at the database used to hold errata, notes etc. Relevant details: 32 bit Windows Server 2003 SQL Server Express 2005 installed ASP.NET pool running under "NETWORK SERVICE" account .NET 3.5 Everyone has full permission to datab...
I have recently be running into many different areas of sql server that I normally don't mess with. One of them that has me confused is the area of Logins and Users. Seems like it should be a pretty simple topic... It appears that each login can only have 1 user and each user can only have 1 login. A login can be associated to multipl...
Hello- I have a situation that really has me stumped. I have a form used to display contacts. When a command button is clicked another form pops up for viewing and inputting call information made to that contact. This form includes two subforms. One that lists the calls in datasheet view and displays call date, call time, and the call ...
I have a set of hierarchical data that I'm hoping to get into the right format without using a loop. Maybe it's a long day and I just don't see how to do it. When it starts the data looks like this: (row = row ID, par = parent row ID, lev = level, has_child is obvious, had to do that or edit the space between all those numbers!) row...
I have the tables Patient, Service, PatientStatus, Status - a Patient can have multiple statuses discriminated by a Service. I want to build a view that shows for each service and each patient what their current status is, even if they don't have a status for that service. I've got some SQL that does this, but can I write it better? (...
Hi friends I would like to know the difference between "sqlhelper class and data acsess application block". When I googled for sqlhelper calss some links are directing me to "access application block" like http://msdn.microsoft.com/en-us/library/ms954827.aspx. which is best to use. Thanks. ...
Hello, I have two table T1 and T2.I used Sql server 2000. Table T1 ID WorkerName Group 1 Rahim,Karim 1 2 Kamal,Adam 3 3 Rahim,Karim 1 Table T2 WorkerID WorkerName 1 Rahim 2 Karim 3 Kamal 4 Adam I want to replace Worker Name on T1 with 1st WorkerID on T2 ...
I need to copy the data from one database to another only if the table schema is same... a program to do that is possible but its too much work any quick short method? ...
Possible Duplicate: Displaying a Number in Words in SSRS I work in VS2005 and C#. In my rdcl report I want to show my group amounts in words. Like in my group I have the amount '1000'. I want to show that in words. But how? I know how to convert an amount to words but the problem arises when I use it on my group. How to convert...
How do I do this? The ISP says it's possible, but there's no place in the connection dialog for an IP address. Will it not work with the Express version; do I need the full version of SSMS? ...
I tried to take a SQL Server 2008 database backup from the server which has the following features: server: windows server 2008 os to the client which has the following features: client:windows xp service pack 3 os through lan network, but I couldn't achieve it and i am getting the following error: **Msg 3201, Level 16, State 1, Lin...
I wrote this for finding the sql server instances on the local machine: using System; using System.Data; using Microsoft.SqlServer.Management.Smo; namespace Application3 { class Program { static void Main(string[] args) { string srvname = string.Empty; string srvnames = null; DataTable...
I have Database in the sql2000 can i use the features of sql2008 without changing compatibility level ? Can i use reporting services with the database of sql2000 without change compatibility level? ...
This is not asking how to convert an arbitrary string to datetime in MSSQL such as this question. I can control the string format but I want to know what the MSSQL syntax is for updating a datetime field using a date string. ...
I have this query: select top(2) property_id_ref ,image_file ,property_name from property_master a inner join image_master b on a.property_id=b.property_id_ref inner join customer_master c on a.customer_id=c.customer_id When I execute it, I get the following result: 512 ~/propertyimg/3954493 id_1.jpg Commerci...
Hello! I am running a service that does some computation and communicates with an ms sql server every minute or so (24/7, uptime is very important) and writes to error log if anything funny happens (like a timeout or lost connection). This works great, however once in a while I will get this error: Arithmetic operation resulted in ...
I have to import a log file to SQL Server Database. File size is big, around 6MB with 40000 lines. The task of importing has to be done everyday with daily log. Each line of the log file contains many fields, which I have to import into properly columns in Database for post-processing. I'm confused of these solutions: -Use SQL Server I...