OSQL.bat fails to run properly on vault 2008
osql.exe -S(local)\AUTODESKVAULT -Usa -P"AutodeskVault" -i
UpdateStatistics.sql -o results.txt
NET STOP MSSQL$AUTODESKVAULT
NET START MSSQL$AUTODESKVAULT
Updatestatistics SQL file is as follows:
Use KnowledgeVaultMaster
Exec sp_MSForEachTable 'Update Statistics ? WITH FULLSCAN'
Go
Use Production Vault
Exec sp_MSForEachTable 'Update Statistics ? WITH FULLSCAN'
Go
and I receive an error saying it cannot locate an entry for "Production"
it should be looking for "Production1 Vault"
1> 2> 3> 1> 2> 3> Msg 911, Level 16, State 1, Server SERVER\PRODUCTION
VAULT, Line 1
Could not locate entry in sysdatabases for database 'Production'. No
entry found with that name. Make sure that the name is entered
correctly.
1>