Viewing 15 posts - 2,746 through 2,760 (of 6,216 total)
Not a great idea. Why doesnt the big table work? Maybe you could post DDL and describe the problem, perhaps we can offer you some alternatives.
For your current problem, the...
January 4, 2003 at 3:01 pm
Thats a good start, you definitely need to rebuild the indexes. I dont know that you can reduce the log usage. You might use the defrag option to do it...
January 4, 2003 at 2:59 pm
Sure. Set up a linked server first, then just write the view using fully qualified four part syntax. If your table is Test on Server A (and you create a...
January 4, 2003 at 2:56 pm
Not sure what you mean - something like you've got data from Server A and Server B both going to Server C? If you've got the same login on A...
January 3, 2003 at 5:58 pm
I try to do all this type stuff daily, keeps the volume down. Setting the timeout higher is valid for this type of operation, but you have to also look...
January 3, 2003 at 5:55 pm
I'd agree it will probably be smaller. I think Access is limited to 2g, so setting the initial size shouldnt be a big deal, and easy enough to change if...
January 3, 2003 at 5:48 pm
As I understand it (perhaps wrongly, who can decipher the damned agreements) you have all the licenses you need.
Andy
January 3, 2003 at 5:47 pm
January 3, 2003 at 9:33 am
January 2, 2003 at 4:42 pm
I hardly ever agree with him, and thats to keep him honest!
Andy
January 2, 2003 at 2:44 pm
Sure. Pretty common to include the requesting IP address to make it more helpful.
Andy
January 2, 2003 at 11:17 am
I agree with that. We added the ability to force a password reset required on next login, require password change every 90 days, three fails in 30 minutes we disable...
January 2, 2003 at 11:15 am
Is the job finishing without an error? Check the maint plan history (not the job). Deletes get done after the backup, if the backup fails - say out of space...
January 2, 2003 at 8:48 am
We're using pwdencrypt now to store some passwords for an application. Its a step up from plain text storage! We'll swap out for some tougher code later on probably, but...
January 2, 2003 at 8:45 am
Viewing 15 posts - 2,746 through 2,760 (of 6,216 total)