Using that option requires that the same user who last saved the package is the one who runs it. ie: somedomain\myusername last saved the package so somedomain\myusername must be the...

I agree, much depends on the contract..

Your data is not open to debate unless the contract says otherwise. It may be their structure but trying to protect structure is...

That can get you some but my experience shows it is anything but exhaustive.

CEWII

You could look at:

http://nclsqlclrfile.codeplex.com/%5B/url%5D

I tend to disable xp_cmdshell..

CEWII

By the error it looks like you tried to use the value as the variable name..

CEWII

Ed,

I largely agree with those statements. You cannot do indexes on a table on a linked server but you can on any local table. Perhaps I misread...

Jeff Moden (12/20/2011)

---

Absolutely wonderful article, Steve.

Concerning the question in the article...

If you had more pride in your employer, wouldn't you be a little more careful in caring for the company...

bobparisi (12/21/2011)

---

Is there a query I can run to identify SQL Server instances in our network envrironment? Would a network admin be required to run?

Beyond that - once SQL...

If you want to read about real world applications of social engineering, read Ghost in the Wires by Kevin Mitnick. This guy would be considered the SUPREME social engineer....

Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they must be materialized and stored very much like a...

I was guessing it was something like this.. As far as SQL is concerned I don't see it being a problem.. The OS should be ok too but...

Their general purpose is to give parameters to a pacakge at run-time.

As for best, that is quite variable. I personally like config files and SQL Server storage, but don't...

I am 99% sure the answer is no.. 32 vs. 64 yes, many different. AMD 32 vs. Intel 32, don't believe so.. AMD 64 vs. Intel 64,...

With an Exec Package you really can't. But that doesn't mean it is impossible. Please look at these articles, they may give you some insights:

http://www.sqlservercentral.com/Authors/Articles/Elliott__Whitlow_/483442/%5B/url%5D

CEWII

Neither windows ftp nor the FTP task will do encrypted tunnels. Whether they be FTP/S or SFTP. You might be able to find a command line FTP/S tool...