+1

It means: I agree with the statement.

Greg Snidow (1/11/2013)

---

Ah, my bad then. I'm C# illiterate (and all flavors of C for that matter). Now that you pointed...

PowerShell support async jobs, that you can then check on and stop if they run too long. PowerShell...

Express will not install a local intances of SQL...

What kind of job step is it? If it's T-SQL and you want a timeout less than ~18 hours you could call the batch using sqlcmd.exe and provide the -t...

If you have not taken a full backup on the primary since log shipping became out-of-sync then you can bring the secondary up to date and resuming the existing log...

Just for the record, we're in a SQL 2008 forum but we're talking about SQL 2012.

AlwaysOn requires an Active Directory (AD) domain. If you want to avoid AD and Windows...

I cannot speak for SSAS or SSRS, but here are a couple SSIS resources I have referred folks to that are trying to learn SSIS:

SSIS Tutorial: Creating a Simple ETL...

What is the datatype of PERSONNUM?

You can change this in the WHERE clause:

WHERE (EMPLOYMENTSTATUS = 'Active') AND (CONVERT(numeric, PERSONNUM) = 722)

to this, where DATATYPE is the...

Looks like homework, which is fine, I am happy to help, but please show us what have you tried so far?

PS Thank you for providing consumable DDL and DML so...

Duplicate post. Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1405903-145-1.aspx

JESDBA (1/11/2013)

---

Okay so I emailed the original IT guy, asking him to doublecheck if the disks were over there or not.

...It turns out he'd been using Arcserve the whole time...

+1

Only thing I can think of is that this person is thinking of the way DML triggers used to work in SQL 2000, where they had to read what happened...

Jamie Scharbrough (1/11/2013)

---

Sorry, not downloaded, I used the wrong word.

Yeah that's definitely doable (installing it on my workstation). I'm so used to everything being in the same place that...