Hii, After upgrading of my customer SQL Server 2k Enterprise version from 4G to 12G on Windows 2003 server Enterprise version. 1. How do I know that...
Hi, I want to create a indexed view for other view to use as some of my data are huge in size. As my table structure can't be change to minimize...
Hi, If I have a temporarily table and table variable table like create table #a1(cno int, desc char(10)) declare @b1 table(cno int, desc...
Hi Example: exec get_max_id 'test_id', @w_return_value output Here my SP get_max_id will look like roughly create procedure get_max_id(@i_fld_nm...
Hi, If I have a table with one column as Float type having some data like value_str 0.6132889999999997 10561.382324 87.725239999999999 When I...
Hi, If I have a SP that return some integer value via output parmeter as it retrieve a record and update that record (hence I can't use a function)...
Hi, Our program use to calling maybe 10+ SP to insert/update/delete data. All the call to SP seem to be slow. However, when we change all the call...
1. Good day. I have a problem of source control my SP/Triggers & function in sql server 2000. 2. My company often have problem updating our...
Hi, It is know that using transaction, we can un-do any update/delete/insert. However, we want to be able to un-do any user update/delete/insert...
Hi,<br /><br />I am doing some debugging and testing using VS.NET 2003 with SQL2k.<br />When debugging my application. I need to know what is the SP...
Hi, 1. What is the main different in transaction when apply in SQL Server stored procedure and ADO.NET using code ? 2. Are they the same in...
Hi, In the market, there are many vendor that provide SQL Server peformance monitoring tool like Quest Spotlight, Embarcader Performance centre,...
Hi, I observed that when our sql server 2000 database small is small. The performance is okay and good. However, as database size increases. Some...
Hi, Anyone have use Quest Toad for Sql server or Embarcadero Rapid SQL/DBArtisan. My company looking for a good tool that can help...
Hi, I am using SQL2k
Hi, Thank for your reply. However, from your reply listed below "Ans 1 : (FROM Windows HELP ) Copying, moving or renaming encrypted data Copying...
Hi,<br /><br />If I want to provide more security for my SQL Server and want to<br />use Window Server Encryption File System (EFS) for this...
Hi, Sorry, I miss out the following 1. I should have set @nm = '' 2. When I pass '' to the SP, it will return 1. But it should return 0 insteads...
Hi, I have this weird issue on parameter passing in SP. I cannot figure out why the parameter when pass in with '', will give len(@w_nm) = 2. See...
Hi, The trigger just call a SP to update one of the table of some information needed by other my web application. And we might need the information...
Separate names with a comma.
