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...

Oracle_91 (1/10/2013)

---

Hi All,

Can anyone share their expericences which one is good and bad about below configurations on 32 bit systems and sql server 2005.

On what factors we can choose either...

zi (1/11/2013)

---

Thanks for replying

My book shows that we use "with standby" in two ways, first one for log shipping, the second one for inspection"how" because the book is showing a...