Viewing 15 posts - 2,116 through 2,130 (of 6,216 total)
He has a good sense of humor, I've got an article coming up about how I discovered his double in a movie!
Andy
May 21, 2003 at 5:28 am
It's ok, but a lot of effort to add a step to every job, then when you change something, have to change them all possibly. How about just reporting from...
May 21, 2003 at 5:27 am
With .Net it defaults to 100, think you can change with a param in the connect string. Probably about the same for ADO. You might try looking for the MDAC...
May 21, 2003 at 5:25 am
Perhaps. Then again, when you see Steve at PASS, how about calling it sIquell or C-cule or some other mad distortion - see if Steve takes his own medicine!
Andy
May 21, 2003 at 4:11 am
How about checking the file size too, if it's larger, you know it was a grow and not a shrink?
Andy
May 21, 2003 at 4:06 am
You'd think the marketing dudes would have the foresight to have a product name that was crystal clear - who needs another tomayto vs tomahto discussion?!
Besides, isn't SQL 2000 the...
May 20, 2003 at 5:16 am
SQL-DMO will let you get the script for any object, should have some sample code somewhere on the site. Alternatively, you could query syscomments using the object id of the...
May 19, 2003 at 8:18 am
Dont know what else to try. If you're realllly curious, you could could profile while you make the change, see if you see what is happening - maybe a transaction...
May 19, 2003 at 8:16 am
The ID for the login and the user are mis-matched. Take a look at BOL about the proc sp_change_users_login, or do a search here on the site, should find tons...
May 19, 2003 at 5:24 am
I've only got one named instance installed on a dev server, haven't had issues that I can recall, I'll try to remember to stop/start to see what happens.
Andy
May 16, 2003 at 2:17 pm
Hard to find good AND free. Log Explorer worth money. Start asking now, might get in next years budget.
Andy
May 16, 2003 at 2:15 pm
Do we have a winner? Or do we think there might yet be a better, faster solution?
Andy
May 16, 2003 at 7:57 am
I can see making it configurable at the user level. We'll add to the list, but it's a ways down on a big list!
Andy
May 16, 2003 at 5:22 am
I'm lucky enough enough to work in a system where we either A, do optimistic locking and last update wins, or we update an owner column with the user's systemid...
May 16, 2003 at 5:20 am
Fixing the file names saves a lot of headaches, worth the extra minute to do.
Andy
May 16, 2003 at 5:17 am
Viewing 15 posts - 2,116 through 2,130 (of 6,216 total)