Viewing 8 posts - 1 through 8 (of 8 total)
Great Article,
I will make some changes in table, and post here later.
TY for share.
February 8, 2012 at 5:38 am
A small change.. cursor for obtain all schemas and set it to a variable used in method:
SET NOCOUNT ON
DECLARE @CopyFromSchema Varchar(50)
DECLARE @CopyToSchema Varchar(200)
DECLARE @ObjectName Varchar(100)
---- Set...
December 8, 2011 at 11:14 am
Hi,
Great job, I was develop a symilar way, but encounter error whem copy to network drive.
I was set the permissions to everyone, change the user for SQL Agent, try to...
September 28, 2010 at 12:26 pm
Tks a lot Guys.
I use the script and works fine.
Best reggards.
Disney
July 13, 2010 at 7:48 am
Hi.
Great article.
I suggest more references for ISO rules.
Tks a lot.
Disney
May 26, 2010 at 7:45 am
Hi,
Please attempt to "truncate only" is a optional variable.
You make any changes in code for work with SQL 2008.
Try change for "NO_LOG".
Plase, send me your response.
Att.
Disney
May 5, 2010 at 1:33 pm
Hi.. I agree that, but in some situations, you need to use alternatives methods.
I make this script for automate tasks, not for "rule of tomb".
You not need to use...
May 4, 2010 at 11:19 am
Hi.
I´m using all databases listed in master.dbo.sysdatabases.
You already have a sharepoint database in past?
Records in your master database doest´t updated.
Check this.
Disney
May 4, 2010 at 11:15 am
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy