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, 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,<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, 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 If my web application after some user click, will update one of my database table column which will trigger a stored procedure to run. This...
Hi, Anyone know of any free tool to encrypt SQL2k stored prcocedures/function and trigger ? Native sql2k encryption can be crack by third party...
Hi, If my application is using the SQL Server 2000 opendatasource import function to import excel file into our DB table for processing. However,...
Hi, I have 02 issues with Oracle and linked server on SQL Server 2000. First, I have successfully setup 02 linked server to a Oracle Database and...
<br />Hi,<br /><br />I am working on have 02 machine WinXP Professional with SP2 and<br />SQL2k developer with SP4 install. They are machine A and...
Separate names with a comma.
