Lynn Pettis (8/15/2012)

---

User abc is related to the LOGIN imstestuser. You then subsequently create a new login abc. This login is not the same as the user abc.

Flip...

Pablo Campanini-336244 (8/15/2012)

---

Hi

The command:

CREATE USER abc FROM LOGIN testLOGIN

creates a "database" login, not a SQL Instance login.

Please create also the sql ID at an Instance level.

Then connect to the SQL...

Pablo Campanini-336244 (8/15/2012)

---

Hello:

1.-UserID abc created

2.-DBRole abcRole created

3.-Several tables with schema abcschema and xyzschema exist

4.-Add userID abc to role abcRole

5.-on schema abcschema I add role abcRole

6.-on schema abcschema I grant select,insert,update,delete...

Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic1345431-1526-1.aspx

What is the value of dbi_createVersion when you run this? The number will reveal on which version of SQL Server the...

That would make a fine addition to your signature here...

In 2005 and above you cannot remap the dbo user to a login other than sa, and you cannot drop sa.

I too would like to know if this was once...

My pleasure. If you have any issues or doubts after you start experimenting with any of the options feel free to post back and I'll do my best to answer...

Lexa (8/15/2012)

---

opc.three (8/15/2012)

---

Are you sure you're not thinking of PAGEIOLATCH_UP?...

Chuck 17099 (8/15/2012)

---

My background is a good bit of SQL scripting mostly self taught and enough vb scripting to get me by. I am willing to learn anything that will...

Are you sure you're not thinking of PAGEIOLATCH_UP? I think...

SQLSACT (8/10/2012)

---

HowardW (8/10/2012)

---

It's not relevant how many rows were actually returned, it still has to access a range in the index if it's not marked as UNIQUE as it doesn't...

david.holley (8/14/2012)

---

Thanks.

I was more concerned about installing a new instance of SQL Server (FULL) when an instance of SQL Server Express already exists and then realized that both can...

:pinch:

Same as any migration:

- detach + copy + attach

- Copy Database Wizard

- others

Backup/restore is typically what I use to bring a DB to a new instance.

Have you done any searches online? What have you found?

Have you tried developing a process yourself? What have you tried so far?