Recent content by Warnie

Hi, I have a ASP.NET datagrid. I need to select a particular row. I don't an event on the serverside. Is it possible to accomplish by Javascript. Any pointers would be appreciated. Thanks, Warnie

Nigel, If I drop that column, I will be losing data. I reckon that I will need to drop the column and then add it. But the column is the first of the many columns in the table. So if I recreate the column, I will end up with the column moved to the last. Am I right in my understanding? Warnie

Hi, I have a table XYZ which has a column as Item_Id. I had to create this with an identity seed but missed out. Now the table has been created in production. I want to alter this column to have a IDENTITY. I tried the following syntax Alter Table XYZ Alter column Item_Id int...

Thanks Nigel. But I tried text and it seems to only hold 256 characters. May I wrong in my understanding?

Hi, I have a column in a table which should store more than 10000 characters of data. I tried varchar which only gives me 8000 characters. Which datatype should I use for this? Please respond. It's urgent. Thanks, Warnie

Hi, I have installed a software which is creating a service. I have ran through all the guidelines given by the vendor. At the end of it, the service is created alright. But the service is not starting. The message I am getting is "The eDataQuality service on Local Computer started and...

Hi, I am looking for some sample coding on IBM MQSERIES. I will be happy if I get a COBOL program which will post a message to the MQSERIES. Any pointers on MQSERIES are most welcome. Warnie

Thanks Matt, Hypetia and Glasgow. That was really helpful.

Thanks Glasgow. It helped. Instead of using the sysinfo control, can I use the API? It is also returning the same results. The API name is GetVersionEx. Any idea why there are 2 numbers returned namely 5.01 and 6 for WinXP?

I am trying to determine the OS of a particular machine.I have an application which is to run in both Win2000 and WinXP. I have a resolution problem in WinXP and hence I have to rework on some of my screens so that they look alright in WinXP as well. I need to know how do I determine the OS...

Hi, I am stuck in a problem. My application database was created for the collation setting SQL-Latin1_General_CP1_CI_AS. We have built an install shield for this which will attach the databases during the installation. This works fine as long as the server's collation setting is...

Hello, I am working on a large VB application which is using a lot of third party controls. I have a large set of menus which lead to different forms. On one particular option, I am getting a new error from today. The error being: --------------------------- vb6.exe - Application Error...

Jim, As an alternative to stored procedure, you can use the ADO objects. ADO gives the recordset, connection and command objects which can help you build a query in your VB code and send it to the database.Hope this helps.... Warnie

tlbroadbent,SQLBill Sorry for coming back late. Both of you are right that there is no problem in the code I have posted. I did a thorough analysis of my code and found that it is not a problem with attaching the DB. The situation is that I have a TEMPLATE DB which I am trying to make a copy...

tlbroadbent, I understand the implication with respect to BACKUP and RESTORE. As you have suggested, I am giving the code below. This is the stored procedure code: CREATE PROCEDURE stp_NewProject @DatabaseName varchar(100), @LocalPath nvarchar(200), @QueryRequested varchar(50)...