Ville-Pekka Vahteala (6/9/2014)

---

arnold-491793 (6/9/2014)

---

Hi,

I am having a problem in creating query for this exciting scenario.

Table A

ID ItemQtyCreatedDatetime

W001 CB112014-06-03 20:30:48.000

W002 CB112014-06-04 01:30:48.000

Table B

IDItemQtyCreatedDatetime

A001 CB112014-06-03...

Lynn Pettis (3/20/2010)

---

There will be one small issue you may need to verify, any logins whose default database is MyDB (the one you are moving via detach/attach) will probably need...

Hi.

Just one last question and i know it is critical.

How about the user permission and security? What will happen when i use detach and attach database in my SQL...

Paul White NZ (3/20/2010)

---

Small point: sp_attach_db is deprecated and will be removed in a future version. Use CREATE DATABASE...FOR ATTACH instead.

There is a good SSC article on this topic...

GTR (3/18/2010)

---

JDixon-385826 (3/17/2010)

---

running the below alter DB restricted user will make sure all transactions have been completed before the detach. Running something like the below will make sure you have...

CirquedeSQLeil (3/17/2010)

---

If you follow all these steps, you should be fine as far as data loss goes.

In other words, you will have your bases covered and should be...

CirquedeSQLeil (3/17/2010)

---

I suggest two more things before starting any of that.

1. Backup the database

2. Disable access to the server for all connections not related to you, the team,...

Is there any risk in using sp_detach in production database? I would like to move some of my data file in different array partition to have more disk space. I'm...

Do you have sample on how to use Move Clause to move a current filegroup mdf/ndf...

I have another partition in my disk array that has enough space. I'm planning to move my data file into Drive F:

Here is the data file in my Drive E:

Data...

Steve Jones - Editor (1/6/2010)

---

First, get more disk space. Don't talk to your manager about how much free space you have. You need a decent amount of free space in...

How about doing some DBCC Shrinkfile? Is this will free...

This is cool. Thanks. That's right the 3 aladd1 in case statement should be aladd2, aladd3, aladd4. Just a typo error.

What did your try?

Thousand of rows.