Don't know if this is due to the formatting of the XML...if I strip out a whole bunch of stuff from the XML and use the attached XML your code...

Read the article: http://www.sqlservercentral.com/articles/Best+Practices/61537/ for information on how to post data/code that will get you better assistance in answering your query

And it looks like your query still didn't paste properly...

I think my brain is tired - I have come up with the code below which might nor might not help you...I'm pretty sure there's a much better way to...

Can you attach the XML file so that we can have a look at it? You'll need to attach it as cut-pasting XML in forum posts doesn't work.

You can use the sys.dm_sql_referencing_entities dmv to get information on entities that are referencing your table

for e.g.

USE msdb

SELECT * FROM sys.dm_sql_referencing_entities('dbo.sysmail_mailitems','OBJECT')

I wouldn't say it is "always" better to store data in tables instead of using XML - it depends on the data and the application.

In your case you could follow...

If you are going to be searching the XML then I'd suggest store it as XML - i.e. create an XML datatype column and store the XML in that column.

It's...

Do a "PRINT @sql" before you execute it and check the printed value to locate the error.

Sander - what is the initial size of your tempdb datafiles? And what is the autogrowth of these files set to?Maybe the size is set to 30GB and that is...

You can't have a CASE in the join statement as that syntax is invalid

I'm assuming you want to join from one table (call this TableA) to different tables (call these...

"I wanna know how can i transfer the data from the first table to the second, when the value is 0 send the value to the 2nd and 3rd column...

You could always check on the columns in the inserted table in the trigger (a special table created by SQL Server that holds copies of affected rows during insert -...

The sysschedules table in the msdb database has a column "enabled" which will let you know if a job schedule is enabled or not...

However - the recommended way is to...

You can check the system tables in the msdb database - sysjobactivity and sysjobhistory...

you should be able to get information on current job activity and status from sysjobactivity and information...

Check this article for lots of information on how to use arrays in SQL Server: http://www.sommarskog.se/arrays-in-sql-2005.html