All you have to do to use my code is figure out how to change "March 2009" to 2009-03-01.

Example, using a yet to be defined function: set @RunDate =...

Roy Ernest (6/19/2009)

---

Tonight our office is arranging a bowling night for everyone. We had to create teams and our team decided to take the name "Jedi Counsel" and they have...

Unrelated maybe, but puzzling. WHERE 1=1?

Allows additional conditions to be added, commented, etc while writing the query. Looks like a testing method so you don't have to worry about...

Change: WHERE poi.DueDate = @TriggerDate

To: WHERE poi.DueDate = dateadd(dd, datediff(dd,0,@TriggerDate),0)

Does that help?

There have been a couple of threads where people have asked for free books, but mostly related to SQL here, not on...

You are asking for performance help, even if you don't know it. I can't tell you one way or the other based solely on your description. The first...

What else changed? Prior to the failure, were you running in a clustered environment or was this a change that was being made moving to a clustered environemnt?

Hard to really say. Please take the time to read the 2^nd article I have referenced in my signature block below reagrding asking for assistance with performance issues. ...

Pretty sure you can setup log shipping using a Standard Edition versions of SQL Server, you just have to do all heavy lifting yourself, no wizards.

Please do not use all CAPS in your posts.

🙂

Does this give you what you are looking for?

Had to add as an attachment.

dh (6/18/2009)

---

I'm trying to insert data from an Oracle table using a linked server into a SQL Server 2005 table, using:

insert into tblDirectory

SELECT

E_ID

,N_ID

...

I rarely drink alcohol. Maybe a wine cooler or two on New Years Eve, else wise our house is relatively dry, by choice.

foscsamuels (6/18/2009)

---

i'm trying to reach the first normal form as described http://www.informit.com/articles/article.aspx?p=30646

i'm trying to figure out how to remove policy number becasue there are multiple questions and answers for each...

ps (6/18/2009)

---

thang_ngo_2002 (6/18/2009)

---

No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we...