a suggestion i have seen else where on the forums is to use a view similar to the one below:

CREATE VIEW blah

AS

SELECT 'db1' AS DBName, * FROM db1..tbl1

UNION ALL

SELECT 'db2',...

Perry Whittle (5/14/2012)

---

Bad idea generally.

A...

the VLF's being used was what tipped us to the script being used and having 2 VLF's at the size of Initial / 2. thanks for the article by...

Hillbilly

opc.three (5/11/2012)

---

capn.hector (5/11/2012)

---

i believe only when used with CREATE DATABASE. all the DB's we...

i believe only when used with CREATE DATABASE. all the DB's we created with...

opc.three (5/11/2012)

---

OK, I am with you now. I would run a Trace to see what SSMS is doing. My guess is SSMS does a SHRINKFILE w/ NOTRUNCATE first to bring...

there were other options set. the developer scripted out the dev database and ran the script on the production server. since we dont need it as large as...

lol had pool cue on my brain when i was posting that.

Blue balls

Lynn Pettis (5/9/2012)

---

riya_dave (5/9/2012)

---

hi

i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.

I am...

Grant Fritchey (5/8/2012)

---

capn.hector (5/8/2012)

---

thanks to the suggestion of Grant it got me thinking about the where clause. i was helping out the operator about an hour after the...

thanks to the suggestion of Grant it got me thinking about the where clause. i was helping out the operator about an hour after the "Error" occured since...

can you post the output you want from the 4 queries. when i run them i get

Start_Date ...

emilio estevez