Viewing 15 posts - 36,961 through 36,975 (of 39,769 total)
Heard good things about Marathon. Kind of $$ for most people, IMHO.
Interested to hear how it's working for you.
Steve Jones
October 28, 2002 at 1:10 pm
Winners in today's newsletter.
User Name Points
Antares686 578
chrhedga 364
rmarda 331
Steve Jones
October 28, 2002 at 10:46 am
sp_helprotect will get you most of what you want, but it will be kludgy and I think you will need to run it for someone in the role.
Steve Jones
October 28, 2002 at 10:44 am
Not sure about the VB stuff, but I believe Decimal and numeric are the largest types. Go to 38 bytes. the float and real are 8 bytes using a matissa...
October 28, 2002 at 10:20 am
Perhaps the path to the file DSN isn't correct? Or you don't have rights.
Try a simple "select @@version" with your DSN and see if that works.
Steve Jones
October 28, 2002 at 10:07 am
I do not believe you can because this file is being written to. You can set a smaller rollever, however and then grab the files once the trace has rolled...
October 28, 2002 at 10:03 am
I believe these are like the Batch Start and Stmt Start for a single line batch. You would essentially get the same information, though different events fire.
I'd only pick one...
October 28, 2002 at 9:58 am
It may be, though they are different event IDs. RPC:11, SP:Starting : 42. Not sure of the technical differnec, though I suppose there could be an RPC that wasn't a...
October 28, 2002 at 9:55 am
Thanks for the workaround. Hadn't figured out a way to do it.
One of those things that drove me crazy for awhile. Especially when it ran in interactive mode.
Steve Jones
October 28, 2002 at 9:47 am
First, there are routines to decrypt stored procs, so this isn't that secure.
SEcond, do you need to recover the login info? If not, then you can use encrypt() to encrypt...
October 25, 2002 at 2:49 pm
October 25, 2002 at 2:46 pm
Haven't used OO dbs. Heard good things about them, but they appear to be a niche. Maybe because of complexity, maybe because IBM/Oracle/MS don't push them. Don't know. CA has...
October 25, 2002 at 2:45 pm
MyConn = "driver=SQL Server;server=x.y.z.a;database=mydb;userid=me;pwd=test"
Steve Jones
October 25, 2002 at 10:48 am
I wrote some information on this in http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp. You need to get people in the habit of "checking" out the files and then editing them from the file, not the...
October 25, 2002 at 10:11 am
Not sure what you mean about doing the update.
If there are duplicate title and artists, are you trying to get the trackid values in the child table set to the...
October 25, 2002 at 10:08 am
Viewing 15 posts - 36,961 through 36,975 (of 39,769 total)