Viewing 15 posts - 3,586 through 3,600 (of 6,216 total)
Interesting points. On the replication one I'll try to find time to experiment, might be possible to override the behavior in the replication sequence.
Thanks to all for their comments. The...
August 1, 2002 at 8:54 am
Could you post the query plans running in both modes?
Andy
August 1, 2002 at 8:54 am
We had another post about this recently, dont know that we had an answer. Have you recently added an indexed view?
Andy
August 1, 2002 at 3:53 am
The return from sp_spaceused should always be the same so you could predefine the layout. Select into will work if you use openrowset as the "from" and put the proc...
July 31, 2002 at 8:18 pm
I saw this today too - looks like 3 different patches? They couldnt do an all in one?!
Andy
July 31, 2002 at 8:16 pm
I dont think we have anything like that so far. Might try browsing on the MS site some.
Andy
July 31, 2002 at 6:41 pm
Shouldnt need to reboot. I'll try to check tomorrow to see what mine says at work.
Andy
July 31, 2002 at 6:40 pm
Generally...very generally...you grant access to all the tables needed by the application, then the application controls who can change what and how. This way you can enforce additional business logic...
July 31, 2002 at 6:39 pm
Haven't seen this, not running XP on my machines yet. Find anything out yet?
Andy
July 31, 2002 at 6:39 pm
I would double check the permissions on those tables. For example, on my machine at home sysconfigures has select permission granted to public. Look for a red X on a...
July 31, 2002 at 6:35 pm
Depending on the amount of data its not impossible to copy/paste, though I'll admit its not the preferred technique. Normally when I move something I'll record counts of all tables...
July 31, 2002 at 6:33 pm
Anyone follow up on this? Interested to hear how it went if you did!
Andy
July 31, 2002 at 6:31 pm
Thats a lot to answer. Let me throw out a few things, maybe we can break the rest up into bite size pieces.
Temp tables in SQL are private to the...
July 31, 2002 at 6:30 pm
Strange indeed. Might want to try the newsgroups on this one.
Andy
July 31, 2002 at 6:23 pm
Dont know. Why would it matter? A date is a date, formatting is normally a separate issue.
Andy
July 31, 2002 at 6:22 pm
Viewing 15 posts - 3,586 through 3,600 (of 6,216 total)