ah yes - i forgot to mention that...

Team foundation server 2010 is pretty good, but maybe wait for 2012

if your organisation is too small to afford TFS then you can't beat Subversion (SVN) and Tortoise

with SVN...

+1 - see the following on how to get your data into 1st normal form

http://en.wikipedia.org/wiki/First_normal_form

try this and see if it matches

create table #temp (mydata varchar(20))

insert into #temp select 'ABCDEF?/??GHIJK'

select * from #temp

drop table #temp

i used to do this to prevent my devs running as "SA" - we were required to audit schema changes , so if an object was modified by "SA" then...

this...

if it's in an nvarchar column then soembody forgot to put the N' identifier in the insert statement and you have non-ascii characters stored in your string in unusable format

We run a system that is a hybrid.

local hardware for our internal needs, cloud hosted servers for computational grunt and cloud services (such as ddb, EMR and SQS) for all...

i really don't think, we should continue this - the original poster seems to be just taking the mick. - and our responses are proboably becoming inappropriate - also i...

nsi (5/21/2012)

we have a table that has 714k rows. The table takes up 850Gb, where each rows actual data is no more than 2-4k. It has a few int, nvarchar...

hey - what's wrong with askjeeves.com

there are 2 ways

right click on the database and choose properties and then in one of the screens there will be a recovery mode box (i don't have sql...

from the sp_helpdb it looks as if they are all ONLINE

yep - you need to drop and add the subscription for that table only. - although the article has the same name i think it gets a different internal identifier

I think the use of the word profile in the error might be relating to some jet 4 components.

if you only need to import this data once then you could...