To move the existing database files?

Run ALTER DATABASE dbname MODIFY FILE (NAME = 'logicalname', FILEPATH = N'new_location')

Take the database offline, move the files, then bring the db back online.

More info...

Yep, me too.

crazy4sql (1/30/2013)

---

I just tried on a dev machine and I can't reproduce crazy4sql's behaviour though - my new DB...

DiverKas (1/30/2013)

---

Vedran Kesegic (1/28/2013)

---

Snapshot is read-only. If you want to test something other than reads, it will not work.

Snapshot might not be good to test even the reads because...

SQLKnowItAll (1/30/2013)

---

After reviewing BOL, I do not see anywhere that it states that the file sizes are copied from model. In fact, the only reference I see to file...

I'd go with that. Can't see SSRS playing nicely with a smart TV browser.

Vedran Kesegic (1/28/2013)

---

Snapshot is read-only. If you want to test something other than reads, it will not work.

Snapshot might not be good to test even the reads because it...

Your CASE statements need to match in the select & group by clauses - you have @Level = 6 in the select, and @Level < 6 in the group by.

The ImagePath column is Varbinary data type, and you're trying to insert the value 'images/sun.jpeg', which is not Varbinary type.

Do you want to insert the actual image or just it's...

No problem!

Taking a backup of live and restoring to the test system will be the easiest way to do this.

Cheers

Try the sys.linked_logins & sys.remote_logins catalog views - should contain the information you're after.

Can't agree more opc. Powershell's a bit of a cow to learn but it's so useful I'd recommend it to all DBA's. Great tool to have in your utility belt!

Lynn Pettis (1/26/2013)

---

Gazareth (1/26/2013)

---

Move the conditions on ACTION_TYPE_ID and GROUP_ID out of the WHERE clause and into the LEFT JOIN - they're excluding the 0 rows from the results.

That should...

Yep, do that. Management Studio for 2008 & 2012 are separate applications - you run them side by side rather than upgrade 2008 to 2012. Same goes for BIDS.

Move the conditions on ACTION_TYPE_ID and GROUP_ID out of the WHERE clause and into the LEFT JOIN - they're excluding the 0 rows from the results.

That should do it, although...