cesarscorp2 (3/27/2014)

---

Thanks a lot my friends; I solved the problem when I configured an domain account in the services. I try again and All OK. On the other hand, Do...

Setup a server side trace with tuning template and apply column filters on DB Name and App ID. Adding filters will reduce the amount of data collected. If you want...

david.gugg (3/27/2014)

---

I would have to say based on my testing that I disagree with the premise in those links. As a very simple example, I open up a linked...

$Raam (3/27/2014)

---

what is the point if we keep creating alias in each machine that uses this alias name? Is there a procedure where we we create a alias in...

Do the same on the application server too ..

--

SQLBuddy

david.gugg (3/27/2014)

---

Hi

My current employer has a slew of homemade reporting using MS Access. At times, these reports place a great deal of load on SQL Server, and I'm looking...

irabufan (3/26/2014)

---

thanks, so this sounds like a soft restriction rather than hard restriction based on your experience. doesn't mean i want to do something not officially supported by MS...

You need to create the same alias on your Laptop (same as the one on Server A) too to connect to that SQL Server.

--

SQLBuddy

Matthew Darwin (3/27/2014)

---

Currently: internal politics over the way in which patches are tested and applied. Personally I want them applied because there are a few other bugs that I...

Matthew Darwin (3/27/2014)

---

I'm aware that it's an old version; however both servers are identical in terms of patching at the OS and SQL level, so I don't believe upgrading will...

bala2 (3/27/2014)

---

Thanks for update.

I guess the DB2 syntax and data structure is total different.i think i need to modify the data structure according to SQL server.

Is there any...

Matthew Darwin (3/27/2014)

---

Both are fairly old versions; but I don't think it's a version issue as both servers are running the same: 10.50.1600.

It used to work on one and now...

Matthew Darwin (3/27/2014)

When the alert was working yes, it was sending emails. However, whilst troubleshooting I'm taking this down to the barebones in order to try and find the...

True, Politics play a big role in these decisions ..

--

SQLBuddy

I was thinking about alert notifications. How are you using alerts...