Search results for query: *

Using CRXI in C# (VS2005), Vista Home Premium, SQL2000. I have a very basic report with 2 parameters - if I run the report in CRXI I get prompted for the parameters and the report shows the correct data. Viewing the query in SQL Profiler shows the correct WHERE statement. However, if I open...

Can anyone suggest a decent strategy for copying (potentially) large amounts of data into the same tables in a database ? To explain, I have a database which holds estimate details in a number of related tables. The client would like a facility to copy an estimate, creating a clean version...

Up until now, all the applications I have worked on have been for use within the company, so I have not had to worry about licensing for the app itself. I am now building a commercial application and would like to restrict the number of application users connecting to the database. I have...

Up until now, all the applications I have worked on have been for use within the company, so we have not had to worry about licensing for the app itself. We are now building a commercial application and would like to restrict the number of application users connecting to the database. We have...

Can anyone advise why storing the name "Karen-Ann McCabe" in a varchar(50) column returns a LEN value of 18 ? I have checked that there are no extra characters at the end of the name. This is causing queries to fail when the look for the exact string. If I add the % wildcard to the end the...

As a developer, I have been asked to investigate the following. However, I do not have a great deal of Citrix experience so please bear with me. We have an application which we would like to migrate from being a thick client to a published application. However, the application creates Word...

I have a VB.NET app which we are deploying to users via Windows 2003 Server in Terminal Server mode. The users connect via the RDP client, with the 'Start a program' option set to the app. When the app is running, trying to open the help file does not work - no exception, it just fails. The...

I am trying to drop a column through TSQL, but get the following error: Server: Msg 4922, Level 16, State 1, Line 9 ALTER TABLE DROP COLUMN D failed because DEFAULT CONSTRAINT DF__Estimate_Site__D__2C8964E2 accesses this column. The code used to create the column is: alter table...

Can anybody advise how I can evaluate a null parameter in a stored procedure WHERE clause? I am trying to achieve the following: CREATE PROCEDURE Report_Test @MainID INT, @SubID INT = NULL AS SELECT * FROM tbl WHERE MainID = @MainID AND SubID = @SubID MainID is always a value, but SubID...

Can anybody tell me why the following conversion of a decimal to a string is displayed differently on my development machine (W2K Pro) and the Terminal Server it is to run from (2003 Server) ? I am taking a decimal value from a datatable and inserting it into a text box, like: TextBox1.Text =...