Small company, cost limitations, I go RAID 5 with a hot spare. No way we can afford a SAN or RAID 10.

We're just going to have foxpro do the inserts. SSIS is proving to be way too much trouble for this. I did have it configured in the connection...

GBPVR (tivo) 120GB + 250 GB

Desktop 80 + 250GB

Server 40 GB + 160GB

Laptop 40 GB?

External HD 160GB

Computer that just died 40-70 GB

I'm over the TB bar!

these are system tables in the individual database, correct? Not instance-wide system tables, correct?

sorry if it's a silly question.

Ok. Do I need to put the whole instance into single user mode? Or is there some way to do it with just one database?

say i'm building a dynamic sql query

set @query = 'select * from table where 1=1 '

if @somecondition = 'yes'

begin

set @query = @query + ' and x=2'

end

exec @query

It makes...

do you have the right port selected? I was having that problem. Either and and alias, or use servername, port.

hope it helps

made without using a security context

thanks!

From the little bit i've been playing with linked servers, you have to use an OLE DB driver (you could use the OLE DB ODBC driver). I've only had...

didn't work

Your accounts probably aren't going to work from one machine to the other since they aren't in the same domain (and using domain accounts) The accounts are unique on...

the command env. doesn't know where to find calcs. You can either register the directory that calcs is in as an environment variable, enter the full path to the...

should work fine.....I'd try to get the xp or 2003 version if either exists, just to be on the safe side

ooops, you want the xcacls.exe. I've got it in my support tools folder, so i'm wondering if it isn't in the XP or 2003 support tools pack. You...

It shouldn't matter which order you do it in, the share just won't work till you've done both