I want to test, whether a Database with a DBName entered by user already exists in the SQL Server instance.
So I created a simple SQL Server script "USE $DBNAME$"
When I execute this Statement in MS SQL Server Management Studio I correctly get an error message when the database does not exist.
But when I execute this in a "Microsoft SQL Server Script" in IA then I always get a result "SUCCESS".
Also when I execute other scripts (eg. "CREATE DATABASE .." or "CREATE TABLE .. " etc.) I get error Messages in MS Management Studio if those objects already exist; from IA I always get SUCCESS.
(If the objects don't exist then the script is executed correctly and I also get SUCCESS).
-> From IA I can't determine whether an SQL script has been executed correctly or if there were errors on execution.
Am I doing something wrong or missing something ?
Interested in developing new plug-ins? Got one to share? Post here!
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 8 guests