Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How stupid can SQL be?
Message
De
02/04/2019 16:11:15
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01667824
Message ID:
01667842
Vues:
53
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform