Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Curious Case of .. Syntax Error. Or may be not? Expand / Collapse
Author
Message
Posted Sunday, May 26, 2013 2:30 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:23 PM
Points: 424, Visits: 1,549
Actually I did this already- when yesterday night SP returned error I rerun it again (same indexes) with Print only (no execute)- no errors, all printed statements looks good (no '(')
This is the reason I called- Curious Case

Anyhow, thanks for help
Post #1456918
Posted Sunday, May 26, 2013 5:05 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 42,443, Visits: 35,498
Can you post all the printed statements?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1456930
Posted Sunday, May 26, 2013 9:12 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:23 PM
Points: 424, Visits: 1,549
Seems I do not need to post all 82 statements as while preparing them and carefully reading one after one I found 2 indexes (same DB and table- probably same creator) with names like :
"ind1 (Non-Unique, Non-Clustered)" and "ind2 (Non-Unique, Non-Clustered)".
No comments
My bad- I did not find them till today.
As I found they were ReBuilt/ReOrganized every week- therefore SP failed every week run
(as these 2 indexes somewhere in the middle of total index list looks like sql failed on them keeping in mind error, proceeded with other indexes but at the very end returned this error)

Anyhow I renamed these 2 indexes (removing "(Non-Unique, Non-Clustered)" from name) and hope next run everything should be fine

Thanks everybody for help (as always)
Post #1456955
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse