You can't have the same name on the network because of Windows restrictions.

If you want to set up a DR type server you can bring online, then you should restore...

You need schemas. Otherwise how are objects structured? You need roles, in that security should be tested. If you want different security in UAT, then have a script to set...

Do they have the largest stake? Or are they just the largest user? The item they request might not even be in use in the majority of their systems.

This is...

I think the internal snapshot for dbcc is the same process as a "database snapshot" using a sparse file in NTFS, but you don't have control over the placement of...

Miles Neale (8/19/2013)

---

Hi Steve,

I was out last week and came late to the game but needed to add something. Not all apps are .net and not...

Mark Harr (8/19/2013)

---

...Yet when we are users of software products, and it does not do what we expect, or we cannot extend a feature to do something similar but for...

Ed Wagner (8/19/2013)

---

Personally, I think that adding or removing features in a SP only increases the odds of breaking something. SPs are supposed to be safe and fix bugs,...

phickey (8/19/2013)

---

Unfortunately, some companies respond only when the community uproar is so strong they fear its effect on their reputation and sales. Insults (childish or otherwise) are not an...

And another view, somehow timed to come out with mine: http://blogs.lessthandot.com/index.php/ITProfessionals/ProfessionalDevelopment/microsoft-isn-t-the-devil

We've got a bug in there, but someone is looking at it

Koen Verbeeck (8/14/2013)

---

And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)

Now that I'm one of the big boyz and Grant...

Are you sure a log backup didn't run in that 10 minutes? That would explain it.

We do need more information. If you are asking for a trigger to execute when a time is reached or elapsed, that's a job. As noted above, SQL Agent would...

Here's the code I use in demos:

CREATE SEARCH PROPERTY LIST TitleProperties;

GO

ALTER SEARCH PROPERTY LIST TitleProperties

ADD 'Title'

WITH ( PROPERTY_SET_GUID = 'F29F85E0-4FF9-1068-AB91-08002B27B3D9', PROPERTY_INT_ID = 2,

...

I would agree with Gail. Let SQL Server manage this and don't clear your caches.