Refer to this link:

http://msdn.microsoft.com/en-us/library/ms188283.aspx

You said that you installed SQL Server 2008 R2, but did you make sure to install the proper services? SSIS is needed for maintenance plans. Also, did you copy the...

We got this working by double-checking the permissions for the domain user initiating the upload. I was looking at Data Collector logs instead of the SQL Server Agent logs. The...

lol Habit!

FYI,...

Dev (12/20/2011)

---

Off the topic, but I see two signature in your post. :w00t:

The one highlighted above, that link doesn't work.

Finally, My Best wishes for your...

Cheaper on ebay 🙂

If you are using it for personal use you should download the Express version. Otherwise...

Marco V (12/16/2011)

---

Hmm cool, i dunno been awhile ago i played arround with it. Correct me if iam wrong but i believed it was SQL 2008 R2 only.

and you could...

Hmm... So you all know as much about this as I do 🙂

Jared

Jeff Moden (12/15/2011)

---

Not in my book. 🙂 Think about why they added the CLR capability... it's to extend what you can do...

AWESOME! Exactly what I was...

SQLRNNR (12/15/2011)

---

I think this article is a good starting point.

http://msdn.microsoft.com/en-us/library/cc281962.aspx

There are many many administrative tasks that can be accomplished through powershell. It largely depends on what you would like...

Jeff Moden (12/15/2011)

---

SQLKnowItAll (12/15/2011)

---

One of the questions that my co-worker had was how we call or open a session of PowerShell in a stored proc. I believe the answer is...

Also, is abc\admin a server administrator? Not SQL Server, but local or domain.

Jared