Hi Steve,

I would like to correct a few minor typos in the article before it is published. Given that it has been scheduled for publication can I modify the article...

For what it's worth this PowerShell:

$v = [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO')

$v.FullName

$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') ".\SQL2012"

$bkup = $s.Settings.BackupDirectory

$bkup

Yielded this output on my machine:

And yields this T-SQL when pointed...

When I evaluated enterprise job schedulers I evaluated at least 10 products on at least 20...

Jeff Moden (6/24/2012)

---

matthieu178 (6/24/2012)

---

Hi firt of all thanks for the answers.

Indeed I'm using the sp startjob.

Unfortunately I don't have much knowledge in .net programming either, even with powershell commandlets.

For the...

matthieu178 (6/24/2012)

---

Hi firt of all thanks for the answers.

Indeed I'm using the sp startjob.

Unfortunately I don't have much knowledge in .net programming either, even with powershell commandlets.

For the second question...

Invoke-SqlCmd is good for issuing commands, but not necessarily for interacting with the database iteratively.

For that you'll be better off using the .Net SqlClient classes from PowerShell.

Here is an...

BenWard (6/21/2012)

---

Hi Guys,

just a quick one, I'm extracting data to a CSV for an accounts reconciliation and really would like the extract part of it to be coded in the...

Might I recommend a shift in approach. In my opinion Log Shipping (LS) is better suited for this kind of work given that it is transactionally consistent. This property translates...

vs.satheesh (6/22/2012)

---

Thank You . I am getting same error. but time being i am solved to change the server STATE . but i will do that certificate .

Any Problem in...

What are you using within your PowerShell script to invoke the Maintenance Plan? DTExec.exe? If so, then generically the question becomes "how do I capture the return code when calling...

Jeff Moden (6/22/2012)

---

opc.three (6/20/2012)

---

Jeff Moden (6/19/2012)

---

Just a recommendation. I've found that using SET STATISTICS when a scalar or multi-line table valued UDF is involved will cause the UDF to...

OK, I am thinking you are seeing this error:

By default, users cannot select from...

minorgm (6/21/2012)

---

Hi everyone

I have a DB with objects belong dbo schema and user1 schema( dbo.table1, dbo.table2, user1.table1, user1.table2, etc) , when I login with sa, of course, I can see...

There are many reasons why the debugger may not start for you. The most common one is that your Server Login is not in the sysadmin Fixed Server Role. Do...

clayman (6/21/2012)

---

Thanks.

I'm aware of this but.. What I'm trying to achieve here is to avoid hard coded paths so that SP would be more...