Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How stupid can SQL be?
Message
From
02/04/2019 16:11:15
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01667824
Message ID:
01667842
Views:
52
>Hi Dragan,
>
>For your 'Access denied' issue did you try running SSMS as Admin?

What do you think of me, that I would run SSMS? Not on my box! I'm running toad. And besides, it isn't SSMS that's running the SQL commands, it's the SQL server. That's why "NT Service\MSSQL$SQEX12" has to have the rights to all the folders where SQL server is accessing the files/directories.

>Also, I always click on script button when doing these tasks from the interface and correct the script manually the way I need it.

Exactly what I do (and you wouldn't believe for how many thing you can get scripts in Toad that you can't in SSMS). This time I just replaced the name of the backup file in the existing script which worked before (and the location of the file was same as before). It's just that meanwhile I got a fresh backup made with a newer version of SQL server than the one before.

And, mind you, this is not a "what am I doing wrong" thread, I got it restored within ten minutes. This is just a rant on the stupid and unnecessary steps that SQL made me make.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform