Advertisement
Guest User

Untitled

a guest
Jul 28th, 2015
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. Query := '"IF EXISTS(SELECT 1 FROM sys.databases WHERE name = ''DentalDesktop'') BEGIN ALTER DATABASE DentalDesktop SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE DentalDesktop; END"';
  2. Params := '-U ' + sUserName + ' -P ' + sPassword + ' -S ' + server + ' -Q ' + Query;
  3. ShellExec('', 'sqlcmd', Params, '', SW_HIDE, ewWaitUntilTerminated, ResultCode);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement