SQL 2008 delete statement
I am terribly sorry if this is a duplicate question, but I am having real issues.
Our DB administrator has gone missing in action, and is uncontactable. We have a realtime database which has now outgrown the disc size. I have a limited knowledge of SQL (only out of interests sake) and now i need to trim some old history from the db so the new data can again be enetered.

Can you please, please see if this statement is correct:

Delete from History where UdDate between '01-june-2011 00:00:01' and '30-june-2011 23:59:59'

History is the table, and UdDate is a parameter for filtering the data.

Would this statement be safe to run, and from what I have read I would have to do a shrink on the DB once the delete has completed.

Sorry again, terrible newbie here. 

Thanks for any / all assistance
Best regards

Jesse 

SQL 2008 delete statement
===

I am terribly sorry if this is a duplicate question, but I am having real issues.
Our DB administrator has gone missing in action, and is uncontactable. We have a realtime database which has now outgrown the disc size. I have a limited knowledge of SQL (only out of interests sake) and now i need to trim some old history from the db so the new data can again be enetered.

Can you please, please see if this statement is correct:

Delete from History where UdDate between '01-june-2011 00:00:01' and '30-june-2011 23:59:59'

History is the table, and UdDate is a parameter for filtering the data.

Would this statement be safe to run, and from what I have read I would have to do a shrink on the DB once the delete has completed.

Sorry again, terrible newbie here. 

Thanks for any / all assistance
Best regards

Jesse 
