marklegosz (2/8/2011)

---

Regarding SQL logins, I think the point here is to use them as a last resort when no other options are available.

In a web server/db server example, you could...

Another QOD, another new thing learned - thanks!

And a nice reminder that I really must sit down one day and find out what all the other buttons and menu options...

RichB (2/7/2011)

---

Ah, not the missing option of 'wtf are you using sql logins in production for anyway?'

What with them being inherently, disgracefully insecure.

For anyone that hasn't I strongly recommend using...

getoffmyfoot (2/7/2011)

---

Such a bummer to me that the sp_change_users_login option is going to be phased out without a "decent" alternative - consider the scenario that exists in my environment where...

It does some checks on...

Presumably the permissions on ALTER USER will perform the required security checks on whether the user has permission to perform the action. The sp_change_users_login does...

Thanks for the kind comments everyone - this was my first question, so it's good to get a positive response!

And thanks Carlo for the extra information - I wasn't previously...

Looks like steveb just beat me to it!

He's obviously right in that you can't include the server name in an instance, so "SQLExpress" should do it.

myavast (10/6/2010)

---

I am taking a Database Programming course. At my school they named the SQL server ".\SQLExpress" and the Instructor asked us to name our server at home with...

Don't forget that if you run sp_spaceused on the database, it shows you the size of the whole database, including the log file and free space. It could be that...

rmechaber (8/25/2010)

---

I've run into a similar problem importing data from Excel. There's a connection string parameter you can add to prevent SQL from "guessing" how to import the data:

http://microsoftdw.blogspot.com/2005/11/excel-data-not-coming-into-ssis-right.html

Maybe...

Hi

Just wondering if you'd got anywhere with this, as I have a table with nearly 200 columns that was a bit of a drag to import from flat file in...

MeltonDBA (8/13/2010)

---

Sadly I only had Standard Edition on my Windows 7 so I have not tried installing SQL 2008 R2. If you have exausted Bing/Google and can't find anything you...

MeltonDBA (8/12/2010)

---

I think they had that issue with SQL Server 2008 in Windows 7 but fixed it in SP1. You might try loading the latest CU for SQL Server...

No problem - good luck. As others have suggested,...