| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> heh
<0> indeed
<1> he's not complicated
<0> actually i kind of obtain free educations from justinm_'s mom
<0> but yeah as far as tech edu. goes
<2> but then you apply your horribly flawed logic skills on a few acronyms that you pick up and the house of cards just tumbles down doesn't it.
<0> nope
<2> or is that what happens when you interview?
<0> i got paid more money than you when i was in the US , ErrorF002
<2> ok
<1> my mother died of cancer over 3 years ago mike
<0> and i kicked ***
<0> i mean seriously
<0> they loved me so much and respected me and ****
<2> so why did you leave
<0> something that you jut dont get at your workplace
<2> house this
<2> give me your real name and a past employer
<0> therefore the tremendous envy you have towards me
<3> can you kids just stfu
<0> my name is mike peters and i used to work for a company called shoe factory
<3> no one here gives a **** about any of this
<4> hahaha: [12:12] <1> sql 2005 replication is pissing me off.
<4> he said the 'r' word
<1> stfu
<4> hahahah
<1> just cause you lack the ability to use it
<0> wow
<0> tune down the attitude justinm_..
<2> The r word is a bad word
<1> mikep rubbing off on me
<1> yep
<0> this aint #windows2003
<1> sorry guest
<4> man, if that was wine I'd have you shot for opening the bottle too early and bitching about the taste
<2> lol
<0> you all please bare with justinm_ he thinks that he's an IT admin..
<0> but in fact he's a verizon tech support representitive
<1> you know mike, some of us don't live in fictitious worlds
<1> just an fyi
<1> brb
<5> Someone just needs to ban the lot of you so you can go back to circle jerking in a channel that gives a ****.
<2> agreed
<2> and I apologize
<2> mikep actually messaged us to come here cause he was stating that e-vad was an idiot.
<0> I apologize for this behaviour. rest ***ure such a thing will not happen again.
<2> sorry for polluting your channel
<0> sigh.. again with the lies ErrorF002
<0> that's ok though.. i forgive you.
<2> at least you apologized
<0> I know how hard your life must be
<4> well I don't accept it, I feel so 'spammed'
<0> with the abuse and stuff..
<4> and this is lunch hour, dammit
<0> Guest2
<0> - /clear and everything will be put to rest.
<2> justinm_ lemme know if you want that training link
<0> i do
<1> sure error
<1> thanks dude
<2> well... some of the courses aren't free anymore :-/
<2> but the basic ones are
<2> Data Availability Features in Microsoft SQL Server 2005 looks like a good one
<0> hehe
<2> and its still free
<0> lucky for me i have a kick*** course for SQL 2005
<0> 5 dvd's
<2> wait nm
<2> the bulk of them are free
<6> no way 5 whole dvd's
<2> they just added more
<6> it must be good
<0> phargle indeed
<0> i am going to be such a kick*** SQL 2005 admin
<6> one day
<0> and get much higher pay than both ErrorF002 and justinm_ COMBAINED
<6> it might be after sql2020 has been released
<6> but yu'll get there
<2> phargle has you figured out man
<1> awesome, let me know if you need help mikep
<7> Hey guys is it possible in sql2000 to set permissions on specific tables in a db to allow only certain users access to it?
<2> yes
<1> read about the grant t sql statement
<2> and you can do it via domain accounts or sql accounts
<1> and read about roles
<2> coolblade have you loaded up the Books Online?
<2> or the BOL as it is affectionately reffered to
<0> i p***ed my instrument flight exam today
<7> No, its not actually my db, im just trying to program to it and I can access tables accept i cant open one table. Which is why I was wondering if you could set up roles like that because it seemed logical that it would be the case but wanted to make sure.
<0> Whats the difference
<1> yep typically you'd setup database roles, add SQL logins to those roles, and then grant access to roles.
<2> coolblade you should code to use an application role in that case
<7> is there a url to bol?
<1> no
<1> well
<1> it comes with enterprise manager
<1> do you have that installed
<2> you can install it off the SQL install disk
<7> no i have sql management studio express
<2> oh
<2> well you still need the SQL disk for that...
<5> http://msdn.microsoft.com/library/ has the entire bol.
<2> but then again... i have never tried looking for the bol online
<5> Just prefix searches with "sql server"
<7> thank drk'angel
<2> there you go
<0> heh ErrorF002
<2> coolblade http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_89ir.asp
<0> justin credible
<2> that may be of some use
<8> is it better to have more CPU power or more Ram?
<8> for like SQL server 2005 that is..
<8> i just would like to know a general rule of a thumb
<8> hmm
<6> ram
<8> aiite thanks
<8> i have 2 machines..
<6> increases/decreases in ram are usually exponential while cpu performance is sometimes negligible
<6> ***uming you need to ram
<8> one with 600Mhz p3 machine with 1 gig of ram and 800Mhz with 2 gig of ram..
<8> btw, first machine has 2 cpus
<8> while the latter has only 1
<8> hm i am going for the latter... thanks phargle...
<6> shirley
<3> I would compare the disks
<6> taht too
<8> disks.. they are the same...
<8> same spec and size..
<3> same speed?
<8> 7200
<8> ah. they are not even SATA..
<8> or SCSI..
<8> i am just picking out a test server
<8> test SQL server to mess around
<1> booom i fixed my replication issue
<1> aliases haven't been setup on my distribution server
<1> man... if only there was a better error mesg
<9> i go this this stmt i placed with a varchar variable with a max of 8000, ,when i execute this stmt with declares a cursor within it i get an error cause its char supercede the 8000 varchar limit, i need this statement the way it is and the reason its ina @cmd variable is because i plug in a dynamic variable into it then execute the stmt over and over,any ideas i can use to work around this problem i'm facing?
<9> i got*
<6> trim?
<9> did all that
<9> even shortened the alias names for some tbls
<0> heh
<0> aliases problem
<0> sheesh such a noob error.
<10> Using SQL SERver 2000: I want to delete all contents of a table but it gives me an error about constraints and conflicting column references, how would I go about ignoring those things and just deleting the data?
<9> and idea i have which i wil use as a last resort is actually executing a proc which will contain my cursor info
<11> Pilabyte: remove the constraints :P
<9> hehe
<6> you could create views for your tables with 1 letter table names and 1 letter column names
Return to
#sql
or
Go to some related
logs:
grade point average awk script
#mirc
#linux-noob
#beginner
L2 energade
#windows
putas a mamar
#politics
rockfish republicans
#dreamweaver
|
|