Viewing 15 posts - 53,386 through 53,400 (of 59,064 total)
First, dunno how to post CF code on this forum mostly because I've never used CF.
Still need to see code... I see that you've created a function to use the...
December 26, 2007 at 10:28 am
Outstanding! Thank you so much for the feedback, Troy. Very happy to have been able to help.
December 26, 2007 at 10:23 am
vinno369 (12/26/2007)
Jeff, unfortunately dropping the stored procedure in to Master is not an option for me.
Then, unfortunately, you're gonna need some form of loop and some dynamic SQL with a...
December 26, 2007 at 10:21 am
jacob sebastian (12/25/2007)
Jeff Moden (12/25/2007)
December 26, 2007 at 10:11 am
Post the code that you tried, Tony... it's the only way we can see what might be wrong...
December 26, 2007 at 9:55 am
I know a lot of people hate the idea but this is where I'd say "enough is enough" and drop the proc into the Master database and be done with...
December 25, 2007 at 9:20 pm
Heh... then look up anything by the user known as "Rog Pike"... 😉 A bit more than casual spam.
December 25, 2007 at 11:27 am
Ummmm... Not quite true... you can pass in a single delimited variable with named parameter pairs using either a delimited string or XML and split it in the proc....
December 25, 2007 at 11:24 am
Perfect... thanks for the feedback, Serqiy! And, long time no see... Happy holidays!
December 25, 2007 at 11:18 am
Heh... you're a sick man, Mr. Jones! MERRY CHRISTMAS!
December 25, 2007 at 12:21 am
Heh... still at it even late on Christmas Eve, huh, Steve?
Merry Christmas, my friend...
December 24, 2007 at 4:51 pm
Provided that you haven't disabled the built in administrator account...
Log into the WINDOWS server as the Administrator of the server.
Open Query Analyzer using the Windows NT authentication mode.
Run sp_password to...
December 24, 2007 at 3:42 pm
I'm basically wanting to write an in house app that will update my stored procedures across many databases that we have.
What do you want to do to the stored procedures?...
December 24, 2007 at 2:59 pm
I'll go a little further to help practicing on indexes... here's how to build a million row table of test data... the details are in the comments...
--===== Create and populate...
December 24, 2007 at 10:43 am
Viewing 15 posts - 53,386 through 53,400 (of 59,064 total)