any other files ( besides the log file, as Gail suggested ) ?

burfos (1/9/2015)

---

I haven't on this particular server as the...

Roust_m (1/8/2015)

---

....

The goal is to drop the FKs, truncate some tables and re-create the FKs with nocheck option (this is to keep the database schema almost the same.

Could you spare...

FWIW I hope you enabled Instant File Initialization as it also works for restore operations !

Instant File Initialization and restores[/url]

What's the goal of your action ?

The use of temp objects is fearsome, because - I assume, you'll be dropping and re-creating the DRI in the process. If that fails,...

since this is occasionally, I would suspect the restore process not being the 'single user'.

Can you double check there isn't anything between the 'set single user' and the 'restore database'.

That's...

the deadlock resource is dbid = "10" objectname = "F1SB.dbo.LiveMatches" indexname = "PK_LiveMatches"

that is the object involved in the merge operation as receiving object !

I've seen trancount =3 mentioned ...

you'll have to investigate the object referred by waitresource.

e.g. "KEY: 27:72057594095534080 (989126c604a2)"

and interpret how that resource is being used by the conflicting threads

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.