At a previous job, I got the unpopular team leader. The foolish man went on leave on his birthday (which we all knew about) and left his drawers unlocked....

If you can, wait until SQL 2008 comes out. And do lots of testing. There was an article or editorial on this site about this recently.

As for the...

SQL Server 2005 Express actually has a 4GB database size limit. It has also been throttled so it can only use 1GB RAM.

SQL Server Standard Edition can't be installed...

Just did a quick play around with SSIS.

In the Flat File Connection Manager, skipped the first 4 rows as Header rows.

Under Columns (select from left-hand side), set the...

I got D as well. My reasoning being that SQL would probably handle the memory part by itself and that there are no guarantees that it is memory causing...

I think as far as companies go, having a certification keeps the HR droids and other management happy - it gives them a quick indication of who might be suitable...

Cool, thanks. I always have trouble finding stuff on the MS site. End up clicking my mouse to death.

Anything in the SQLAGENT or ERRORLOG logs?

Did you set the service account using Mgmt Studio (as opposed to Service Manager in Windows)?

Not sure if it is the way to go, but we're planning to just pause mirroring & let the transactions sit in the log then resume when we're done. ...

Funny you should mention a cluster with multiple instances. That's something I've been tasked with investigating as part of a consolidation project, hence why it popped into my head.

Good...

Finally found something. Haven't tried it yet. It was on http://www.experts-exchange.com, but is now only in Google cache as the question has been removed.

I am reminded of a comment a project manager once made (he was IT savvy as well) regarding Windows. I think Windows NT4 was just out or about to...

"Microsoft Works"

'nuff sed.

Another ditto here.

Cursing is a sure sign of NON-Intelligence. Intelligent people do not curse. They are smart enough to express themselves with proper grammar.

I disagree with this statement. Cursing...