bdkdavid (3/24/2016)

---

That was a good thought!

SELECT LastName FROM DT5

WHERE CHARINDEX(CHAR(151), LastName) > 0

no results

SELECT LastName FROM DT5

WHERE CHARINDEX(CHAR(150), LastName) > 0

no results

SELECT LastName FROM DT5

...

there's at least two other longer than normal hyphens that has a different ascii code than the "normal hyphen ASCII('-')=45,without even going into nvarchar data sets.

i'm betting it's one of...

ok, i'm going through the same issue as well, we have two domains with two way trusts.

the network guys tell me it's not possible to change our existing group...

Jason Strates article lists missing indexes along with usecounts, costs, etc.

i'd start there and enhance as needed.

http://sqlmag.com/blog/missing-indexes-correlated-against-execution-costs-and-counts

othercolumns ...include_columns usecounts Cost AggregateCost Impact

...

you have to edit the report, and remove the parameter in the report as well. the report is still happily sending the parameters as it last knew them, it doesn't...

yeah i think you need to use sp_executesql and pass the two out parameters to get the errors that Redgates SQL Backup will return;

it will tell you the exact error...

in that case, I'm thinking the issue is most likely that you've included a username and password in the connection, instead of letting the security be handled by the AD...

sej2008 (3/21/2016)

---

thank you,I will try out your solution given by you.but one question when I have configured smtp feature from server manager in my os that is windows server 2008...

it's very easy to zip through the install clicking next next next, but forgetting to add AD login as an administrator on the SQL instance.

you probably need to add yourself...

open the dropdown so it shows all your history of connections.mouse hover over an item so it is highlighted, but DO NOT mouseclick/SELECT it.

while the dropdown is still open, and...

I've also got some CLR's that i deploy to 2008R2 or 2012/2014 .

like you, i've got multiple codebases, for R2,2012 or 2014.

for the 2012/2014 stuff, I've also not been able...

when the script prompted you for the instance name, you did not type "MSSQLSERVER"

it defaults to SQLExpress if you don't type anything.

you don't have an extra isntance...

because you got "login failed" you definitely have...

I would redesign this slightly, but a few things that jumps out at me are:

your query is hitting a view, which i try to avoid when possible. i prefer to...

All sys objects are either views, or procs or functions. The views are based on the uneditable resource database.

It is not possible to create your own obects in the sys...