Viewing 15 posts - 36,916 through 36,930 (of 39,720 total)
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
Is this SQL Server 2000? If so, the restoring to other servers isn't a big deal. Can always attach files from whatever drive they are on.
As far as performance. From...
October 25, 2002 at 9:56 am
<shamelessplug> Brian's Admin 911 book is a good beginner place to learn about admin'ing SQL Server.
</shamelessplug>
For designing tables, it works similar to Access, though I'd grab any of the "application"...
October 25, 2002 at 9:50 am
Not really appropriate for the the suggestions forum. This is more of a Development issue.
Pls post there.
Steve Jones
October 25, 2002 at 9:47 am
Not to play devil's advocate, becuase I get as annoyed as anyone with subject lines that don't pertain to the message. Same with cross posts.
However, the have been times that...
October 25, 2002 at 9:45 am
Viewing 15 posts - 36,916 through 36,930 (of 39,720 total)