calvo (10/27/2011)

---

An alternative would be to just script the jobs. Make sure the Object Explorer Details window is open (f7), navigate SQL Server Agent > Jobs.

Select all the jobs...

Absolutely yes. Autoshrink and shrinking a database in general wreak havoc on a database.

drew.georgopulos (10/25/2011)

---

To administer a reporting services server?

Must you be sysadmin?

We have a programmer who has been experimenting with reporting services, but making this individual a server administrator is creating great...

Making this person an Admin in SSRS does not require him to have DBO or sysadmin or server admin permissions in the database engine in SQL 2008.

If this is truly...

An alternative could be to use sp_msforeachdb

Jeff Moden (7/17/2009)

---

Now... if you want to know a bit more about each table including the row counts, try this...

--_______________________________________________________________________________________________________________________

/**********************************************************************************************************************

Purpose:

Returns a single result set similar to sp_Space used...

Try this tutorial.

http://lukehayler.com/2010/02/custom-visibility-toggling-ssrs-2008/

Autoshrink will cause severe fragmentation in the indexes. Which would require you to defrag after each shrink. And that defrag is likely to cause the database to grow...

jared-709193 (11/1/2011)

---

SQLRNNR (11/1/2011)

---

jared-709193 (11/1/2011)

---

GSquared (11/1/2011)

---

Gail: I was trying to find a reference I could quote for that same answer. I know the data, but I can't remember where I...

jared-709193 (11/1/2011)

---

GSquared (11/1/2011)

---

Gail: I was trying to find a reference I could quote for that same answer. I know the data, but I can't remember where I read it....

Gus - try this one

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/17/948.aspx

Gail is spot on with her answer.

You're welcome

Try this

DECLARE @startgroup CHAR(1) = 'B'

;

WITH colorwheel (Groups,Colors,Numbers) AS (

Select 'A', 'RED', 1

UNION ALL

Select 'A', 'GREEN', 2

UNION ALL

Select 'A', 'BLUE', 3

UNION ALL

Select 'B', 'RED', 1

UNION ALL

Select 'B', 'YELLOW', 4

UNION ALL

Select...

LOL