I need the OP and those who have successfully executed a job over a linked server to get your linked server configurations and post them here. Maybe something is...

Jeff Moden (12/21/2012)

---

Josh Ashwood (12/20/2012)

---

haha *=

Now that is real dinosaur stuff!!

Can...

Actual execution plan? I could look at that tonight or over the weekend.

David92595 (12/21/2012)

---

@SSCoach

Can you please provide a resource that shows that full backups do not truncate transation logs? I was under the impression that a full backup does truncate the...

David92595 (12/21/2012)

---

yes, we are running in comparison to most sql database a rather small and staic database. I was told that a full backup once a day was...

To paraphrase the problem originally posted. I have a parameter @MyParameter in a stored procedure that is defined, for example, as varchar(100). Occasionally the string value being passed...

Eugene Elutin (12/21/2012)

---

If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into table inside...

pdanes (12/21/2012)

---

That what I said, I think. This string:

'1E,D,E,Es,F,Fs,G,Gs,H,Hs,J,K,Ks,L,Ls,Lc,M,Me,N,Ns,O,Os,Ob,Oc,P,Ps,Pa,Pb,Pc,R,Ra,S,Ss,Sb,Sc,T,Ts,Ta,Tb,Tc,Ua,Ub,Uc,Va,Z,Zs'

Would instead get passed as a...

Have you checked the SQL Server logs for errors? Is the report auto generated, if so, can you run it manually?

The Championship is on the line this weekend! The SQL Bolts are currently a 7.4 favorite to win over the SSC Steelers. Can they do it, can the...

SQLRNNR (12/20/2012)

---

Lynn Pettis (12/20/2012)

---

And then some one else posts this in the same forum thread I reported:

JeffRush (12/19/2012)

---

I almost have more respect for spam, as it usually at least tries...

And then some one else posts this in the same forum thread I reported:

JeffRush (12/19/2012)

---

I almost have more respect for spam, as it usually at least tries to fit in....

Wow, first time for everything. I report a post as spam and the person who posted it PM's me saying that the post wasn't spam.

Merry Christmas and Happy New Year to ALL!

Duplicate post, please post all replies here.