mauriciorpp (2/12/2014)

---

until today, all my "online" index rebuilds worked as expected. but just today I...

Works on Windows 8 with SQL 2012 or 2008 R2:

<# SYNOPSIS

Generates create scripts for all LinkedServers.

DESCRIPTION

PowerShell script using SQL Provider to script out all LinkedServers.

NOTES

Requires: PowerShell Version 2.0, SMO assembly

#>

param...

It could be one of a lot of different reasons. What is the exact error message or behavior you are seeing running on Windows 7?

root

mtassin (12/9/2013)

---

Koen Verbeeck (12/9/2013)

---

Nice article.

One remark though: using SSIS doesn't necessarily mean RBAR.

You can stream the data into a bulk load just fine (as fast as the join) and still...

Framework

Navigator

Abacus

Table

Note that ISDATE() has tons of odd interpretations as well.

For example, '2013' returns as a valid date:

SELECT ISDATE('2013')

Which makes sense if you consider this returns 2013-01-01:

SELECT CAST('2013'...

Jeff Moden (11/21/2013)

---

opc.three (11/20/2013)

---

Jeez, Orlando. If you can't trust an SQL Server Admin or a...

Jeff Moden (11/20/2013)

---

That's just it. There are no security challenges to it. I don't allow users to use xp_CmdShell directly. I don't allow apps to execute it...

Jeff Moden (11/20/2013)

---

opc.three (11/20/2013)

---

Jeff Moden (11/20/2013)

---

opc.three (11/20/2013)

---

Chances are I could accomplish this through a SQLCLR. I could definitely setup an Agent job that a low-priv user could run by executing...

Jeff Moden (11/20/2013)

---

opc.three (11/20/2013)

---

Chances are I could accomplish this through a SQLCLR. I could definitely setup an Agent job that a low-priv user could run by executing a stored proc....

Jeff Moden (11/20/2013)

---

opc.three (11/20/2013)

---

I can think of ways a non-SA could be setup so they could enable xp_cmdshell without the use of a proxy. Your point?

I can think of ways...