Viewing 15 posts - 37,006 through 37,020 (of 39,818 total)
I've got Erwin and the same thing occurs. IMHO, Erwin 4.0 isn't a great product, especially for a 4.0 product. No NT Auth, cumbersome design.
I tend to do things in...
October 29, 2002 at 9:04 am
You can have the traces start be setting a startup procedure and starting them in that procedure.
As far as loading into a table, not sure. Have to check. Whether you...
October 29, 2002 at 8:50 am
Which Service Pack? My SQL 2000 SP2 server (one I tested) works.
Steve Jones
October 29, 2002 at 8:43 am
Should work fine if you get the drivers. DTS doesn't require SQL Server to run and this is a great application for it. I've used it to move between Access...
October 28, 2002 at 1:15 pm
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
Viewing 15 posts - 37,006 through 37,020 (of 39,818 total)