If you import the text of the XSD definition into a table, you could then use that to dynamically build a "Create XML Schema Collection" command. Look up the...

What that means is you have SSMS 2008, but you're connecting to SQL 2005. The difference is the management software vs the server software.

Very specifically, text, ntext, and image data types in the inserted and deleted tables in triggers don't work. Books Online and MSDN document this behavior.

The way to get around...

Sounds to me like you somehow installed SQL 2005. What do you get if you select @@Version?

Navigate the tree view in the Object Explorer to the proc you want to look at, right-click it, and select Modify.

Not sure what's not working for you.

I just tried this, and it worked:

create proc dbo.XMLTest

as

set nocount on;

select *

from dbo.Numbers

for XML raw, type;

go

create table #T (

ID int identity primary key,

XMLVal XML);

insert...

Have you tried OpenRowset, using the Single_CLOB option?

I'm going to hazard a guess that it's a coincidence.

Or did you have to do anything to the master database?

Of course you...

That data can probably be retreived from the transaction log.

ApexSQL (www.apexsql.com) has a log reader product called Apex SQL Log. You can get a free trial of it.

I have to ask: Why not use the XML data type? Why varchar for XML data?

Here's how you'd do it in T-SQL:

declare @Date datetime;

select @Date = getdate();

select dateadd(week, datediff(week, '12/31/1999', @Date)-1, '12/31/1999');

I picked 31 Dec '99 because that was a Friday. So it finds...

You're welcome.

I'd say the main KPI of a DBA is how much the data in the database(s) is used. It's all about the service provided (value) to the company.

Uptime would...

Plenty of ways to manage that in a child table.

One option (pretty much the default) would be to delete the ones that were unchecked, and leave the rest of the...