Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

OSQL.bat error

2 REPLIES 2
Reply
Message 1 of 3
Anonymous
248 Views, 2 Replies

OSQL.bat error

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>
2 REPLIES 2
Message 2 of 3
Anonymous
in reply to: Anonymous

This message was cancelled from within Mozilla.
Message 3 of 3
Anonymous
in reply to: Anonymous

This message was cancelled from within Mozilla.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report