Viewing 15 posts - 46,846 through 46,860 (of 49,571 total)
What you're getting back from sp_executesql that way is the return value. Traditionally that's 0 if there was no error, otherwise it's the error code. But that depends on the...
April 18, 2008 at 5:58 am
Please create a new thread for your question.
Thanks
April 18, 2008 at 5:53 am
Jim Russell (4/18/2008)
That's the chauvinistic IT department high priest answer!I don't care about the job title of the author of the problematic query, I just want to limit the impact.
If...
April 18, 2008 at 5:51 am
Limit permissions so that users can't write ad-hoc code.
Code reviews for all code written by the developers
Training
April 18, 2008 at 5:27 am
That will work. Just be aware that it has the potential to become a major performance problem when the tables get large.
The subquery in the select clause runs once for...
April 18, 2008 at 5:06 am
Ok, maybe give this a try...
It's not tested, since you didn't give table structure or sample data
SELECT Call_No,
Call_Log_Date,
Call_Resolve_Time,
Call_Downtime,
Call_Resolve_Downtime,
Call_Description,
ACTIONS_DESC...
April 18, 2008 at 4:52 am
While number searches can be faster than string searches, you'll probably loose all your gains during the encode/decode.
A million rows aren't much to sQL server, providing your query is...
April 18, 2008 at 4:39 am
Whichever one the optimiser chooses. Don't use join hints.
April 18, 2008 at 4:35 am
Open a new query, paste the following then run it.
DECLARE @a int
EXEC [get_form_count] @return = @a OUTPUT
PRINT @a
April 18, 2008 at 4:04 am
When you can read the SQL error log, please post any entries that look strange, have error severities above 19 or refer to the suspect databases.
It's important to know why...
April 18, 2008 at 4:01 am
mark (4/18/2008)
If this is the case and doing extra ad-hoc backups do not make a difference, what then is the advantage of the new "copy_only" feature in 2005?
Normal full backups...
April 18, 2008 at 3:55 am
Anirban Paul (4/18/2008)
As I told you I couldn't check as I found in under SQL Server 2000 in some sites.
No worries. I just wanted to clarify things
April 18, 2008 at 3:53 am
The code I posted ran fine for me, no errors. Please post the way you're calling the procedure.
QA won't prompt you for parameters like MSAccess does.
April 18, 2008 at 3:21 am
What's the latest backup you have for those databases?
April 18, 2008 at 3:19 am
Viewing 15 posts - 46,846 through 46,860 (of 49,571 total)