Viewing 15 posts - 31 through 45 (of 60 total)
Try to avoid calculation in the SELECT statement if you use a lot of the calculation's result and contain of thousands of rows again and again.
Instead, try to add one more...
February 16, 2004 at 6:02 pm
Gary's idea is great! Thanks for it as I never think before that we can actually read what MS is running at our back!
Unfortunately, when I tracing, I end at...
February 12, 2004 at 9:23 pm
noeld's idea is great. You can check with UDF, but you must handle many possibilitiessssss, such as '--', '*' and other reserved characters.
Beware of SQL Poisoning! For example, SQL...
February 12, 2004 at 8:37 pm
Do anyone know what is the name of the system tables that included in the store procedure sp_help_job. I can only get the name and other related info from...
February 12, 2004 at 8:28 pm
Check the answer from your another posting "new year new number Generating in SQL server"
February 10, 2004 at 8:56 pm
Antares686's codes work well. Please morify your codes to the codes below. I tested it out and it work well. The idea is good enough to solve your problem.
CREATE TABLE...
February 10, 2004 at 8:52 pm
One method is create a temporary table and insert all the results into it. Select the 'execution status' field and compare the result with the table you specified above.
I use...
February 10, 2004 at 8:41 pm
EXEC SP_HELP_JOB
See the execution_status. If 1 then is running, and 4 if the job is idle (if I am not mistaken).
February 10, 2004 at 2:48 am
Why you want to view the progress if you decided to set NOCOUNT ON?
February 10, 2004 at 2:44 am
Sorry for the typo-error. I mean replication. Can I stop the replication by using any of the store procedure and of course to get the status of store procedure before...
February 10, 2004 at 2:41 am
Beside using GUI (Enteprise Manager), can we use command to restart the replication (command at command prompt)?
February 8, 2004 at 10:59 pm
Dear Experts,
As the forum become "hot" here, I want to come out with some kind of similar problem. This query run quite long and sometimes caused my DTS failed.
SELECT *...
February 8, 2004 at 7:55 pm
I agree with 'guarddata'! I am proud to said I am member of SQL ServerCentral forum. This forum consists of thousands of expert!
Thanks to the suggestions that posted by most...
February 3, 2004 at 5:07 pm
Dear ckempste,
I already thought of your idea before but it takes a lot of time. I need to change quite a lot of tables. Any other ideas?
January 27, 2004 at 10:41 pm
phillcart is correct. I agree with him. Sorry for not include this important point in my answer.
January 15, 2004 at 6:43 pm
Viewing 15 posts - 31 through 45 (of 60 total)