Recent content by calvinsinger

Many Thanks. Help Appreciated.

Hi Guys, After many months I rebooted my Server and now I cannot connect to the SQL Server. The database was available, I think, before re-booting but not anymore.. The SQL Server Enterprise Manager Error Message says A connection could be not be established to (local) Reason: SQL Server does...

thank you Esquared. I am not aware of special things which need to be done to prevent locking in SQL Server. Any ideas would be educational. Thanks Calvin

thank you

Thank you very much mrdenny for the quick & educational response. I have some further questions You say Hardware is going to be expensive. Expensive is a relative term, so maybe we can describe what it will take. Will the system below be sufficient, you think ? Or are we talking something...

I am planning to set up a SQL Server 2005 database, but do not know if it will have good read/write performance or (some other problems) or if the hardware to support such a large DB will be very expensive. I expect the database to be 1 terrabyte in size, with about 12 billion records in each...

Hi, I would appreciate some help on this. Problem: Is there fast way I can take the output of a select statement (from several tables) and directly turn it into a Perl Hash ? I want to be able to define the format of the Hash, it cannot be just any simple hash, but a Nested Perl Hash. I know...

Hi, I have a website with several hyper linked pages. It is basically online documentation with html documents & gifs. I wanted the readers of the online documentation to be able to search for phrases, text etc. Just to make it easy to get to information. This is not a website which changes a...

Thank you Calvin

I want to be able put a check in a SQL stored procedure, to check, if a cursor already exists. It it exists, I want to deallocate it and only then create a new one. How can I check (how to write the code ?) if a cursor by given name already exists. Thanks Background... The reason I get an...

If yes, what versions are supported for itanium system ? For OS is the recommendation to use Windows server 2003 and SQL server 2000 (64-bit) ? Or is it something else ? We wish to migrate from 32-bit architecture to itanium architecture, but am not sure what all software is ready and mature...

Thank you for response. I am having trouble following it though. Can you pls. give me a synopsis of what you are trying to do. In my problem scenario, the main procedure is actually calling a function. Inside the function, I am not allowed to access a temporary table, nor am I allowed to use...

Hi, Can you please tell me if there is a way to pass a table variable to a function or Stored Proc..., when calling it from another stored procedure. The problem I am facing is that I am calling a function from within a stored procedure. And within this function which I am calling, I want to...

Hi sqlsister, Thanks for the response. You see the problem is that I do not want to use a cursor. This method, is no different than doing an update, because I still have to loop through the table which I am updating. The arguments which I want to use for the stored procedure are contained in...

Hi SQLSister, But I still can not write a function with a exec or with temp tables. I am not sure how what you suggest, will achieve the result. Thanks Calvin