Trigger change worked for me. Thanks!!

This is an old thread, but here is the solution for using a UNC path for anyone searching and finding this:

exec xp_cmdshell 'PushD "\\UNCPath" &&(forfiles /m FileName*.* /d -180 /c...

Thanks Bill! And keep them coming! Well done.

One word of warning, there are plenty that read the articles and never touch the discussions. I[f] the purpose is to get people talking, great. I'd worry about those who...

Bill (DBAOnTheGo) (4/16/2014)

---

Personally I'd like to make sure this is out there. Francis Apel, we do appreciate the article and you writing here. Not everyone will agree and in honesty...

I agree with most of the posts so far, in that clustering can be really tricky to get right, especially on anything under Windows 2008. Windows 2012R2 finally gets it...

William,

Unfortunately, you can't add a Windows 2012R2 node to a Windows 2008R2 cluster. If you could I'd add an 8th reason to my article 😉

I'm not sure there is a...

You are a life saver. Thanks!!!

I would consider Log Shipping to another secondary. This link provide some more detail along with additional links to set it up.

http://technet.microsoft.com/en-us/library/ms189572(v=sql.90).aspx

Hope this helps.

Having a domain is at the heart of cluster installation. You need a domain for the virtual name, for instance. See the install documentation . The very first thing...

The short answer is that a cluster does indeed need to reside in a domain. Are you saying that the domain controllers reside on the SQL Server boxes? The [reside]...

I'm not sure why you would use a script component, when all you should really need is a Flat File Connection / Flat File Source Component and perhaps a Derived...

Seems to me that if you are selling software that requires SQL Server, the logical extension would be for you to do the licensing of SQL Server too, if only...

SANs are a completely different animal. And even the variation in manufacturer and model change the "best practice" of how to lay out your files. The best thing to do...

SELECT referencing_schema_name, referencing_entity_name,

referencing_id, referencing_class_desc, is_caller_dependent

FROM sys.dm_sql_referencing_entities ('YourObject', 'OBJECT');

If you want a recursive lookup, check out this:

http://beyondrelational.com/modules/2/blogs/28/posts/10399/tsql-lab-9-how-to-find-the-dependency-chain-of-a-database-object.aspx