tt-615680 (9/11/2013)

---

Dear All,

When I tried to create a Linked Server I get the following error message would you please let me know what would cause the issue please?

Named Pipes Provider:...

did you check the sqlserver errorlog file if it holds error messages from the failed backup requests ?

t-sql is the language

sql server is the engine

as far as I know, there is no way of telling the connection actually comes from a linked server definition.

What you can do is do some connection tracking and...

for us - the db crowd - there has been no need to alter stuff as the mail team just re-routed the relay definition for smtp.

They prepared their action well...

We used smtp with exchange, so we had to get all ip-addresses granted to be able to use the smtp relay for dbmail.

I'm not even sure if we also need...

Soon the Thread will be posting its own ranted forum questions itself 😉

you could collect an inventory scanning all your sqlserver instances or active dbmail configurations and for dbmail profiles.

ref: http://technet.microsoft.com/en-us/library/ms177580.aspx

/* is dbmail config activated ? */

Select *

from ...

Basically it means:

- Immediatly go to jail

- do not pass the GO square

- You'll not collect $200 salary

:w00t:

If corruption re-occurs, it is time to check your disks, .. double check if your case can be found in the BUGs of Service packs or Cumulative updates you didn't...

Please don't x-post.

This post has already been replied to: http://www.sqlservercentral.com/Forums/Topic1488317-391-1.aspx

of course if depends on the level of granularity of the grants for your current QA-accounts.

IMO scripting all grants may be the easiest approach.

Then, use restore db and run the...

it depends if the backup has been taken before the corruption occured.

One way of testing this is using Allens automation script : Test Your SQL Server Backups with PowerShell[/url]

As Gail stated, your "and o.type = 'abcd'" is part of the join predicate for the left join.

if you only want abcd typed rows in your result, you should move...

Of course it is a choice to just add a gender value and an indicator it is a value to be double checked.

Updating the current column content isn't such a...