Honestly, I'm not sure. We started the site with the idea of sharing knowledge, of writing about things we'd solved (Andy, Brian, myself) and helping others. We found quickly that...

That's 50 Australian Sheep Dollars. Known in the US as monopoly money.

It depends on where the block is. If you have this:

data data data data data bad block (free space) (free space)

you could be fine. If you have...

jerry-621596 (5/31/2012)

---

That completely depends on what you want SQL Server to do should it stop running for some reason. I have mine set to attempt to restart every time...

As Lynn wrote, you need an ORDER BY clause. There is no guarantee of ordering at all, from one execution to the next, of the rows returned without that clause.

Do you have auditing turned on?

mtillman-921105 (5/31/2012)

---

Thanks Steve. We bought a home just north of Denver. 'Still trying to unpack boxes (again!). By the way, the houses near the tech center sure...

mtillman-921105 (5/29/2012)

---

Jack Corbett (5/29/2012)

---

For those not on tiwtter, just signed the papers for my new house. Went from no debt to hundreds of thousands, but in the...

Meaning can you call PoSH from SSIS? Or Vice Versa?

I think the confusion is that PoSH isn't much of anything. It's a shell for accessing components. In the SQL space,...

I don't think this is true. I could easily copy binary files or text files on Unix machines from 64bit Solaris to 32 bit Solaris.

I can't execute a 64 bit...

This isn't a web forum. This is a SQL Server forum. Please don't post questions here about other technologies.

To copy folders, just open two explorer windows and drag the contents...

Tim Mitchell (5/31/2012)

---

Same here, but tired for a different reason. I went to the Rangers game last night and watched our boys get shelled at home by the Mariners....

jfogel (5/31/2012)

---

Our app did not try to use say ANSI only SQL, the "mode" is detected and either Oracle or SQL Server specific code is executed within executables. For...

On our list. I'll try to get an ETA on development.

You can set the default locations for data and backup files in setup.

For the system files, the master location is passed as a parameter in the service applet (or the...