My I suggest that you rerun that last query and put the data into an Excel spreadsheet and attach that? I can't tell which values belong to header, and...

Look up maintenance plans in BOL. That is a good place to start.

rsaylors (6/5/2009)

---

Thanks for the replys, I have been going into SQL Studio management and backing up the database and then shrinking it, I have been having to do this once...

GSquared (6/5/2009)

---

declare @Test datetime;

--

select @Test = '6/5/09 1:12 pm';

--

select dateadd(hour, datediff(hour, 0, @Test), 0);

You can use that dateadd(datediff()) method for taking any part of a datetime off. Works very...

This one is simple:

declare @ThisDate datetime;

set @ThisDate = getdate();

select @ThisDate, dateadd(hh, datediff(hh, 0, @ThisDate), 0)

Here is my suggestion at this point, take the code you have been provided, and see if you can make the necessary changes to meet your new requirements. If...

Not really sure how this is going to help you, but based on what you posted, here is an answer as an attachment. Again, I seem to be having...

That is a good one! Thanks for the laugh on slow Friday!...

usman.tanveer (6/5/2009)

---

does that mean, it is not possible to break the Log sequence as...

You don't need to use AWE in the x64 OS/SQL Server environment. You do need to be sure set the maximum amount of memory that SQL Server will use.

Unfortunately anything we might say is simply guess work. You haven't provided us with the DDL for the table (including any indexes if defined), the insert statements you are...

Sounds like your database is using the full recovery model but you aren't doing any transaction log backups. What is your currnet backup strategy?

You could also give sswug.org a try, if you want to pay for membership. They seem to try and cover everything, not just MS SQL Server. They have...

Well, you actually have several problems. One, no select, insert, update, or delete using the CTE. Second, you have a group by query in the CTE with no...

What error? You didn't post the error.