You can use the following:

http://jasonbrimhall.info/2013/01/07/ssrs-subscriptions-report/

Yup. I always did the detach in 2005 after a bad experience. But yup - the syntax is supported in 2005. I don't recall the specifics of...

Besides the baseline, I prefer the method of looking at the big picture as was mentioned in the article. I prefer to avoid fixing the symptom when a bigger...

george sibbald (2/4/2013)

---

my preferred method would be the alter database command

ALTER DATABASE yourdb

(

NAME = logicalfilename,

FILENAME = N'c:\t1dat2.mdf' --for example

);

then offline the...

You can load the plan into SQL Sentry Plan explorer. It is a lot more user friendly.

Nice Info

You can leave the extension off if you wish. I wouldn't recommend it but it does work.

To rename it, detach perform the file rename and then reattach is what...

I typically just go for sys.objects like the following.

SELECT SCHEMA_NAME(schema_id) As SchemaName

,name As TableName

FROM sys.objects

WHERE type = 'U'

An interesting sidebar on this is that if you look at...

Jysafe Lerroy (2/4/2013)

---

Hi,

We just recently started using Avamar to backup everything including an hourly SQL server transaction log backup. The issue we’re having is that since we started using Avamar,...

SWEEEEET

Particularly if...

On more nutella

Here is one possible solution

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

+1

+1