Nice question and good to know as I do have one standard instance.

LEN(Reverse(<string>) is a quick and dirty way to find the length of a string INCLUDING trailing whitespace.

I think you can filter the job listing by name... that's a bit of a pain though if you have hundreds of them.

The Activity Monitor will let you filter by...

Is the mail profile you created set as the default mail profile?

If not, try setting it as the default.

If it is, or if you don't want to set a default...

Thanks for the question!

This page shows the limit for primary key columns:

http://msdn.microsoft.com/en-us/library/ms143432.aspx

L' Eomot Inversé (7/27/2012)

---

Or you can get mathematical about it and say that if the predicate "=" is defined on a type then any function on that type must return...

L' Eomot Inversé (7/27/2012)

---

sestell1 (7/27/2012)

---

SQL Kiwi (7/26/2012)

---

L' Eomot Inversé (7/25/2012)

---

Hugo Kornelis (7/11/2012)

---

In my opinion, it is LEN() that has the strange behaviour here, because it returns the length of the...

SQL Kiwi (7/26/2012)

---

L' Eomot Inversé (7/25/2012)

---

Hugo Kornelis (7/11/2012)

---

In my opinion, it is LEN() that has the strange behaviour here, because it returns the length of the padded version of the...

Great question, thanks!

I was sure I had them all correct, I must've clicked on one of the wrong ones by mistake. :angry:

Thanks for the question!

I don't use computed columns often, so this is very good to know!

Nice. Thanks for the question kranthi1.aprdc!

Have you tried connecting using the fully qualified domain name of the machine?

It's possible that the default domain of your machine is different than the default domain of the server,...

+1

Thanks for the great...

jeff.mason (7/20/2012)

---

sestell1 (7/20/2012)

---

Wow, interesting. I'd been under the false impression that the full backup used an internal snapshot to capture the state of the database at the time the...

Wow, interesting. I'd been under the false impression that the full backup used an internal snapshot to capture the state of the database at the time the backup started....