| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> so normally i could configure the machine myself
<0> so now i have to email these peopele who claim they dont know anything about anything .. blah blah blah
<1> yup
<1> download the demo ver and see for yourself - then you can talk them through it
<0> demo of what?
<0> sql05
<0> i have it here on one of my dev servers
<1> <0> : theen you'l know what to do
<0> it kind of new to me 2, but im sure i can find it (now that ive said that i wont)
<2> morning YuppieMOB
<2> you in th emob?
<2> the mob rater
<2> rather rather
<1> well, the option is v obvious, and its documented too - took me about 5 mins to fix on my 1st 2k5 install
<1> s<2> : nah - mobile
<1> sitting by pool in luxor
<2> nice
<2> vegas?
<2> ie the Luxor hotel?
<1> google for 'old winter palace' in egypt
<2> oh
<3> hey
<2> the real luxor?
<1> original...
<2> wow
<3> anybody here migrated sql 2k to sql 2k5 ?
<2> nice
<1> hey
<2> I like the vegas version better than the egyptian version
<3> I'm noticing that some "joins" behave differnetly? this supposedly documented somewhere?
<2> more booze gambling and liqour
<1> <3> : nfi - all mine have been clean... no upgrades
<3> :-/
<1> sorry
<3> this is extremely odd
<3> ohhhhhhhh
<3> my identities are getting ****ed up when i export the data
<3> hummm
<3> ****
<3> theres like little to nill custoizing on sql 2k5's import/export data
<3> is there any way in sql 2k5 to "maintain" ids when importing ?
<3> so a row that has an id of 10 keeps that id of 10 ?
<3> and doesnt get an id of 1 because sql 2k5 decides to give it that ?
<3> wow. that is unbelievable
<4> Import with identity turned off, then alter the table to turn id on and start the seed where it should.
<3> heh
<3> so i gotta go through an edit
<3> 40+ tables?
<1> set insert_identity on
<1> boo-hoo
<1> biab
<5> hi.. sql2000 is it save to delete the contents of C:\MSSQL\BACKUP folder.. its just our dev server and really no need for these backups that are several years old
<5> err *safe to delete
<3> heh that kind of depends
<5> the databases that we depend on for backup etc are on our live server
<6> The server doesn't rely on them at all.
<6> So it's more of a business decision
<5> and deleting them with the windows file system is okay
<3> yes
<5> or is there a "via enterprise manager" way better
<5> okay thanks everyone
<3> heh
<3> ehhh set identity_insert isn't going to work for exporting/importing unless ms sql does it manually
<3> so why the heck cant i find an option to turn it on in ms sql 2k5 import
<6> It's an option in the column mappings dialog
<3> so for every table you have to go in and do it?
<6> yes
<3> wow
<3> so often it feels like youtake 3 steps foprward and 2 steps back and 1 to the left
<6> It's in the same exact place it was in 2000.
<3> hmmm
<3> i wonder why i've never had this problem with sql 2k5's exporting
<6> Because it has nothing to do with exporting.
<6> Identity insert is purely an import feature.
<3> ermm
<3> sql 2k's importing/exporting
<6> The dialog looks almost identical to the dialog in 2000.
<3> hmm so i guess i just gotta strip all of the identity inserts on and all of them off
<3> heh
<3> exact same exportin/importing options
<1> why not just backup&restore the db?
<3> because i've seen peopole having problems doing that
<3> and thus i was hoping this would be a less painful method
<3> heh and you cant hit escape or enter in the column mapping dialog
<3> so that you dont have to move your mouse cursor - so you dont lose place in your list or 40+ dbs s
<1> grab the evAl f dbartisan, and let it do the xfer...
<3> wow
<3> lots of korean spam lately
<3> bwuaha
<3> i think i got it
<3> or maybe not
<3> teh alter table statements didn't work :(
<3> ****
<3> 0oh i see
<3> no matter how mjucuy ui think you can outsmart micrsofot you cant
<7> anyone have experience with pure xml based search/storage? i have a large database whose data is almost purely hierarchical that would translate well to xml document storage, but am concerned that traditional rdbms operations (search, browse, etc) would suffer performance wise, any comments
<1> <7> : you're right
<7> conversely, given how the data is hierarchical, returning resultsets returns a lot of duplicated data at higher levels of the hierarchy
<1> take a look on www.thedailywtf.om - the was a good example abot a week ago
<1> com
<7> k
<1> and yes it will
<1> square peg, round hole
<7> thedailywtf.com ?
<7> not coming up for me
<1> loive with it
<1> .com not .om
<7> well, i have a square peg in a square hole now but need to find ways to increase performance and scalability
<7> i know
<7> does it load for you?
<7> maybe without the the?
<7> erm, no
<3> attempt #72020202
<3> heh microsofts previous dialogs in sql 2k were esca;e/cancel friendly - their new ones werent
<3> thats gotta be some pretty ****ing ****ty qa usability testing
<1> all bets off on mobile connection
<3> lol
<3> AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
<3> i ****ing went through and checkmarked "enable identity insert"
<3> on every single ****ing table
<3> 40+ ****ing tables
<3> 120+ ****ing clicks
<3> and it still changed all of the identies, referential or not
<3> an operation that should take 5 minutes
<3> copy table design, copy data. bam done
<8> Arrakis sup
<8> hehe
<3> i want to kill
<8> you just trying to copy tables from 1 db to another?
<3> that stupid ****ing long *** haired hippie
<3> yes
<3> something that you would think takes 5 minutes to setup + time to copy data over 3 networks
<8> can't you just create the tables w/o identity & FK constraints, copy data, then add constraints/identity?
<3> is there an easy way to do that
<3> on 40 tables?
<3> no there is not
<3> you have to go in and manually ****ing edit every single ****ing one of them
<8> i use excel a lot of the time actually to do **** like that
<3> which in sql management studip now - opening the modify a table takes about 15-30 seconds
<8> but maybe not for this
<3> nothing touches sql 2k5
<8> you can't use DTS?
<3> nope
<3> 30 "unkknown" errors
<3> that nobody else has posted blogs on how to fix
<8> :( that ****s
<3> mo9st of them are errors with SPIS packages
<3> or some shizola
<8> i am with you on 2k5's admin tools btw
Return to
#sql
or
Go to some related
logs:
#linux-noob
oblivion gender change mod
#beginner
#computers
gopbl
#computers
#winxp
#computers
#politics
#linux-noob
|
|