Attached excel file? This sounds like homework or someone at the office asking...

That error is typically the kerberos double-hop issue. RDC to the machine in question and try to use the linked server from the local SSMS. If it succeeds...

SQL Injection works because it's sending down direct SQL commands against the interpreter. Because of the nature of it, SQL can't block it because it's meant to send legitimate batches...

Sai Viswanath (6/19/2013)

---

Hi All,

Thanks for the comments, and here's the code that I could get from the SQL Server Profiler when I worked with a report. The tables its...

There are a number of techniques to approach running totals in T-SQL, the most documented of which is the quirky update which is an article and long discussion afterwards by...

Luck Lynn.

Just got back from vacation, Cert, but you're still overthinking this.

First, do proc_1 and proc_2 have the same results? If not, you cannot 'switch' them in an OLEDB source....

I believe you can (as of '05 you could). You have to do it manually though. It can only auto-generate from existing Relational Integrity rules. It's been...

You have what's known as (among other things) a delimited list parameter. As you've noticed, you can't shove it into an IN, it breaks.

The easiest way to do it...

I personally prefer Visio because I can get as detailed or as generic as I like. Also it's what I'm the most comfortable with.

ERWin is another heavily used application...

Hunh?

If I've gotten the...

Huh?

Well, first, you can't loop inside a select statement, so that's out. You CAN subquery, but I'm not sure that'll get you where you're trying to go... well, that's...

If the enemy's gate is down, then why is the Stone Table in the clouds? That just has to break one of the three laws.

If I'm understanding you correctly, you're running into a twofold problem. One of them you can't fix.

First, you cannot use a source in a dataflow that will change its...