Viewing 15 posts - 2,221 through 2,235 (of 6,216 total)
That list seems close. Tried the lastest DW? http://www.dependencywalker.com. Has a mode to monitor a running process. Might try this link:
http://support.microsoft.com/?kbid=288910
Andy
April 21, 2003 at 4:59 pm
Why do you consider that a better approach than building the statement in the app?
Nice screen name, though Im not a huge fan of SIG!
Andy
April 21, 2003 at 10:46 am
Sp_depends will give you some of it - isn't always 100% accurate since SQL allows you to reference objects not yet created.
Andy
April 21, 2003 at 9:51 am
From QA only? If you use an ADO stream, I don't think you'll have this issue.
Andy
April 21, 2003 at 9:48 am
You're absolutely sure the user is not orphaned from the login? How about querying sysprotects to see if rows are in there for the permissions?
Andy
April 21, 2003 at 9:46 am
There is a trace flag (257) that makes the output a little easier to work with.
Andy
April 21, 2003 at 9:14 am
Catch it where? In the proc or the calling app?
Andy
April 21, 2003 at 9:12 am
Don't recall ever seeing this happen without explicitly setting it.
Andy
April 21, 2003 at 9:10 am
Bind queries - as in true ODBC binding?
Thank you all for your comments so far. Yes, faster execution with a compiled query plan - usually only makes a difference if...
April 21, 2003 at 9:08 am
If you set new permissions on an object, does it then show up ok, you can script back out? If so then you had a problem with the restore, permissions...
April 20, 2003 at 4:30 pm
Did you select client tools when you did the upgrade? Sure you're running the right exe? Been a while, not sure it removes the old QA.
Andy
April 20, 2003 at 1:52 pm
I still think simple works. When they post the page, you test each set of witnesses, if not blank you do the insert. Worst case, you do five inserts. Most...
April 19, 2003 at 5:03 pm
Well..lot's of options. Without seeing all the code, hard to give a really great recommendation. I'll add a couple more comments, maybe other readers can add to it.
XML is pretty...
April 19, 2003 at 11:56 am
I dont see anything wrong with that. One way to avoid multiple calls to the server is to define 5 sets of parameters for your proc, then you test each...
April 19, 2003 at 9:36 am
Guess Im not sure what interface you mean. Upgrading from SQL7 to 2K is relatively painless, can be done in place. Clients apps will work just the same as long...
April 19, 2003 at 9:33 am
Viewing 15 posts - 2,221 through 2,235 (of 6,216 total)