You edited your original post and you've added the closing brackets. Instead you need to remove the brackets. Bellow is the script that I ran with no errors:

declare...

Since you showed us only part of your query without showing the XML, I don’t think that anyone will be able to tell you if you made a mistake in...

I’m sorry but I don’t understand how you split the value 23. According to what you wrote it should be a number between the min_value and max_value, but according...

You have a small typo in your second update statement. You had one extra { sign. Take it out and it will work

Adi

Distinct won’t help because the records are not the same. Each record has a different Skill_ID.

If you don’t care about the skill_id column,...

I also ran it and was surprised to see that that the select query in the second window did not wait until the transaction in the first window will rollback....

If you need to set identity_insert on and off dynamically it means that you don’t know which table you are going to work with and you have to use dynamic...

Perry Whittle (12/24/2008)

---

why act like a couple of little girls. The solution you provided is correct if the question were different. As far as i can see he wanted to...

This might be true, but can you at least explain why it isn't what the OP required? Who...

I'm not sure that I understand what you want. If you want to run a select query and use a stored procedure in the from clause, then you can't...

I usually set this kind of filter in the TextData column. I just write the table's name with wildcards at both sides (e.g. %TableName%).

Adi

You have to be more specific. What don't you know how to do? How to send a parameter to the procedure? How to write a trigger for...

ananda.murugesan (12/22/2008)

---

1. Are you sure that there is no activity on the server? How did you determine that no one modified the data in the past 20 days?

Yes, Actually this...

Paresh Prajapati (12/22/2008)

---

SELECT object_name(object_id), d.*, s.*

FROM sys.dm_db_missing_index_details d

INNER JOIN sys.dm_db_missing_index_groups g

ON d.index_handle = g.index_handle

INNER JOIN sys.dm_db_missing_index_group_stats s

ON g.index_group_handle = s.group_handle

WHERE database_id = db_id()

ORDER BY object_id

This script...

Databases don't grow by it self if they don't need the space. Maybe someone increased the size of the database manually or data was modified and the database didn't...