Ray Herring (12/9/2014)

---

Early in the script (about line 5) you set ToFileOnly = True. Then about 3 lines from the bottom you set the option to False.

is there a...

Brandon Forest (12/8/2014)

---

Thanks for the article. This is something I've been meaning to do for awhile, but have been too wrapped up in other work. Now if someone could...

MG-148046 (12/8/2014)

---

Thanks for the info. Do you know if a message is outputted when an encrypted object is encountered? I currently check for IsEncrypted and write a message to...

My shrink already told me I wouldn't be the only one puzzled with such documentation.

Thank you for the confirmation 😀

Apparently the link to the script disappeared.

So here is the link to my script at OneDrive

Scripting SQL Server databases with SMO

I know Milos has written a number of interesting articles about the new CE and some pitfalls he encountered.

http://milossql.wordpress.com/category/sql-server/

have a look at my little article:

Scope: The drastic caveat with Logon Triggers. [/url]

It will get you on the right track.

Last SQLPass ( summit 2014 ) a twitter conversation popped up mentioning Paul White lost (part of) his voice

......

what connection library are you using?

What's the content of your content file ?

( does it contain the full connection string or just parts of it)

Can you mail the connection string...

Indeed.

If your connection...

the 20 characters limit rings a bell, but only for Reporting Server service accounts !

With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.

http://www.connectionstrings.com/sqlconnection/database-mirroring/

Simple test !

UPDATE A SET rowbefore = rowafter, rowafter = -1 ;

Select * from a order by TableName ;

UPDATE A

SET rowafter = (SELECT max(sysindexes.rows) FROM sysobjects

INNER JOIN sysindexes ON sysobjects.id...

Hurray on the upgrade to SQL2014 !

on the other hand, on top of the suggestions of the other repliers:

Did you ever check any variant of snapshot isolation level to avoid...

did you double check the "slow" instances service account is authorized to use Instant File Initialization ?