TRACEY-320982 (7/30/2011)

---

If it takes that amount of space and there more than one statement in a sp then issue a backup statement in between to backup the log provided you...

Attopeu (7/29/2011)

---

I can confirm there is no parameter sniffings because I do not change paramters when calling the proc but I call proc with same parameters multiple times. Also, i...

There's not much to discuss here. Converting to char takes hours while int takes seconds. The server has already answered your question.

The difference is that one uses an...

... stil not the correct way to code this if this is the case. 😉

Why do you want to do that? Triggers are supposed to be at table (or view) level, not only 1 statement. Why not keep going in the...

Chrissy321 (7/29/2011)

---

From my license agreement.

Subscriber agrees that it shall not reverse engineer, disassemble, decompile or otherwise attempt to derive the source code of the software provided hereunder.

I think I would...

yes you'll be able to connect to that server from another install of ssms.

This should get you started :

http://msdn.microsoft.com/en-us/library/ms187743.aspx

Chrissy321 (7/29/2011)

---

The vendor proc is encrypted. I know there are ways around that but I am somewhat reluctant.

The proc also accepts a date range ( I was simplifying in my...

--code to load the data.

--code to update the data.

Trigger is completely useless there.

opc.three (7/29/2011)

---

Cool, that must explain the French in the images of dialog boxes in your posts. I wish I was in NY right now...I am going to get a slice...

Matt Miller (#4) (7/29/2011)

---

Flipping the question around: other than seeing your...

Montréal (New-York).

opc.three (7/29/2011)

---

Lowell (7/29/2011)

---

i'd step completely outside of SQL server and write something in a programming language instead.

trying to do everything from within SQL is the old "Everything is a...

You're right, it makes no sense shrinking the logs.

Please read through BOTH those articles.

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

http://www.sqlservercentral.com/articles/64582/