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?

That's one way to do it. After restoring consider changing the AUTO_CLOSE property on your database(s) to False.

You can execute a vb.net app from a network location. If you were to post the vb.net app on a file server where all people who needed it could reach...