I'm less disappointed in the quality of questions than with the lethargy in replying.

Sometimes, and I've been there myself, due to work pressures, it is often quicker to post a...

can you change the location of the data that the view is referring to?

Even adding a task to move the data and then apply the amended view to test if...

like previous user mentioned, db mail is very reliable once configured.

99% of the time, when a failure occurs, it is due to a change in Exchange, Firewall or, rarely, Port...

Developed an older BI system on 2005/2008 but have started from scratch on 2014.

There will be very little if any difference between 2012 and 2014, so whatever is established for...

have used a coupe of techniques for this:

1. VBA in Excel including a refresh parameter which polls database for results

2. SQL Server Reporting Services which has a refresh parameter built...

you can use SQL string functions (Left, Right, Substring) to split out "date" parts.

Then can concatenate and apply a "cast ... as datetime" clause.

Always worked for me.

You can use either Project or Package deployment mode.

Each sub-"package" within the solution must be the same type.

Recommendation is to use Project, which I use only, as there are certain...

sp_helptext

set statistics io on

set statistics time on

dbcc checkdb

set transaction isolation level read uncommitted

Hi,

So, an update and a little clarification.

Firstly, I think SPN is a red herring here - servers are configured correctly with no comm issue; no additional changes made.

Secondly, regarding auditing,...

Thanks. By "rebuilding indexes" do you mean clustered or non-clustered, or would new plan be created regardless of number or type of index?

Perry,

There are no SPNs set up and Kerberos is not enabled on SQL Server. The auth_scheme = SQL.

I've never had to use a SPN, so my thinking was it is...

ok so after reinstall of SQL Server 2014 SP1 I reattached dBs from MDF/LDF files and most databases were fine.

Sadly, one database originally showing as Suspect was no longer in...

Yeah thanks Grant/SQLNRR/Jeff - actually I have downloaded a copy of SQL 2014 Dev inc SP1 and will try to install and connect from there.

Will let you know if any...

Hi Grant, I have a bit more information.

It would appear that in the confusion of installing and uninstalling that there is now no SQL Server service running !!!

See atttached screenshot...

Would really appreciate your expertise on this Grant.

I'm now thinking should I run the Setup GUI for SQL 2014 and run the Repair option?

What are my options?

Are there any remote...