GilaMonster (8/15/2009)

---

Jeffrey Williams (8/15/2009)

---

And to further what Gail has stated - in SQL Server 2005, the passwords for SQL authenticated accounts will use the servers password policies by default. ...

DATEDIFF(day, '20070101', '20090101')

And to further what Gail has stated - in SQL Server 2005, the passwords for SQL authenticated accounts will use the servers password policies by default. That is, if...

If you're up for a little drive - just north on I-15 is Temecula Wine Country. Plenty of wineries to visit if you like that kind of thing.

Mind you,...

sql server developer (8/12/2009)

---

Hi,

I have a table from which I need to delete duplicate records. I dont have identity col and i cannot add identity col. For that i've used...

zuma01 (8/14/2009)

---

Ok, thanks guys I have implemented this and put the 3GB switch in the boot.ini for good measure.

Seems to be running better but the PF usage in Task Manager...

The maintenance cleanup task expects the extension without the period. If you put the period in, it will not remove any files.

Also, make sure you have selected the right...

zuma01 (8/14/2009)

---

Hi

Sorry it is SQL 2005 Standard Edition. I havn't ticked the AWE box, is it just a case of doing that ? will that help?

I can post the...

nigelc (8/14/2009)

---

Why is it then then when i do a back up of the log that the back up is about the size of the log but the log has...

htt (8/13/2009)

---

This is NOT always true. Couple of my...

nigelc (8/13/2009)

---

One thing i didn't get an answer on is. When the full back up runs is it backing up both data files as the DB is spread over two...

htt (8/13/2009)

---

Okay, here is a scenario for you.

At 12:10 PM Wednesday afternoon your server crashes and corrrupts your database forcing a restore. You attempt to restore from the full backup...

Maria Smith (8/13/2009)

---

Thanks for all the replies so far

What I want to know is if the current D drive is blown away (after full backup has completed and been verified)...

shannonjk (8/13/2009)

---

Awesome thanks Jeffrey. And I guess since you are a SSC Crazy you would know :).

I do admit I need to research more on recovery models, back ups...

eric (8/13/2009)

---

Thanks a lot Jeffrey. I'll have to read that again tomorrow morning and look into it. I like the idea of keeping more than one full backup...