# SQL Server Database Build
**URL:** https://www.finalbuilder.com/forums/t/sql-server-database-build/1040
**Category:** Discussion
**Created:** [November 20, 2008, 3:15am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040 "2008-11-20T03:15:00Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [November 20, 2008, 3:15am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/1 "2008-11-20T03:15:00Z")
All,
I'm trying to figure out how to use FB to manage a set of database that have frequent changes and promotion cycles. I have some ideas, but I would really like to see an example where a set of stored procedures stored in a directory in VSS or TFS get dynamically loaded in a stack (or the like) and then get executed.
Anyone else out there using FB for something like this.
Sean
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [December 10, 2008, 10:03am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/2 "2008-12-10T10:03:20Z")
Same here. I need to execute SQL Server 2008 SQL DML scripts such as “CREATE DATABASE …” via FinalBuilder. These scripts run fine in SQL Server Managemenet Studio 2008 queries. They run fine as Stored Procedures in the Master database (a very bad idea). But they do not work from a FB [ADO.NET](http://ADO.NET) Execute SQL task as either text or file, which is what we need to do.
Could someone from VSoft help us out here, thanks…
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [December 10, 2008, 11:52am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/3 "2008-12-10T11:52:08Z")
Hi,
Their shouldn’t be a problem with running DDL (CREATE, ALTER, DROP, etc…) scripts from the either the ‘ADO Execute SQL’ or the ‘MSSQL Execute SQL’ actions. Does the action report an error, or does the table never get created?
Could you provide us with the exact query you’re attempting to execute, as well as the connection string being used (removing any sensitive information first)? If you’d prefer you can email it to support [at] [finalbuilder.com](http://finalbuilder.com) instead of posting on the public forums.
Regards,
Paul.
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [December 11, 2008, 12:58pm UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/4 "2008-12-11T12:58:28Z")
Doesn't seem to parse...
"Error expanding SQL Text : Missing % after"
-------------------------------------------------------------------------------------------------------------------------
use master
go
CREATE DATABASE [test\_design1] ON PRIMARY
( NAME = N'test\_design1', FILENAME = N'E:\MSSQL10.MSSQLSERVER\MSSQL\DATA\test\_design1.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'test\_design1\_log', FILENAME = N'E:\MSSQL10.MSSQLSERVER\MSSQL\DATA\test\_design1\_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [test\_design1] SET COMPATIBILITY\_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [test\_design1].[dbo].[sp\_fulltext\_database] @action = 'enable'
end
GO
ALTER DATABASE [test\_design1] SET ANSI\_NULL\_DEFAULT OFF
GO
ALTER DATABASE [test\_design1] SET ANSI\_NULLS OFF
GO
ALTER DATABASE [test\_design1] SET ANSI\_PADDING OFF
GO
ALTER DATABASE [test\_design1] SET ANSI\_WARNINGS OFF
GO
ALTER DATABASE [test\_design1] SET ARITHABORT OFF
GO
ALTER DATABASE [test\_design1] SET AUTO\_CLOSE OFF
GO
ALTER DATABASE [test\_design1] SET AUTO\_CREATE\_STATISTICS ON
GO
ALTER DATABASE [test\_design1] SET AUTO\_SHRINK OFF
GO
ALTER DATABASE [test\_design1] SET AUTO\_UPDATE\_STATISTICS ON
GO
ALTER DATABASE [test\_design1] SET CURSOR\_CLOSE\_ON\_COMMIT OFF
GO
ALTER DATABASE [test\_design1] SET CURSOR\_DEFAULT GLOBAL
GO
ALTER DATABASE [test\_design1] SET CONCAT\_NULL\_YIELDS\_NULL OFF
GO
ALTER DATABASE [test\_design1] SET NUMERIC\_ROUNDABORT OFF
GO
ALTER DATABASE [test\_design1] SET QUOTED\_IDENTIFIER OFF
GO
ALTER DATABASE [test\_design1] SET RECURSIVE\_TRIGGERS OFF
GO
ALTER DATABASE [test\_design1] SET DISABLE\_BROKER
GO
ALTER DATABASE [test\_design1] SET AUTO\_UPDATE\_STATISTICS\_ASYNC OFF
GO
ALTER DATABASE [test\_design1] SET DATE\_CORRELATION\_OPTIMIZATION OFF
GO
ALTER DATABASE [test\_design1] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [test\_design1] SET ALLOW\_SNAPSHOT\_ISOLATION OFF
GO
ALTER DATABASE [test\_design1] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [test\_design1] SET READ\_COMMITTED\_SNAPSHOT OFF
GO
ALTER DATABASE [test\_design1] SET HONOR\_BROKER\_PRIORITY OFF
GO
ALTER DATABASE [test\_design1] SET READ\_WRITE
GO
ALTER DATABASE [test\_design1] SET RECOVERY FULL
GO
ALTER DATABASE [test\_design1] SET MULTI\_USER
GO
ALTER DATABASE [test\_design1] SET PAGE\_VERIFY CHECKSUM
GO
ALTER DATABASE [test\_design1] SET DB\_CHAINING OFF
GO
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [December 11, 2008, 1:09am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/5 "2008-12-11T01:09:35Z")
Hi,
You’ll need to escape the % in the query so that FinalBuilder doesn’t attempt to expand it , I.E:
Change "FILEGROWTH = 10%) "
To "FILEGROWTH = 10%%) "
Regards,
Paul.
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [December 11, 2008, 1:37am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/6 "2008-12-11T01:37:44Z")
Thanks…
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [December 11, 2008, 2:23am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/7 "2008-12-11T02:23:45Z")
Well, that didn’t fix it as it turns out. Now just getting the ubiquitous “Error " Incorrect syntax near ‘go’” …
---
### Author:  [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [December 11, 2008, 3:26am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/8 "2008-12-11T03:26:06Z")
The ‘GO’ separators are not actually valid T-SQL, you’ll either need to separate each command out and execute them one-by-one in the ‘ADO Execute Query’ action, or you can use the ‘MSSQL Execute Query’ with SQLCMD which will handle the batch processing automatically.
---
### Author:  [@rafael](https://www.finalbuilder.com/forums/u/rafael)
#### Post date: [December 22, 2008, 8:39am UTC](https://www.finalbuilder.com/forums/t/sql-server-database-build/1040/9 "2008-12-22T08:39:47Z")
> Posted By Paul Samways on 10 Dec 2008 08:26 PM
> The 'GO' separators are not actually valid T-SQL
>
Right. GO is what the client (SQL Studio or whatever) uses to separate commands. It is plastic, and client configurable.
(That said, FB could be set up to emulate SQL Studio in that respect... I know we had a similar need at one point and coded it ourselves in our client.)