Search results for query: *

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

Hi, swampboggie, I wanted to use a function, but can not because my stored proc uses temp tables and temp tables, it appears are not allowed in Funcs. Also exec is not allowed as to be used in a function Hablaras, I am trying to do this without using a cursor. The arguments for the stored...

Hi, Do you know if one do an update of table based on out from a stored proc ? For example we typically do : Update some_table set some_col = 'some_value' But Instead what I want to do is: Update some_table set some_col=exec some_proc @arg1, @arg2 I have been unable to get this to work...

Hi, I wanted to be able to use table variables with an exec, or be able to insert output of dynamic sql into a table variable instead of a temporary variable. I am not sure if there is much of performance gain, since table variables are in memory, but if there is, I would like to take...

Thanks for your response. Meanwhile I ended up writing my own functions to convert Binary to Hex, & convert integers to Hex Calvin CREATE FUNCTION Bin2Hex (@sBin varchar(512)) Returns varchar(128) AS BEGIN Declare @i int, @nDec int set @sBin = REPLICATE('0', 4-LEN(@sBin)%4) + @sBin --Add...

Is there a SQL func to convert a decimal no. to Hex ?Provided by the SQL server, or does one have to write one of his own. Thanks