With the below SP I want to output "@tfunction_call_log_id" when
executing the line
"SELECT ISNULL(MAX(function_call_log_id) + 1,...
Thanks derrickleggett for you reply.
Is there any risk of deadlock using HOLDLOCK.
I use the following stored procedure to increment a call ID. Here is my problem, the calling application is throwing an exception with the...
Below are my scripts for full backup and differential backup. Full backup runs once a week and usually it is around 5 GB. Differential...
Yes Twan i am talking about the name of the 'return value'. EDIFY is the calling application.
I have an application that used to run on SQL 7.0. I upgraded my development SQL server to 2000 but my applications started treating...
Thanks for your reply sundeip but I need to re-compile all at once not one by one.
I need to re-compile several stored procedures in a database. Is it possible to re-compile all at once. If so how do I do it?
Thank you in...
I need to delete 23million rows from a live database. I cannot use truncate table command because the table has a FOREIGN KEY constraint....
I need to drop a table on the production server. The table has 15,000,000 records. Will it impact on the performance of the database while...
Thanks Twan and staya for the help.
This is my current Configuration.
SQL Cluster Active/Passive
Local drive partitioned into two
I am very new to SQL cluster. I am upgrading SQL 7.0 Cluster ruining on win2k Adv server. Is it possible to Ghost the image of the cluster nodes and...
Separate names with a comma.