sql server批量修改用户数据库自动增长

sql server批量修改用户数据库自动增长2014-03-14 csdn博客 ocpyangif object_id（'pr_modify_file_add'） is not nulldrop proc pr_modify_file_addgocreate proc pr_modify_file_add@in_name nvarchar（256）asdeclare @d_name varchar（20）set @d_name=@in_nameexecute （'alter database '+@d_name+' modify file（name='+@d_name+', filegrowth=200MB）'）go

declare @databasename nvarchar（256）declare cur01 cursor forselect name from sys.databaseswhere name not in （'master','tempdb','model','msdb','reportserver','ReportServerTempDB'）open cur01fetch next from cur01 into @databasenamewhile @@fetch_status=0beginexec pr_modify_file_add @databasenamefetch next from cur01 into @databasenameendclose cur01deallocate cur01go

if object_id（'pr_modify_file_add_log'） is not nulldrop proc pr_modify_file_add_loggocreate proc pr_modify_file_add_log@in_name nvarchar（256）,@dlog nvarchar（256）asdeclare @d_name nvarchar（20）set @d_name=@in_nameexecute （'alter database '+@d_name+' modify file （name='+@dlog+', filegrowth=400MB）'）go

declare @databasename nvarchar（256）declare @string nvarchar（256）declare @re nvarchar（256）declare cur01 cursor forselect name from sys.databaseswhere name not in （'master','tempdb','model','msdb','reportserver','ReportServerTempDB'）open cur01fetch next from cur01 into @databasenamewhile @@fetch_status=0beginset @string='select @a=name from '+@databasename +'.sys.database_files where type=1'exec sp_executesql @string, N'@a nvarchar（200） output',@re outputexec pr_modify_file_add_log @databasename,@refetch next from cur01 into @databasenameendclose cur01deallocate cur01go