On SQL 2005 your only option is to check each :angry:

If you have an instance of SQL 2012 around it can be used to identify the bad XML using the...

phil.layzell (5/8/2012)

---

Hi everyone,

I am due to make a change to our 2005 Production DB. This change involves updating a Text field to XML.

The questions are:

•what impact will this have on...

sys.dm_db_index_physical_stats, yes. If you dig into Ola's process you'll see that's what he uses, and it the primary data source available for index stats. To pick a nit, it is...

In general then, sys.dm_db_index_physical_stats should be used only during times of otherwise low system usage.

You're questions are always interesting pamozer!

Which tables? sys.objects and sys.indexes are views. Are you wondering about the system...

From sp_changedbowner (SQL Server 2008 R2)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify...

It is advisable to create a Database ROLE, add the USER to the ROLE, and GRANT the permission to the ROLE. Try to avoid granting permissions directly to Users wherever...

hedlund_peter (5/8/2012)

---

Thanks for your answer!!

I get 14420 and 14421 error messages.

The database is bigger than 1TB.

What do you mean by sort out? Do you mean get it running again?

I would...

PowerShell + WMI works well for this type of work.

SSIS does not handle embedded column delimiters, row delimiters or text qualifiers the same way DTS does. If memory serves the difference resides in the way the SSIS Flat File...

Have you tried looking in Books Online, or using a search engine? Many of the topics you mention have already been covered at great length.

I would go with SQL Express. It's free and can be used as a replication subscriber, and will handle locking infinitely better than a writer (replication) and a reader (your...

Quickest would likely be to sort out your sync issue. Where are the logs? Do you have any confidence in being able to get back on track without rebuilding? How...

From The Clustered Index Debate Continues... by Kim Tripp

The first and most important point to stress is that minimizing page splits is NOT the only reason nor is it the...

I highly doubt any of the commonly available OLE DB Providers for Text Files will work for this. Replication support for Jet, which can connect to text files but its...