You should be able to send the Email with "High Importance" flagged.

And most new cell phones can select a different ringtone for Email that is marked as "High Importance".

Try this:

Select * from

(Table2 B

left join on Table 3 C on B.b2 = C.c4)

Left Join Table1 A on A.a1 = b.b2

Show us the output from DBCC OPENTRAN.

You might try adding [font="Courier New"]WITH (NoLock)[/font] to your joins, if that is acceptable for your database.

I have...

Yes it is.

Andrew Collins (3/12/2008)

---

IS there a way of disabling the viewing of the Server properties in Management Studio, I have a user who requires access to a Db for SELECT statements...

Ronnie:

You know, I do believe that I had this 4 days ago:

rbarryyoung (3/8/2008)

---

Although there are a huge number of possible reasons for this behavior, in my experience it is...

Yes, you should have a primary Key and a Clustered Key on an OLAP table.

They do not necessarily have to be the same, though they often are (more...

You can setup pull replication from Oracle to SQL Server in 2005.

I do not know anything about the others.

Carolyn Richardson (3/11/2008)

---

I want to be able to explicitly deny access to the full range of schema roles ie:-

ALTER ANY APPLICATION ROLE

ALTER ANY ASSEMBLY

ALTER ANY ASYMMETRIC KEY

ALTER ANY CERTIFICATE

ALTER ANY...

Very nice. Glad it worked out.

It appears that you have a duplicate Consultant row with ConsultantID=28 and the second one has nulls in the data columns.

either that or that first LEFT OUTER JOIN is really...

Ashwin M N (3/11/2008)

---

I have a user table in every database. The user table contains many users with their user name and password to log in from application side. Whenever...

hongchen91 (3/11/2008)

---

Anybody has the experiece implementing, say 3 to 5 fact tables with a dozen dimention tables and the total size of the db is in 100 GB range?

How...