You need to explicitly create the Credential on the prod instance, and link...

Some options for you in no particular order:

- Use xp_CmdShell to issue a DEL command directly

- Use xp_CmdShell to call a Windows...

Blatant! I love it 😀

Impressive TOC...Chapter 42 alone is worth the coin 😉

shew (8/13/2011)

---

Hmmm. Sounds like that would work for batch jobs, but I would like something that would handle interactive commands too (so I can test in the exact same...

GilaMonster (8/16/2011)

---

opc.three (8/15/2011)

---

I read a post on SSC earlier today, which of course I cannot find now, that talked about the spid in the graph possibly being the deadlock monitoring...

It must be in the water or something...it's funny how somewhat rare items tend to surface in bunches on these forums. I turned on 1222 last week and have had...

Yikes! I read where running an additional trace, to cast a wider net, was sometimes necessary to see what other SQL was participating in a deadlock. I was most certainly...

I am not sure I can solve the issue by changing where PS will look to load a profile script, but I may have a workaround for you. Since this...

Yes, it is worth turning on. What else is running on the server? It sounds like something else may...

CLR can bring a brevity to your code not offered by T-SQL and in some cases can exceed the performance offered by native T-SQL.

Here is one example for a string-concatenation...

YSLGuru (8/11/2011)

---

You see the problem is that the most effeciebt way to process the query is not the same trhoughout our cycle which is a month. Sometimes the query hint...

Use a Script Task.

This is not strictly an SSIS problem. You may have better luck finding examples on .NET/Office-specific programming sites. Google/Bing will be your friend.

MIKEKREIS (8/11/2011)

---

Does anyone know if it is possible to run some VB code (or c# code) through SSIS to make the sheet more "readble"? Like deleting the blank lines, or...

I wonder if Plan Guides would be useful here. Theoretically you could override the plan the Optimizer would use for that specific query text and that plan could be one...

sqlnaive (8/11/2011)

---

Thanks opc. I was going through Policy based management and found it pretty interesting. To solve this default schema issue, is it fine to create a condition with field...