If your databases are in one Server I think they are centralized, so if you mean to collect all databases in one ...one of the solution is to organize them...

I'm not sure what you are trying to do, but it doesn't work!

Use something like this

DELETE FROM TABLE

WHERE your_filed = DATEPART(...)

Maybe you can find the required results.

Anyway post the Table...

...and I vote for vstitte's suggestion ... for the TEST environment or maybe any virtual machine!

In the hardware can be problem the memory use, I don't know your hardware components that you have in your server but if you have the large memory environment or...

Thanks for the info!

More...info from Steve or Andy or others...?

Thanks for sharing the article in SSC, Andy! :hehe:

I think for beginning with SQL...

Jeff Moden (12/24/2009)

---

Dugi, thanks for the kudo but it's not mine alone... take a look at the "credits" on that thing... lots of folks had some great ideas that improved...

Jeff really nice job here ...great function!

Once again I retrieve the same results from this statement:

SELECT NAME FROM T-SQL_MASTERS WHERE NAME LIKE 'J%'

The result is;

Jeff Moden - sorry ah!

I agree with you ... if you SELECT NAME FROM T-SQL_MASTERS WHERE NAME LIKE 'J%' you will retrieve the only result Jeff Moden.

First of all your operator here is wrong "=>" it must be >= or <=

So you declared the parameter but you didn't use it!

Check the link in my signature, than you will tell us your problem more clearly!

Maybe in 2011 will come up the new version of the SQL Server, and I don't know, no reason to call it SQL Server 2010 till it comes in 2011!...

...what ever you learn SQL Server 2005 or 2008 will be welcome for you... I recommend to learn SQL Server 2008, it includes also SQL Server 2005 and more than...

Check also this post:

http://www.sqlservercentral.com/Forums/Topic466626-338-1.aspx

Have nice deleting with these two alternatives!

:hehe: