If pinging by server name fails but by IP succeeds, the problem is most likely with name resolution. You can still try flushing DNS on your PC with:

ipconfig /flushdns

You can...

stuart.unitt 31789 (8/22/2016)

---

I have a report which has a box that shows report parameters. Unfortunately, it displays as per the attached screen grab.

Does anyone know of a way to display...

If you can also connect using the FQDN then it's often a DNS issue.

You could try doing a DNS flush on your end and see if that helps.

Sue

Minnu (8/25/2016)

---

Hi Team,

Cofigured Index maintenance Job in SQL Server.

alert mail from is getting like below.

Levercare Customer (Unify) – HHT <e-mail Address>

How to alter the text before email Address in SQL...

You control access...

I think you want to look at the application name column that executes those, not just the text data. Filtering out based on what you see in the entire row...

jshahan (8/24/2016)

---

We had this occur very recently. We had a developer leave the company and his login(s) and therefore permissions where removed. A dashboard that he created manifested...

Several of the columns always return a value. Do you have select permissions for the schema MY_TABLE belongs to? That's the only thing I can...

SELECT ID ,

Brand = STUFF(( SELECT',' + Brand

FROM YourTable AS P2

WHERE P2.ID = P1.ID

ORDER BY Brand

FOR XMLPATH('')

), 1, 1, '')

FROM YourTable AS P1

Group by ID;

You keep changing the tables and don't provide any DDL which makes it difficult.

If you have one table with ID and Brand, one way to do a stuff for...

It can be caused by a lot of...

inevercheckthis2002 (8/23/2016)

---

AFTER a DROP TABLE / CREATE TABLE command, some users who previously could SELECT from the table are now being denied.

AFAIK, there have been no permissions set at the...

MS explains it in this article:

https://technet.microsoft.com/en-us/library/ms190203(v=sql.105).aspx

You'd want to check the link to Operations That Can Be Minimally logged.

Sue

You want to first understand why the log grew to that size - Do you know why? Are you using CDC, replication, have a long running transaction or any...

I would...