Viewing 15 posts - 1,786 through 1,800 (of 6,216 total)
Checked permissions on the destination machine?
Andy
August 11, 2003 at 8:11 am
August 11, 2003 at 8:11 am
I agree that putting DRAFT on it is a good idea, but by the point someone else looks at it you shouldnt really expect them to find anything wrong with...
August 11, 2003 at 6:13 am
In some cases it can make a lot of difference - you're doing the work once rather than each time the query is run.
Andy
August 11, 2003 at 6:07 am
August 11, 2003 at 6:05 am
You just have to totally remove all NT users/groups as logins. Domain admins are typically allowed access because they are also members of builtin\admins, which also contains the local administrator...
August 10, 2003 at 2:15 pm
Does it occur every time? Would be interesting to profile to see exactly what is coming over when it happens.
Andy
August 10, 2003 at 2:11 pm
I think Access/VBA supports Environ$ - if so calling Environ$("computername") should work. Type set at a command prompt to see all variables accessible using this method. If not, you can...
August 10, 2003 at 8:02 am
Not sure I fully understand, but middle tier logic is always an option, especially when you're doing something that goes beyond what you can reasonably do in TSQL.
Andy
August 10, 2003 at 7:59 am
That is the simplest. Better (but more work) is to do an explicit Create #temp first, then do an insert/select to populate it. Avoids blocking issues in tempdb.
Andy
August 10, 2003 at 7:54 am
If you have a lot of changes it's easiest to drop the articles from the pub, or just drop the entire publication. Add and drop column can be done without...
August 10, 2003 at 7:53 am
August 10, 2003 at 7:51 am
Once you're connected the only difference should be the speed of the connection. Could be that you're trying to move too much info and SQL times out, or maybe the...
August 10, 2003 at 7:50 am
Check the error logs and the event log, that should show it's state, can also check running processes of course. Going from NT only to mixed should not break anything.
Andy
August 10, 2003 at 7:44 am
No easy way to find out that I can think of. If they were lazy and didnt fully qualify the table names - just doing select * from lotus instead...
August 10, 2003 at 7:40 am
Viewing 15 posts - 1,786 through 1,800 (of 6,216 total)