In fact, you should not be shrinking your database on a regular basis. Should you determine how much space your databse requires over the next 3 to 6 months...

lawson2305 (7/16/2012)

---

I do have a full maintenance plan run every Sunday. So I retract my statement before I run a log backup appended everyday but Sunday 2AM.

in the plan...

GSquared (7/16/2012)

---

Select ... Into ... is VERY different from Insert ... Select ...

The Select Into syntax will create the target table. If it already exists, you'll get an error...

Looks to me that you have an active VLF near the end of your t-log file.

Lowell (7/16/2012)

---

Lynn Pettis (7/16/2012)

---

Lowell (7/16/2012)

---

both commands will work perfectly in SSMS;

are you running this through an ODBC driver, and the driver might be mis-translating the object names?

where is this code...

I created...

You may need to restart SQL Server. SQL Mail is not always reliable.

lawson2305 (7/16/2012)

---

ok I just don't get it. They are back up to 66GB again.

I run a tran backup and shrink every day. I append the backup daily except...

VGish (7/16/2012)

---

Hi,

What is the equivalent of ORACLE “MONTH_between “ in SQL ? I want in months….

I tried the Datediff, It is not the same..

See the example below…

select FLOOR(MONTHS_BETWEEN(sysdate,'07/20/2011'))

from...

CELKO (7/16/2012)

---

To track the history of, say, Foobars we need to see time as a continuum and model it as (begin_date, end_date) pairs that define when a foobar had a...

And you will find a better one here: http://www.sqlservercentral.com/articles/Tally+Table/72993/.

It would help if you provided a more definitive timeline of when your backups and restores occurred. From there we could probably help you understand how the backups relate...

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

Add to that you are joining 11 views together to form another view. How many tables do each of the views access? Do this views access some of...

rob.vig (7/16/2012)

---

I ran your simplified statement and it ran fine. No Error reporting though

--sp_Create_Accounts04 -

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

-- SET NOCOUNT ON added to prevent extra result sets from...