brother_of_karamazov
Legendary Poster
If anyone is running 8.12 on SQL Server would you mind running the following query and posting the results? It is important that only those who have not modified their database file configurations post results.
<font class="small">Code:</font><hr /><pre>
use jde_pd812
go
sp_helpfile
go </pre><hr />
Also, if possible, the following section of a file named I:\JDEdwards\E812\MSSQL\ce_create_temp_sps.sql?
<font class="small">Code:</font><hr /><pre> SET @create_string = 'CREATE DATABASE JDE_'+@upathcode+' ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data1'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data1.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data2'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data2.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data3'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data3.mdf'','
SET @create_string = @create_string+ ' SIZE = 500,'
SET @create_string = @create_string+ ' MAXSIZE = 2000,'
SET @create_string = @create_string+ ' FILEGROWTH = 50 )'
SET @create_string = @create_string+ ' LOG ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Log'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'log.ldf'','
SET @create_string = @create_string+ ' SIZE = 200,'
SET @create_string = @create_string+ ' MAXSIZE = 1000,'
SET @create_string = @create_string+ ' FILEGROWTH = 5 )'
</pre><hr />
<font class="small">Code:</font><hr /><pre>
use jde_pd812
go
sp_helpfile
go </pre><hr />
Also, if possible, the following section of a file named I:\JDEdwards\E812\MSSQL\ce_create_temp_sps.sql?
<font class="small">Code:</font><hr /><pre> SET @create_string = 'CREATE DATABASE JDE_'+@upathcode+' ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data1'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data1.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data2'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data2.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data3'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data3.mdf'','
SET @create_string = @create_string+ ' SIZE = 500,'
SET @create_string = @create_string+ ' MAXSIZE = 2000,'
SET @create_string = @create_string+ ' FILEGROWTH = 50 )'
SET @create_string = @create_string+ ' LOG ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Log'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'log.ldf'','
SET @create_string = @create_string+ ' SIZE = 200,'
SET @create_string = @create_string+ ' MAXSIZE = 1000,'
SET @create_string = @create_string+ ' FILEGROWTH = 5 )'
</pre><hr />