| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> the discussion that went on last night was a blast
<1> Which one?
<0> the one about religion?
<1> ah, joy
<2> damn i missed it
<2> so are we all burning in hell or what?
<1> There are channels more appropriate for that nonsense.
<0> we are burning
<2> nice
<3> how to make a constrait or check for a valid email address?
<4> validate it in your front end language
<4> sql isn't that great for that type of stuff
<4> you just need a good regex for it
<2> but if you're really desperate you could do a before insert trigger
<4> here's the one i use, with case insensitive flag: ^['_a-z0-9-]+(\.['_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a-z]{2,3})|(aero|coop|info|museum|name))$
<4> handles country domains as well
<3> thanks!
<3> sincerly, i don't know regexp that much :p
<4> you don't need to, now.
<3> hehe
<3> mmm
<3> let me remember
<3> is it valid aa..@aad.com?
<4> that may p***
<3> it does p*** i think :p
<3> thanks :)
<5> hrm, can you configure an update query to update just the first of a set of matching rows?
<6> if i have a txt file that contains a sql script and i want to run it, whats the easiest way on SQL Server 2005?
<7> hrm, wtf would cause a program to keep starting in windows when you log in ...
<8> msconfig
<7> it's not spyware, it's a regular application, I used it last on friday ... and yesterday it started up, and now today ..
<7> it's not in the startup folder in start menu, or in the Run registry entry
<1> zoul: http://www.sysinternals.com/Utilities/Autoruns.html
<6> why do i get an error when i try to run this stored function in sql 2005, dbo.fnGeocode('','123','MAIN','ST',14333,-1,-1) the error I'm getting is incorrect syntax near ''
<6> ?
<1> Sounds like you're confusing functions with procedures.
<6> yea whats the difference Halo
<6> sorry I'm new to functions
<6> I've used stored procedures before, but whats the difference with a function?
<1> Functions are called inline with expressions, just like built-in functions.
<6> ah i see..so if i want to test a function?
<6> whats the easiest way
<6> a select
<8> select dbo.fnGeocode('','123','MAIN','ST',14333,-1,-1)
<6> that contains the function
<6> ok
<1> SET @x = dbo.MyFunction(@y); or SELECT dbo.GetFirstName(name) AS FirstName FROM MyTable
<6> thanks thats what i thought
<6> have you seen this guy who made a free geocoder...its amazing
<6> you can download the tiger database to your pc and get a geocoder running on it
<6> Halo_Four I have a text file that contains a sql script i want to run on a database
<6> whats the easiest way to do that in sql 2005?
<6> anyone please?
<8> google?
<9> read the books on basics
<9> heh
<6> nevermind
<6> it was working just importing to the master db
<7> bah, I got p***ed up on the lead php developer position ..
<10> lol
<11> hello
<7> good bye
<12> do you guys know of any free software for monitoring the health of an MS SQL 2000 Server?
<12> that'll page/email you if stuff goes wrong
<13> drakh, nagios
<13> free, awesome, even if you do put it up against a horrible db like ms sql
<12> thanks alot, I'll investigate!
<12> looks like it doesn't notify though right
<13> "right"?
<13> itll email, call, sms, you can write a plugin to aol im
<12> wow, all for free?
<13> drakh, look at the older 1.3 version not the new 2.0 one that isnt done yet
<13> drakh, do you have a linux box available?
<12> yes
<12> http://www.nagios.org/products/
<13> ok what distro is on it?
<12> the notification section is confusing me
<12> it would be debian
<13> its free, they advertize sms provders who give them kickbacks
<13> would be, or is?
<10> lol
<12> I don't get why they'd advertise notification services if they offer it
<12> would be
<13> because you need to read whats included
<12> k
<13> "solutions"
<13> download the 1.3 tarball
<12> thanks again
<14> hi guys :)
<13> and then the official plugins
<12> roger
<13> i would recommend putting cygwin on the ms sql server
<12> k
<13> and enabling ssh and such. it works off ssh and ssh keys (you can get host side plugins but none for ms sql)
<13> sort, you will ssh to the ms sql server and kick off a isql or osql.exe and script
<13> you run a query and it returns 1 line back to nagios. depending on the contents of that line.. you have OK Critical or warning
<13> you can find alot of other plugins at nagios exchange. like one for windows that will let you connect directly without needing ssh for stuff like disk space and cpu load
<14> question: MSSQL2000 + SQLXML / when you convert SQL to XML using "for XML explicit" how do you save the results down as a XML document with ASP?
<12> ok, thanks
<13> drakh, do you have a cellphone with messaging?
<13> easiest is emailing like 6095551212@mmode.com if it gets sent to your phone
<13> and you have unlimited sms messaging for $5 more a month
<12> yes, i would do that jarett
<13> i use check_nt an older plugin
<13> i havent upgraded to any of the nrpe daemon stuff.
<13> i guess i just like to rely on ssh for most things
<13> same with why i limit my snmp to only my routers
<13> drakh, you can turn any script into a check plugin... so if you have perl in cygwin with the win32 libraries or activestate perl loaded you can use any script on the web you find (disk space, database checks) anything... i guess you could use vbs as well. anything that can be executed from the command line and return a line back
<15> ah
<13> and then i use mrtg to chart all the stats on all my servers from parsing the nagios logs
<14> anyone here worked with MS SQLXML 3.0? I can generate my XML from the SQL query with no problems but its just retrieving the XML it has generated. So I can save it as an xml file.
<13> theres other ways to do all of this but i found this to be the easiest and most stable
<13> if a manager asks "whats our data growth for the last year" I can show a little picture since managers dont understand numbers
<13> "see this green line, how it has spiked, thats alot of data"
<13> drakh, i would recommend centos 3.5 or maybe 4.0 though
<13> instead of debian.
<13> its a community compile of redhat enterprise
<12> why
<12> what does centos offer that debian doesn't
<13> more stable, more support, easier to find trouble ***istance for problems
<13> since all you have to do is look on redhats bug tracker
<13> its redhat enterprise :P
<13> plus in the future on jobs you can say you are experienced in rhel
<13> drakh, what % of you network or datacenter is non windows?
<13> not including desktops
<10> heh
<10> HI IMEXPERIENCEE IN NAGIS
<13> its one of the most popular service monitoring platforms there is
<12> what
<12> more stable
<12> do you have any idea _how_ stable debian is
<13> yep
<15> if i want to handle sproc errors on the client side, is return @error the prefered method or raiseerror?
<13> and do you have any idea what the reaction people in an interview is when they used a non enterprise os?
<12> i don't care
<12> debian = enterprise
<13> "you mean you have no experience with suse or rhel? bye"
<12> lol
<13> drakh, does oracle certify on it? or unisys or ca?
<13> thats whats important.
<12> not in this case
<13> not which 3l33t linux poser uses it
<12> ack, don't call debian 3l33t!
<10> rofl
<12> lol
<13> oracle actually used debian for a project... for a cd bootable settop box :P
Return to
#sql
or
Go to some related
logs:
window washer list index out of bounds
#linux-noob
#windows
#solaris
#vmware
#nhl
#stocks
#flash
cue points geturl
#nhl
|
|