Scott, that is an awesome explanation.

Or there are mitigating...

You have to create something specific to...

My advice is two-fold.

First, don't try to shrink while other people are using the database. Find a maintenance window. Change the db to Single User if you have to. Keep...

This sounds somewhat like homework. But since you've posted what you've tried...

Break down your problem. Don't do it all at once.

Let's start with the first concern. Here we need...

Sysaltfiles is also a SQL 2000 deprecated table included only for backward compatibility. If you answer Gail's question, we may be able to assist you with an alternative.

Hey, guys, we have a language conversion question over here. Can anyone assist with this?

Glad we could help. Let us know how it goes.

jasona.work (11/20/2015)

---

So, it's looking like we're going to get our first snow of the year tomorrow night or so...

3-6", and it looks like they're predicting it'll be that nasty rain...

Nothing like staying up late two nights in a row to do releases, get called back ten minutes after the second release to be told I forgot to move scripts,...

Phil Parkin (11/20/2015)

---

Sounds a bit too damp for my liking. 'Whet' is the word I think you were...

You are not wrong. Usually.

There...

Luis Cazares (11/19/2015)

---

I made the code work by adding 4 characters in different parts...

Bah. I thought I was being clever, but I have an error I can't find.

HA!

DECLARE @CurrentTime DATETIME, @TallyCount INT, @Adhoc_SQL NVARCHAR(50);

DECLARE Time_Cursor CURSOR FOR

SELECT DISTINCT N FROM dbo.Tally WHERE N < 500

-- Open Cursor of Users

OPEN Time_Cursor

FETCH NEXT FROM

Time_Cursor

INTO

@TallyCount

-- ...