Brandie

I did not get that. Fail over as in failing over the database ? The first pos does not seem to mention that. I have not read all...

Hi

My 2 cents...

A different appoach here - A procedure checks for the users rights on the tables for performing the required actions. This common procedure is called from inside all...

Gianluca Sartori (6/29/2010)

---

It does, if each user authenticates with his own credentials on the database.

You could also have different scenarios, with an application that requires windows authentication fo the users...

Hi

What are the changes that you want to track? You can use DDL triggers or read from the default trace. It depends on what you are trying to do.

What about job scheduled to run at the required time interval. The job can call a procedure that can collect the required data and also send the mail.

Hi Imu92

Good solution.

Hi

I assume that only one record for a productid will have value in xaml column. Noticed it when the previous poster put that point accross. Here is my query and...

Hi

It would be better if you check why memory utilisation is so high. Is it due to some badly written code or does sql really requires so much memory.

Jonathan AC Roberts (6/21/2010)

---

ChiragNS (6/21/2010)

---

We granted select permissions to mycertificateuser. Do we need to give permissions to all the other users who are going to execute the procedure (i think...

Yes , use sp_procoption to set up the procedure as a startup procedure. You can create the procedure in the master database if you have the rights to do so.

Hi

Going by the constraints that you are working with this seems a good design IMHO.

Check the join conditions between the 2 master tables and also the indexes in the new...

Hi

You can write a startup procedure which will start sql agent when ever the sql server starts.

I have done this but i dont have the code right now.

Hi Jonathon

That was a nice article.

I have a doubt.

We granted select permissions to mycertificateuser. Do we need to give permissions to all the other users who are going to...

Hi

Just glancing at your query ... i find two things ... usage of so many "OR" statements and the way "like" is used. Both probably result in proper...

As other posters have pointed out server side trace is the best way and certainly better than querying sysprocess every minute. My question is why do you want all the...