Try running it twice, once with format file and -F 2 (for the data), and once with no format file (or different format file) and -F 1 -L 1 for...

Beyond here https://msdn.microsoft.com/en-us/library/ms188659(v=sql.110).aspx, I don't think you can list fixed server role permissions from with SQL.

I suspect because fixed role permissions are checked slightly differently within some parts of SQL...

([System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()).ServerName

Although won't work if you need more fields from the output of GetDataSources()

chuck.forbes (12/3/2015)

---

In re-reading that post, I realize what a vaguely worded question I asked.

In actuality, I'm looking to gather some experiences on the differences between, for example, granting ...

sqldoubleg (12/3/2015)

---

Gazareth (12/3/2015)

---

Nice article, cheers. Might be worth making the point clear that it's an Enterprise Edition feature, so readers can avoid the crushing disappointment I experienced when trialing it...

Nice article, cheers. Might be worth making the point clear that it's an Enterprise Edition feature, so readers can avoid the crushing disappointment I experienced when trialing it on Standard...

Brandie Tarvin (12/2/2015)

---

Luis Cazares (12/2/2015)

---

Gazareth (12/2/2015)

---

jasona.work (12/2/2015)

---

Hmm...

Here's a way to maybe sort of settle the semi-colon discussion amongst the forum dwellers!

PAINTBALL!

Split into two teams, semi-colon as statement terminators vs semi-colons...

jasona.work (12/2/2015)

---

Hmm...

Here's a way to maybe sort of settle the semi-colon discussion amongst the forum dwellers!

PAINTBALL!

Split into two teams, semi-colon as statement terminators vs semi-colons OK at the start of...

Steve, your feet are conspicuously absent from the last photo. Bit chilly or so relaxed they're just buried in the snow?! 😛

Hi Tim, from what you've described, all I can think that's happening is the application is checking the value of WSID in the connection string and comparing it to the...

This will return the first column from each query, regardless of name:

$FolderPath = 'C:\users\lyonsg\Documents\Scripts\Powershell\HelloWorldTest\'

#Loop through the .sql files and run them

foreach ($filename in get-childitem -path $FolderPath -filter "*.sql" | sort-object)...

The first execution is defining the output object - a column called 'You'. As the second execution doesn't match that output you don't see it in the results.

No alias or...

Great question Hugo & informative answers, cheers.

I answered 1,2, & 3 as I knew 1 and 2 would give syntax errors.

But then I was also thinking all of the above as you should also avoid not...

Nice question Hugo, cheers.

Got 3 out of 4, think it was the important 3 though!