Have you attempted to re-associate the file type via windows explorer? Right-click the *.sql file in windows explorer and select properties. Click the change button under opens with and browse...

Hi Dave,

There are a number of ways to ago about this; extended events, etc. You might want to check out the extended event project on CodePlex (http://www.codeplex.com/ExtendedEventManager). If your looking...

If I understand your question correctly, you are looking for something like:

declare @xml xml

set @xml = N'

<Root>

<LineItem>

<LineItemReference>30048</LineItemReference>

</LineItem>

<LineItem>

<LineItemReference>30049</LineItemReference>

</LineItem>

</Root>'

select LineItems.LineItem.value(

...

SHRINKFILE works in transactions of 32 pages - post by CSS which offers some good insight -

http://blogs.msdn.com/psssql/archive/2008/03/28/how-it-works-sql-server-2005-dbcc-shrink-may-take-longer-than-sql-server-2000.aspx

BOL indicates 2005 express edition is supported w/ 2008 -

http://msdn.microsoft.com/en-us/library/ms175191.aspx

I came across this on social - may offer some assistance in troubleshooting the issue -

http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/611d4c49-c37e-42de-b1e0-7db7ece718f5

G33kKahuna (12/3/2009)

---

Jacek's article was debate worthy. I believe he and I don't see eye to eye on the evaluation approach .......

G33kKahuna (12/2/2009)

---

Tommy,

Which part of my response...

G33kKahuna (12/2/2009)

---

On the contrary, in combination w/ avg reads, avg writes, and avg CPU this information can tell a very good story. The point being that ClearTrace like any commercial...

JacekO (12/2/2009)

---

Tommy,

Thanks for stepping in in defence of the article. I am very pleased someone found it useful.

Fortunately this is an open forum so everyone can express their opinions. It...

G33kKahuna (12/1/2009)

---

Yes it is ...

1. If you are...

david.murden (12/1/2009)

---

Hi Jacek0,

I might be being a cabbage but i have never seen :: used as a prefix to a join or anywhere else in sql actually. I had a...

Thank you. I prepared for this exam using the The Real MCTS SQL Server 2008 Exam 70-432 Prep...

Thank you Jeff 🙂

Tommy Bollhofer (9/21/2009)

---

Tommy Bollhofer (9/20/2009)

---

dlucas-615847 (9/19/2009)

---

When I try to creat this stored procedure, I get two syntax errors:

Msg 102, Level 15, State 1, Procedure usp_maintain_database_log, Line 107

Incorrect syntax near '?'.

Msg...

Tommy Bollhofer (9/20/2009)

---

dlucas-615847 (9/19/2009)

---

When I try to creat this stored procedure, I get two syntax errors:

Msg 102, Level 15, State 1, Procedure usp_maintain_database_log, Line 107

Incorrect syntax near '?'.

Msg 102, Level...