Viewing 15 posts - 3,706 through 3,720 (of 6,216 total)
Do you get anything in the details? Does it manage to detach to start with and fail later, or not even get that far?
Andy
July 24, 2002 at 9:51 am
Which version of SQL7? Which service pack on each? Are you getting any other errors? Timeout maybe?
Andy
July 24, 2002 at 8:42 am
Passwords are stored in sysxlogins, you can move them using DTS in SQL2K, do an update query using a linked server, or there is a feature of sp_addlogin that will...
July 24, 2002 at 8:39 am
You probably also want to make sure you leave a copy of ISQL or EM open - otherwise if/when you hit the limit, you wont be able to get a...
July 23, 2002 at 4:27 pm
No problem. Posting your question is a lot like explaining it to someone else, gets you really walking through it..and often helps you find the problem without the other person...
July 23, 2002 at 4:25 pm
You can do either. Most people like the pointer, Im in favoring of actually loading the data into a blob. Several threads on the site already discussing pro's and con's....
July 23, 2002 at 3:30 pm
Thats pretty good. Only point I'd like to make is that the Update() will fire even if the column was updated to equal the original value. If you truly only...
July 23, 2002 at 3:28 pm
VB doesnt support the concept of linking. If you're already using Access it may make sense to link the tables there just to keep it all in once place. You...
July 23, 2002 at 3:27 pm
I currently support about 200 db's replicating to 200 subscriber db's on a 100m network with no issues. Issue I ran into was locking in distribution db, finally when to...
July 23, 2002 at 10:09 am
Maneffa, those are great comments, very nice to have some numbers to guesstimate from.
If you use merge or transacction with updating you'll get what you need. Since all locations...
July 23, 2002 at 7:33 am
I fall into that camp of "why use Visio" myself. Great tool, but so far I've found EM & diagrams to do a pretty good job. Open to discusson though:-)
Andy
July 22, 2002 at 4:59 pm
July 22, 2002 at 4:58 pm
July 22, 2002 at 4:57 pm
July 22, 2002 at 4:56 pm
Havent seen this or had a problem using linked servers. Tried profiling the connection to see what happens? Maybe try openrowset? Also try selecting against something even simpler, like sysobjects...
July 22, 2002 at 4:55 pm
Viewing 15 posts - 3,706 through 3,720 (of 6,216 total)