I think that the days of Microsoft releasing buggy 1st releases is past.

The best move that I have done recently was install SQL Server 2008 when released. This was so...

Come on Guys. Everybody is being so sympathetic to Microsoft. This was simply sloppy Date Arithmetic. We're 12 years into the 21st Century and we're still having problems with Dates.

Other...

A few of these posts have been going on about strings and collation sequences. A DATE value is represented as 'yyyy-mm-dd'.

Note I prefer the ISO notation which isn't as misleading...

I want to side with those who find this inconsistency as unacceptable. I can live with defaults but in this case there are 2, 1 and 30. There should be...

10 Pages.

worse part after the time it took was not knowing what I'd lost. The only upside is that it's a Data Warehouse and in percentage terms this is a...

I had to run with the "Allow Data Loss" once. It was the only option left after it was determined that the Backups were rubbish. It was a 3TB Database...

Just in case anybody is actually interested. We have fixed this.

Don't really know the cause but problem was solved by removing older software from the PC such as SQL Server...

Have only just got to this question.

My thoughts: How do you measure "Most Common" ?

Is it how may many Computers use it ? Probably ASCII because of the PC.

Is it...

I agree that it's probably permissions related somewhere but where. Clearly sa has all of the SQL Server Permissions needed.

I can use sa any time that I choose except in the situation outlined in the Post. The User had access to both servers prior to using the R2 Client.

I...

So far I've found SQL Server 2008 SP1 to be rock solid. I run the X64 version on a Windows Server 2008 x64.

I'm now contemplating R2 i.e. not worried about...

I have had that problem. It happens when I first Edit the Data Source. if I go back in the 2nd time it shows as warnings but I am then...

Hi Kyle.

My Problem was solved by changing the Properties of the BIDS Project.

Project, Properties, Debugging: Change Run64BitRunTime to False.

Note. When Running the SSIS Package from SQL Server Agent that there...

I can't go past "Deep Thought" also from Hitchhikers Guide that concluded that the answer to "Life the Universe and Everything" was 42.

Thanks.

Got it working.

David