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...

please try and make your posts a little more readable , otherwise it takes us twice as long

as far as i can make out this is what you want

what you...

i also thought i might add - i've seen the strategy of taking SAN snapshots before. the particular client of ours was keeping a record of the data churn so...

i don't beleive this is possible at all

to restore a database to point in time (or alternatly restoring t-logs while in full recovery mode) the database needs to be in...

http://books.google.co.uk/books?id=fx4JM99vKZ8C&pg=PA53&lpg=PA53&dq=state_desc:+DISCONNECTED_INBOUND&source=bl&ots=IpRTThulJv&sig=1N3DXono1r6jUCnNMQIPrFbPZ6s&hl=en&sa=X&ei=tWC2T6zYM8TbsgbD-6GXCA&ved=0CFMQ6AEwBQ#v=onepage&q=state_desc%3A%20DISCONNECTED_INBOUND&f=false

oh - also

the state of those conversations

state_desc: DISCONNECTED_INBOUND

i think (and i may be incorrect) that the initiator of the conversation is not closing the conversation - which is...

bingo - here is your problem

your service broker conversations are not being closed, this puts memory pressure on and forcessql to dump these to tempdb - sql does not know...