Do you ever post anything but complaints about spelling and grammar?

http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=gbtacbbixlcxtw55lhxxqs45&SortBy=2&SortOrder=1

I was a COBOL programmer for eleven years before jumping to administration. I was a system lead when two of our three DBAs left to work for a contracting company...

The desk units that were installed in my office 4 years ago have an adjustable keyboard tray (angle and height) that has about 2 feet of vertical travel so I...

+1 for Troll Hunter! I saw it on Netflix a few...

My bad. I should have said variable strings that identify checkpoints i.e. location of the checkpoint...

We purchased JAMS Scheduler last year and we're in the midst of testing. One of the reasons we chose it...

Welsh Corgi (5/1/2012)

---

Interesting.

I would like to know more about how you use your database to store package configurations.

I saw that when you create a job to execute an SSIS Package...

The packages will reference the configuration, no matter where it is, if you enabled configurations in the package.

When you enable configurations in BIDS, the wizard gives you a chance to...

I'll stay in my current DBA job until I retire for the first time. I currently have one of the last existing real pension plans (I work for the...

I've done this by creating a SQL Server login, adding it as a user in msdb,and making it a member of SQLAgentUserRole. This gave it permission to execute sp_start_job.

I...

You need to add 'On Success' precedent constraint between the last Execute SQL task and the Transform Data tasks.

If by dump, you mean an export (.dmp), then no. You'll have to import it into an Oracle database first then use SSIS to import directly from Oracle.

Always On is a pretty strong incentive for us, but we're pushing the business value of Power View used with PowerPivot in Sharepoint to justify buying some SQL 2012 licenses...

Granting users membership in all three roles was redundant because the roles are hierarchical. SQLAgentReaderRole has all the SQLAgentUserRole permissions plus permissions to see multiserver jobs. SQLAgentOperatorRole has...

Are you thinking of the SQL Agent database roles in msdb i.e SQLAgentOperatorRole, SQLAgentReaderRole, SQLAgentUserRole? Users shouldn't be able to run jobs by default unless they're members of sysadmin,...