I have contacted the support company who would perform the testing (as I only handle the server/SQL engine and act as first line regarding technical issues).
Doubt I will get...

Many thanks.  I can continue with my plan.

Phil Parkin (3/26/2015)That's exactly what the compatibility level is for, though it does come with downsides: all of the new features in 2014 are turned off for the databases you...

I am late to this discussion but reading with interest. I also see there is no answer/solution yet.

From the description it sounds similar to what we are experiencing with...

I will have a look at those and see if it helps.

If not then I shall post in the forums.

Many thanks

I found powershell v3 very easy to connect to our SQL servers but if you are using SQL 2008 you will also need to install SQL 2012 managament studio to...

Found the link regarding database corruption

http://www.sqlskills.com/blogs/paul/teched-demo-corruptions-fatal-to-dbcc-checkdb/

The second example produces no output if you run integrity 'with no_infomsgs'. Although in this circumstance the database is so corrupt it would be...

That is an interesting output.

Before (sample):

DBCC results for 'xxxx'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 7.

Service Broker Msg 9667,...

Thanks for the link Gazareth.

I have read the article and tried the -Verbose with both lines that did not produce the error.

In both instances of the output was...

Just a thought (I am still learning with Powershell and SQL).

When you run the script in the ISE, are you logged into Windows using an account that is also an...

Many thanks for that.

It must seem like common sense to you but I didn't realize that queries would actually return results with members that can be seperated. ...

Thanks for the question. I need a back to basics style question now and then to ensure I do have the basics.

A good explanation as well for those that got...

Previous to me taking additional DBA tasks, I had been learning C#. Now, I am learning Powershell as well as the DBA roles/tasks.

As for where to learn, there are...

I have been looking at log backups this week so I was glad for this question to confirm what I have been reading and my understanding.

However, there was no mentioning...

Write the code into notepad and save the file with a file extension of .sql

the sqlcmd command will run the contents of the .sql file as though you have typed...