Search results for query: *

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...

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...

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...

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, 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...

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

Hello All, My question has 2 parts. Please help if you can. Help appreciated Thanks Calvin Part 1 ------- SQL 2000 supports a new data type, table. However I am having trouble using it, when I use it as part of string, which I execute. for example -declare @my_table TABLE (MYID int) -set...