GilaMonster (12/2/2015)

---

Let me guess

You created the database, set the recovery model and then started to test?

Until a database has had a full backup, it runs in pseudo-simple recovery because there's...

Thanks all. I think I will start with learning TSQL since I am just a little weak in that department. 🙂

Finally :-):-)

drop table #test

create table #test (command varchar (500))

insert into #test SELECT 'USE [MASTER] ' + CHAR(13) + 'ALTER DATABASE [' + d.name + N'] '

...

ALTER DATABASE [SSISDB] MODIFY FILE (NAME=N'log', FILEGROWTH = 66000KB)

GO;

ALTER DATABASE [PRODUCT_DB_SSIS_SOURCE] MODIFY FILE (NAME=N'PRODUCT_DB_SSIS_SOURCE_log', FILEGROWTH = 66000KB)

GO;

So when I run this declare @sqlcommand nvarchar (500)

declare CRS cursor

for

select command from...

Update:

Still stuck.

declare @sqlcommand nvarchar (500)

declare CRS cursor

for

select command from #test

open CRS

FETCH NEXT FROM CRS

WHILE @@FETCH_STATUS = 0

begin

set @sqlcommand = N'command from #test'

exec SP_EXECUTESQL @sqlcommand

END

deallocate CRS

So I ran the above script from the central Management servers and inserted all the data into a temp table.

CREATE TABLE #TEST

(SQLQUERY VARCHAR (1000))

INSERT INTO #TEST SELECT 'ALTER DATABASE ['+d.name+']...

JeremyE (11/6/2015)

---

You can run the following with the results to text and it will generate the statements for you.

SELECT 'ALTER DATABASE ['+d.name+'] MODIFY FILE (NAME=N'''+mf.name+''', FILEGROWTH = 10000KB)'+CHAR(13)+'GO'

FROM sys.master_files...

Silly...

Lowell (10/22/2015)

---

i think you have to switch to dynamic sql for an all in one script right?

something like this?

Declare @serverID int,

@Memory int,

@Edition varchar (200),

@Version varchar (200),

@CoreCount int

select @serverID = server_id...

JeremyE (10/21/2015)

---

create table #SVer(ID int, Name sysname, Internal_Value int, Value nvarchar(512))

insert #SVer exec master.dbo.xp_msver

select Internal_Value AS [PhysicalMemory_MB] from #SVer where...

It may work but I don't know. drop table #temp

Create table #temp(

ServerID int,

Memory int,

Edition varchar (200),

Version varchar...

Thanks!

I kinda figured it out

Create table inventory_server(

ServerID int PRIMARY KEY,

Memory int,

Edition varchar(200),

Version varchar(200),

CoreCount int)

Declare @serverID int,

@Memory...

No backup or log backup job is running.

New Testing:

TestDBSize 1.048GB

Rows Inserted 2097152(00:00:09)

Rows Inserted 4194304(00:00:23)

Rows Inserted 8388608(00:00:66)

Rows Inserted 16777216...