I wanted to know by not using why

What is that you are trying to achieve?

atramard (12/1/2009)I have put somme dummy file 1Gb that i can delete to release space (Last resort), but that may not work as the log file could still grow,...

dmoldovan (11/30/2009)

---

Also if you do bulk data import / inserts, change the recovery model to "bulk logged" or "simple". BOL will guide you through the steps you need to take...

porwal.naveen (12/1/2009)

---

Though our issue has been resolved, can anyone let me know what exactly caused the problem?

Also I would like to know, is there any alternate way to read excel...

Tried to solve the puzzle, it was...

Have been trying for 1 and 1/2 hour, and I have to say, I give up for now (I don't want to be late / skip my work tomorrow)

As Gail...

richardn-1128243 (11/30/2009)

---

No - not a varchar(8) but it passes a varchar (any size, usually 27), specifically this value '2009-11-30 15:16:43.9270000' and that's when SQL2008 gives the error "Error converting data...

As Lynn has mentioned in his first reply, there is nothing much to suggest since no technical details are presented. Let me make my attempt.

What was the transaction that caused...

What errors have you run into what did that error message describe when searched online?

Have you installed Feature Pack for Microsoft SQL Server 2005.

Only a suggestion to check if...

I searched and found these.

http://forums.mysql.com/%5B/url%5D

http://forums.devshed.com/%5B/url%5D

Jatinear (11/30/2009)

---

Hello Bru,

I'm just chiming in here but you really do need to add more info for this. However, based off what you said, you should do just...

Since the database is larger than the free space available on your drive, the backup is failing. You can include additional file (on a different drive) to be included in...

I hope you all had a fantastic time over the weekend.

Mine was tiresome, I moved into a new...

I understand.

There are more difficult questions than yours, that have been solved by posting some technical details.

I feel you need to use a local variable (something like this)

DECLARE...