Here is the list of what each Server Role can do:

Permissions of Fixed Server Roles (2008 R2)

serveradmin can only do these things: ALTER ANY ENDPOINT, ALTER RESOURCES, ALTER SERVER STATE,...

Instead of using EXECUTE AS LOGIN = in the proc that creates the Linked Server and granting impersonation rights to your user base for that LOGIN you can try using...

Brandt Smith (10/25/2012)

---

nice work...any way you could apply this technique to a SharePoint list view? I use them frequently as a 'queue' for gathering information and then use SSIS (with...

Hopefully one of the three techniques will work for you.

Using the Script Task in SSIS to Process Data Files When They Arrive[/url]

optimistic

Stan Kulp-439977 (10/25/2012)

---

This is a great idea, but in my particular case our sysadmin will not allow the dot net framework to be installed on his SQL Servers because of...

dave-dj (10/25/2012)

---

excellent and comprehensive article.

I only have a couple of questions..

first - if you where required to process multiple files per day, would you adapt this process, or would you...

andre.pageot (10/25/2012)

---

Excellent use of SSIS

however I did spot a potential bottleneck, you could potentially get stuck in loop if the process that held the file open has halted or crashed...

zapallina (10/25/2012)

---

This is my first post ever so yea herewe go... let me say thanks for such an amazing and complete step by step post.

I just came across with this...

ALTER TABLE dbo.MY_TABLE ALTER COLUMN SOME_DATE CHAR(8) NOT NULL; -- widen CHAR(6) so the world does...

Good to know, thanks for posting back the resolution.

Eric M Russell (10/23/2012)

---

What's described above would be one form of a "property bag" technique. I have been tasked with building data extract and reporting from a large ISV database...

When adding a file to the drop directory are you copying and pasting the file into an otherwise empty directory? WMI is quite particular in that if you rename an...

Eric M Russell (10/23/2012)

---

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below, each...

Steven Willis (10/23/2012)

---

DotNetNuke

DotNetNuke...