I was afraid of that and kind of figured. Thanks. 🙂

The problem with monitoring the query plan,...

Looks like I might have fat fingered the size and typed a size larger than the current file size which would explain the error message.

Yes, I totally agree that you should not shrink your files as part of a maintenance plan. However I have run across the same message and I have a...

Loundy (5/23/2013)

---

unfortunately downgrade isn't possible.

you could install standard next to enterprise and copy the dbs to it before uninstalling to minimize any downtime, but as mentioned, back your dbs up...

Changing the cursor location to the client may not work for us. I understand that there are things...

Thanks, I actually found a test machine to try it out on. I just completed the named instance installation and it did not require a reboot.

Double Order By and Where clauses. Even if I comment one of the doubles out for each, the script still fails with errors:

Msg 207, Level 16, State 1, Line...

Thank You! Nice script too.

Any ways, you answered my question. I can't just update the sys.indexes table to change future rebuild/reorganize FILLFACTORs. 🙂 I tried.

Pat

Thank You! Nice script too.

Any ways, you answered my question. I can't just update the sys.indexes table to change future rebuild/reorganize FILLFACTORs. 🙂 I tried.

Pat

I, unfortunately, never did find an answer to this issue.

So far every failover has worked perfectly. We are very happy with the solution. Do you get any indication...

I saw no trick to this.  I cut and pasted it from the question and it ran perfectly.  The question was terrible.  Who suggested this question?  It's nice to see...

Jim,

And you probably really believe that Al Gore invented the Internet...

Steve's comments were just a simple gesture about a United States President.  They did not appear to be politically motivated.  It was not an endorsement of him, nor was it...

I have found it useful to use print statements in the trigger.  Then perform an action in query analyzer that will cause the trigger to be fired.  The print statements...

In example 2, couldn't this be used also?

DECLARE @orderby int

SET @orderby = 1

SELECT l.State, ComponentName

FROM #Locations l

INNER JOIN #Users u ON l.LocationID = u.LocationID

INNER JOIN #Components c ON c.UserID =...