I just noticed this line...

tcalloway (5/17/2016)

---

How can I write this procedure differently to prevent so many transaction entries? Or, how can I consistently and successfully shrink my enormous transaction...

Greg Edwards-268690 (5/19/2016)

---

Brandie Tarvin (5/19/2016)

---

GilaMonster (5/19/2016)

---

Oooh. Am very tempted to grab both the R and the Data bundles.

The free book yesterday (Machine...

dudekula.kareemulla, Lowell said more plainly what I was thinking but didn't say.

Synonym or no synonym, you have to give the users...

Or worse, the server could be using a previous registered SPN....

Pretty much the same way you grant permissions to objects in a database.

GRANT <permission> ON <synonym> TO <login>

But why would you need synonyms on the same server? It's easy enough...

This is the 2008 link, but it should still help. Though given what permissions you listed above and the fact that...

GilaMonster (5/19/2016)

---

Oooh. Am very tempted to grab both the R and the Data bundles.

The free book yesterday (Machine Learning with R) was...

That's an awful lot of work just to avoid transaction log backups.

Ken McKelvey (5/18/2016)

---

tcalloway (5/17/2016)

---

I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, in a table and then...

jasona.work (5/18/2016)

---

GENUINE AMISH SERVERS

Only the best servers hand-built by talented Amish craftsman from the latest (to them) DEC Alpha processors! Each server loaded with a whopping 16MB of 72-pin...

smw147 (5/19/2016)

---

Have you tried enabling the UDP ports 1433 (default instance) and 1434 (names instances) in the firewall on the server (incoming & outgoing)? I have found this helps...

If your company can't hire someone local, I'm sure one of us would be willing to...

That was terribly rude of you. Especially given how you tend to respond when other people try to help you with your questions.

In the future, please try to...

Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is the last person who should...

Ray K (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Why do people choose to ignore good advice and just push for the answer to their question like that is the needed solution. Not saying...