Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ostress.exe incorrect syntax #25

Open
aprilcodes opened this issue Jul 6, 2022 · 2 comments
Open

ostress.exe incorrect syntax #25

aprilcodes opened this issue Jul 6, 2022 · 2 comments

Comments

@aprilcodes
Copy link

aprilcodes commented Jul 6, 2022

I'm working through Module 4 and got stuck writing the syntax to run ostress.exe in SSMS. The file sqlworkload.cmd has the following command:

ostress.exe -Saw-server.database.windows.net -itopcustomersales.sql -Ucloudadmin -dAdventureWorks -P -n10 -r2 -q

I have edited it to read:

ostress.exe -Saw-server552557.database.windows.net -itopcustomersales.sql -Ucloudadmin -dAdventureWorks552557 -PmyPassWord -n10 -r2 -q

I get the following error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'Saw'.

I have researched possibilities and find some examples using quotes like -S "servername.domain.net" and other examples using just a space after -S and no quotes. I have edited various ways but do not see the solution. Any help will be appreciated.

@aprilcodes
Copy link
Author

If it's due to the second dash in -Saw-server552557... then I need to escape that character. I have tried a backtick and backslash, also some variations of N', but this did not solve it.

@rgward
Copy link
Member

rgward commented Jan 24, 2023

I'm sorry I'm now just seeing this. How are you executing this? Through Powershell. I just tried this example and it worked without any need for quotes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants