Hi, HanShi -

Please forgive my terse tone - I was somewhat taken aback. Yes, I appreciate the dangers of working on databases without knowing what I'm doing. Hopefully,...

Thanks - that's what I needed to know.

In a professional situation, OBVIOUSLY I wouldn't be altering the security rights of a database when I didn't even know what database I was in. :exclamation: What we're...

Hi, GilaMonster -

>Would have been whatever database your connection was using at the time you ran the query

But suppose you didn't know that, for whatever reason?

>CREATE LOGIN ...

Thanks, I'll check...

Hi, HanShi -

When I received your post, I had just run the following commands:

CREATE ROLE testing;

GRANT CREATE TABLE TO testing;

CREATE USER test_user FOR LOGIN [NULL\test_user];

EXEC sp_addrolemember testing, test_user;

(Yes, NULL is...

Disregard my last post, Alan.B - I made it before I saw your reply.

Thanks to everyone!

I take it that would be "Microsoft SQL Server 2008 T-SQL Fundamentals" by Itzik Ben-Gan, correct?

Thanks to all for their recommendations.

I've already started on

http://beginner-sql-tutorial.com/sql-commands.htm

and

http://www.w3schools.com/sql/sql_intro.asp

and I've bookmarked "Stairway to T-SQL DML" at

http://www.sqlservercentral.com/stairway/75773

A couple of quick questions:

• Which of Itzik Ben-Gan's...

Hi, Jeff Moden -

OK, that's working, but I see a table "dbo.DimCustomer" in two different databases (AdventureWorksDW and AdventureWorksDW2008). How do I know which database the retrieved data is...

Hi, Jeff Moden -

Thanks for the tip; that's what I'll do.

The reason I didn't think of that is because I know NOTHING about SQL yet. You have to start...

Never mind - I've got it sorted out.

Hi, Lowell -

I understand what you're saying, BUT:

Are you using some kind of SQL Server other than 2008 Express with Advanced Services?

What I see when I log onto SSMS...

Hi, Neeraj Dwivedi -

I know I can create more sysadmin accounts by clicking the "Add..." button in Database Engine Configuration.

But how can I get back to Database Engine Configuration without...

I'd like to thank Lowell, as well as eccentricDBA, and especially foxxo, for their help in resolving my problem installing SQL Server 2008 Express with Advances Services. If there's...

When I select "Default instance" in Instance Configuration

and

SQL Server Database Engine = NT AUTHORITY/SYSTEM

SQL Server Reporting Services = NT AUTHORITY/SYSTEM

SQL Full-text Filter Daemon Launcher = < nothing > (no...