Hmm... Still not a mindreader. Are you setting an alert or a notification? Can you send an email using db_sendmail? Is the job "supposed" to send an email (alert or...

Are you sending one? 🙂 What are you doing to send the emails. Please provide the script in your post.

PiMané (4/18/2012)

---

Will SQL Profiler help me determine what indexes are really needed and not when running its trace file on the Engine Tuning Advisor?

I remember that a long time ago,...

Its your job, so do what you think is right. The thing is, you cannot look at statistics to make the decision. Only outside information can help you to...

You want to create a user for the database admins, and 1 for the application. Then, use the Asp.net security that is built in to manage the application credentials.

My first question is... Why do you want to remove them? There are several reasons that the index may not be used. Refer to this thread:

http://www.sqlservercentral.com/Forums/Topic1285037-391-1.aspx

The removal of...

Run this:

SELECT *

FROM msdb.dbo.sysmail_allitems

WHERE subject = 'your subject'

ORDER BY sent_date DESC;

Look at the records and verify that SQL Server is itself sending 2 emails.

Have you verified that the email is getting "sent" twice, or cound it be that it is getting sent once and 2 emails are being received?

I assume you are using VS to do this? If so, you can add tables to your existing database, or create one. The best way to explain database...

Lynn Pettis (4/18/2012)

---

SQLKnowItAll (4/18/2012)

---

I am trying to get a developer to change a column in a table that is like so:

CREATE TABLE tableA(

column1 VARCHAR(64) NOT NULL...

sturner (4/18/2012)

---

You are right. Every design should be normalized. But vb programmers are pretty much clueless. They typically want to get everything they need in a single select with no...

Take a look here at the sp_addlogin stored proc. It shows you the parameters.

Going along with the others... Who asked you these questions and why were they asked? The answers to these 2 questions may help us get you to a proper answer.

Not knowing the product, I am guessing it is trying to script a user and the password it is creating does not meet your requirements. You may want to...

Jeff Moden (4/17/2012)

---

SQLKnowItAll (4/17/2012)

---

If I did that, I'd be fired. If you don't know...