looking at that you definatly have a couple of DB that are in simple (WRHL for one) and that will cause that statement to potentially fail..

i think you should really...

pjl0808 (5/21/2012)

---

Hi all,

I need to remove an older table (article) from a publication and add a new table back in using 'exec sp_addarticle'.

The new table is Very large and is...

shani19831 (5/21/2012)

---

Hi guys

I'm having trouble on finding out what causing this error on one of out sql servers.

Date: 5/21/2012 Source: MSSQLSERVER

Time: 3:00:00 AM Category (6)

Type: Error Event ID 17055

User: NT...

i'd be tempted to build a small loop (pseudo code below)

while records affected>0

begin

merge oldest record for each widget

remove oldest records from staging for each widget

end

in that...

Schadenfreude-Mei (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls...

jparenzee (5/21/2012)

---

Hi ,

Im a newbie to the world of report building and BIDS in particular.

I need assistance - I need to illustrate a breakdown in charging time of a battery...

well the float data type definatly looks wrong to me - int looks better, but that is beside the point.

have you closed the excel file correctly before you run the...

why would dbmail be an issue in an import routine?

does the table $Sheet1 get created? if so does it need to be deleted before you can run the import?

is it...

are you sure somebody isn't pulling your leg and making you look silly ? - this sounds like an april fools joke

does the beep have to occur when you open...

carthik (5/21/2012)

---

Hi,

I need to know if a word is avaiable in a comma seperatred text

suppose a value in table1 is 'ram'

i need to know if 'ram' is available in...

Abrar Ahmad_ (5/21/2012)

---

[font="Verdana"]Hi folks,

Do we can assume that the Cloud Computing is a threat to conventional RDBMS, especially for the field of database developers? Because of the software development concepts...

might be worth adding in a backup database command at the end - you've set the db back to FULL recovery, so any t-log backups will proboably fail until you...

Eugene Elutin (5/21/2012)

---

michael vessey (5/21/2012)

---

are you taking the mick ? i think you ned to buy a...

are you taking the mick ? i think you ned to buy a new watch if you...

just to clarify about being more precise

did you mean when event_value="merge"

this would be a much...