|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: Thursday, March 04, 2010 7:21 AM
Points: 31,
Visits: 79
|
|
Hello,
Just for the fun !
I have an old database (will be probably deleted next month). She contains a table with a non conventional name : dbo.db_log_pt-BR....!!!
With an [EXEC sp_updatestats] on database, all tables are updated. But if I run a [UPDATE STATISTICS dbo.db_log_pt-BR], I'd the message below :
Msg 170, Niveau 15, État 1, Ligne 2
Line 2: Incorrect syntax near '-'.
It's boring because one of my Administration SP use [UPDATE STATISTICS] and I haven't seen this error before 
So my question is how to update this table with using [UPDATE STATISTICS]  ?
Philippe (Bigouden DBA)
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 17,071,
Visits: 12,178
|
|
UPDATE STATISTICS dbo.[db_log_pt-BR]
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Thursday, March 04, 2010 7:21 AM
Points: 31,
Visits: 79
|
|
Just simply and it's work fine.
Thank you very much Gail.
I must to improve my T-SQL practise 
|
|
|
|
