mtillman-921105 (9/1/2011)

---

I'm moving to Colorado! :smooooth:

'Can't wait. Memphis just isn't were I want to be anymore. I have some family and friends here, but most have moved on....

It looks that way on mine, but if I change the password, I can then check the box. You can't force a password change without changing the password.

Without seeing the DDL for the tables and knowing the keys, it's hard to give you the exact.

In terms of conditions, use them in a WHERE, something like

WHERE dbstatusID !=...

Interesting. I think we're not consistent, but I do see a lot of

- #sql

- #sqlserver

- #sqlhelp

- #sqlsat

- #sqlpass

-...

I used to park in a parking garage at one job and often hit the top floor because I was a late arriver and knew there would be spots. I...

Dewes van Lohuizen (9/1/2011)

---

A few weeks ago I had the situation that the logfile from the tempdb was full.

I was not be able to log on again and we restarted...

Roy is completely correct. Most of the high profile stories on the Internet take place through SQL injection, which mostly works because developers don't use stored procedures. They think writing...

Assigning permissions to a role is a one time thing. It might seem intensive, but it's not much work and it can easily be scripted. There are scripts on this...

I agree with Roy that I might not use db_datareader/writer. If you have exceptions, you get into DENYs in roles and that gets confusing.

Create your own two role and assign...

You can easily add space to tempdb by right clicking the database in SSMS and changing the size of files if you don't have autogrow set.

any of these could work. I tend to like replication since it picks up by itself if the connection is down or delayed, but you need to administer it a...

Was just about to post what Gus did. You're confusing rows and columns a bit.

Since you have multiple rows with points, you get those results as rows returned if you...

While both are created in tempdb, it is possible that both table variables and temp tables are memory resident as well

Jack Corbett (8/29/2011)

---

It's hard to say. It is very close, but the implementation is just different enough that it probably...

Anyone see plagiarism here:

http://www.sqlservercentral.com/articles/context_info()/74332/

http://www.thecodepage.com/post/TIP-A-Call-Stack-in-SQL-Server.aspx