Curious how you would use a subroutine in T-SQL. Can you show an example of how this would work if it were possible?

How is the code being used, in a stored procedure?

ifila (1/14/2010)

---

david.tyler (1/14/2010)

---

I wouldn't waste time on clowns that are obviously not professionals. This site houses professionals helping other professionals. There are professionals with varying levels of experience and then...

ifila (1/14/2010)

---

A few months ago, a forum member suggested reducing the size of the email fields from 1000 to something more reasonable.

So i created a TestDB that is an exact...

jferrel-1093506 (1/14/2010)

---

True Lynn, I have not read much else on SSC.... but as disgusted as he is about customer support, I can equate that to me having to wade through...

Aw, yes, professionalism at work.

jferrel-1093506 (1/14/2010)

---

I get a SQL ServerCentral.com about once every week or so, but never read it.

Then I read this because of the catchy title, and its a rant about a...

CirquedeSQLeil (1/14/2010)

---

Not being certain that I have the same FTI and catalog as yours, I was able to gain substantial improvement just by adding a Non-Clustered index to the currentdateout...

Hmm, Impressed a lurker we did.

CirquedeSQLeil (1/14/2010)

---

Alvin Ramard (1/14/2010)

---

Steve Jones - Editor (1/14/2010)

---

So, anyone want to bet what will happen with my laptop? Already had a SSC member that works for Toshiba ping me. I...

Now I'll plug HyperBac. I like HyperBac because it works in the background, no changes are needed to existing processes. We still use the T-SQL native backup/restore commands....

Steve Jones - Editor (1/14/2010)

---

Valerie Jones-467993 (1/14/2010)

---

I gave up on all major computer companies years ago and have mine built to spec by a local company. Once when an...

bwillsie-842793 (1/14/2010)

---

Went from local branch admin > local manager > corporate mortgage manager > calls to pull mortgage broker out of a conference > mortgage approved and details sent to...

Hot linked for those who don't like to copy/paste:

http://aspalliance.com/1167_A_StepbyStep_Approach_to_Creating_a_Web_Service_Task_Using_SQL_Server_Integration_Services.all

http://www.codeproject.com/KB/database/webservicessis.aspx

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61360/

http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html

Here is my suggestion, if you are going to look into a third party backup tool, get evaluation versions of all of them, test them out, compare them side by...