We can restrict linked server access to only specific accounts by using the "Local server login to remote server login mappings" option when setting up security on the linked server...

Peter Trast (1/18/2012)

---

milzs (1/18/2012)

---

I have seven development PCs sitting here at my desk, including a "souped-up" one that cost over $5K. Add in a 21" monitor, a ScanSnap scanner,...

GSquared (1/18/2012)

---

Eric M Russell (1/18/2012)

---

fahey.jonathan (1/18/2012)

---

In most professions, the "tools" do not become obsolete in two years. The screwdriver I made 25 years ago still works in every flathead...

fahey.jonathan (1/18/2012)

---

In most professions, the "tools" do not become obsolete in two years. The screwdriver I made 25 years ago still works in every flathead screw in my house....

There is no reason for an organization to provide employees with both a desktop PC at the office AND a laptop to work remotely. When I work remotely from home,...

In the distant past, I've worked as an employee for small companies where it was expected that everyone would use their own laptop for work, much like a contractor. We...

http://www.surveymonkey.com

Steve Jones - SSC Editor (1/13/2012)

---

ben.mcintyre (1/12/2012)

---

As primarily a c# coder, I emphatically disagree with this proposition.

In fact, being able to compile frequently (any I often do it once every...

Thanks to code completion, I don't think developers today really spend a significant amount of time correcting syntax errors or invalid object references.

I think the old timers back in...

Querying the INFORMATION_SCHEMA views can return columns with definitions that matche search criteria, and then you can also use a similar query to dynamically build other SQL queries against those...

OK, I'll take a stab at interpreting your request...

The thing about querying remote tables, especially when joining remote tables with local tables, is that the performance impact of the SQL coding tequnique is critical. I'm not sure that...

You're saying the query against default trace returned...

Check your server's maintenance plans to see what may have been scheduled.

Also, if there was something like an index rebuild, then a query of the default trace may reveal...

The...