You asked for help, forum etiquette asks that you post your resolution. Others may have a similar problem and seeing how you resolved the problem may help.

I'd also want to see the table DDL, sample data (in a readily consummable format for a cut, paste, and execute in SSMS or QA), expected results based on the...

The first time I mentioned BOL I did spell it out, but I didn't put the TLA along with it. You'll see that if you look at my post...

GilaMonster (6/5/2009)

---

Lynn Pettis (6/5/2009)

---

What I am thinking of doing in the future when I suggest to OP's to read Books Online is to add an additional statement that this is...

Peer-to-Peer replication??

GilaMonster (6/5/2009)

---

Lynn Pettis (6/5/2009)

---

GilaMonster (6/5/2009)

---

He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and...

GilaMonster (6/5/2009)

---

He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and was told to...

I'd also like to suggest this blog entry as well, The Flip Side. It may also provide you with additional insight in how to deal with those of us...

Here is another OMG moment.

I'm not telling you to buy ANY books. Books Online is the SQL Server Help file. While in SSMS, press F1, it will bring it up.

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)