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

Pick up Michael Coles' book on Pro SQL Server 2008 Encryption

Are you running x86 (32 bit)? If not, don't worry.

If you are

http://blogs.technet.com/b/rob/archive/2008/05/15/windows-memory-and-sql-server.aspx

http://msdn.microsoft.com/en-us/library/ms175581(v=sql.105).aspx

Powershell can work outside of SQL Server and is less cumbersome than stringing scripts through SQLCMD. That provides a good way to handle administrative tasks, especially when they involve the...

use a batch file. In it

sqlcmd -E -Q "sp_detach_db @dbname='mydb'"

They can double click the batch file to detach the database.

second vote for what Lynn said. If you provide some DDL and sample data, we can probably help.

I suspect that an inner join is needed as well. When you gather...