Something has a lock on the information your after.

Monitor for blocking while your expanding and see what is stopping you.

Jobs in SSMS for SSRS mean reports which are currently being run.

If your trying to view job details on subscriptions, you need to checkout the SQL agent.

The following script will...

Use the import export data wizard to import the data.

Post the full detailed output of the command

create a server side trace, then just before the jobs start, have a job which starts the trace, to stop it ensure you put a stop time in the create...

bugg (2/6/2013)

---

Steve Jones - SSC Editor (2/5/2013)

---

A couple things: AlwaysOn is Enterprise only. I forgot about that, so your read only replica is going to be core licensed if you...

Between 6pm and 7am you dont do transaction log backups, during that time the log cannot be marked as re-usable so that is why you have a huge transaction log...

Wont be able to leverage windows authentication, everything would have to be SQL auth.

Should you need to run backups to network drives etc will be a pain as you will...

dont cross post, it fragments replies and wastes peoples time

all replies here http://www.sqlservercentral.com/Forums/Topic1416459-1292-1.aspx

dont cross post, it fragments replies and wastes peoples time

all replies here http://www.sqlservercentral.com/Forums/Topic1416459-1292-1.aspx

You will want to look at a calendar table

Something like this

Calendar Table - http://www.sqlservercentral.com/scripts/Date/68389/

Please follow the second link in my signature on posting code and data for the best help, that will then give us a play pen to test ideas on to...

An admin to SQL or an admin on the windows host?

What browser are you using?

SQL Monitor is done I belive on a instance basis

Idera is done on an instance basis

Spotlight is done on a server or CPU basis (unsure if the server relates to...

Kevin Gill (2/6/2013)

---

That's true - that server has a huge number of CPUs in it though...