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...
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...
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...
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...
If I have a table with one column as Float type having some data like
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)...
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...
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...
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...
In the market, there are many vendor that provide SQL Server peformance
monitoring tool like Quest Spotlight, Embarcader Performance centre,...
I observed that when our sql server 2000 database small is small. The performance
is okay and good.
However, as database size increases. Some...
Anyone have use Quest Toad for Sql server or Embarcadero Rapid SQL/DBArtisan.
My company looking for a good tool that can help...
I am using SQL2k
Thank for your reply.
However, from your reply listed below
"Ans 1 : (FROM Windows HELP )
Copying, moving or renaming encrypted data
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...
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
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...
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.