I don't believe that's something you can control directly. Could be mistaken, but I don't think so.

Interesting. I saw the exact same problem on this site, by another person, just a few months ago.

Different wording for the explanation, but the exact same rules.

Is this a...

I have to agree with the earlier post that this isn't limited to IT by any means.

I've known too many burned out salespeople, accountants, managers, etc., to think it applies...

Run each one a million times, or least a few thousand, and see which takes less time. A lot of that will depend on environment it's running in.

James Goodwin (1/26/2010)

---

I...

jcrawf02 (1/25/2010)

---

So since cloud computing is the answer, do you (anyone, not just Gus) agree with this statement?

Clouds push complexity to the background and allow users to focus on what...

If you have a Numbers table, you could do this:

;with Names (Name, Number) as

(select @UserName as Name, 0

union all

select @NewName + cast(Number as varchar(10)), Number

from dbo.Numbers

where Number > 0),

Name (Name)...

Have you looked in sys.server_principals and sys.sql_logins?

Someone mentioned the idea of prefixing with the company name. I've seen that, and it's a pain to deal with.

At my last job, every database started with an abbreviation...

GilaMonster (1/25/2010)

---

Absolutely. Comma-delimited lists in a column are a violation of 1st Normal Form and...

Actually, it seems to be saying the answer is cloud computing...

Grant Fritchey (1/25/2010)

---

I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning of...

Well, we always "behave", it's just how...

I dislike prefixing database objects.

I'm with the "you can't exec a table, so why does the name need to say so?" camp.

I've replaced tables with views (for backwards compatibility), much...

CirquedeSQLeil (1/22/2010)

---

GSquared (1/22/2010)

---

There's a report you can get on schema changes. Deleting a table is a schema change.

Right-click on the database in Management Studio, and select Reports, then select...