Viewing 15 posts - 2,641 through 2,655 (of 6,216 total)
Data Compare is decent, I've got a review up if you want to look into it more. Downside is that it doesn't do text columns. They let you download a...
January 22, 2003 at 2:00 pm
Set a flag someplace. Either a row in a table, a file on disk, whatever. That way you can run the server side job more often (sooner really), if its...
January 22, 2003 at 1:53 pm
Not bad. Havent spent much time in ASP.Net yet, have seen the demo's of the sql persistence, again, not bad. Using tempdb aint my favorite solution, is it configurable?
Andy
January 22, 2003 at 1:51 pm
Xp_cmdshell 'dir' will get you started. You'll have to provide the path to the folder containing the file to see the file name, worst case start at 'dir c:', work...
January 22, 2003 at 11:20 am
If its internal you could copy instead of FTP. Easy enough to put the client piece in a batch file or write a mini app to make it easy for...
January 22, 2003 at 10:51 am
I usually set up an alias using the client utility - it lets you set the port.
Andy
January 22, 2003 at 5:58 am
I will have to run through it again and verify - Im always dbo so I dont really use it! No issues I know of with the alias.
Andy
January 22, 2003 at 3:27 am
Think you need to run sp_changeobjectowner from QA. You can configure the owner when you set up replication via the wizard also. An alternative is to alias your login as...
January 21, 2003 at 5:55 pm
So you'd drop/recreate your staging table each time? If so, replication not a good answer, probably better to just write a set of update procs to apply the changes -...
January 21, 2003 at 5:53 pm
If you use a VPN its reasonably secure. Another option would be to zip with password (or find a similar compression util with better security) and FTP. Depending on size...
January 21, 2003 at 5:49 pm
I dont disagree, but I still dont quite practice all of Steve's wisdom yet. I try to avoid live changes, but in the environment/pace I have, sometimes I take the...
January 21, 2003 at 5:47 pm
I've tried Visio, is ok. Have not tried Erwin. Hopefully we'll get others with more lengthy opinions!
Andy
January 21, 2003 at 5:37 pm
No differences that I know of on the image types. Havent seen a more detailed page myself.
Andy
January 21, 2003 at 4:59 am
We used to this do a lot across a slow WAN (4 T-1). It works, but does tend to be slow. Its not Access fault for the most part -...
January 21, 2003 at 4:57 am
Have to use a cursor. In general you should try to do set based operations, especially in triggers. Triggers should be light weight and fast. There are times where you...
January 20, 2003 at 6:25 pm
Viewing 15 posts - 2,641 through 2,655 (of 6,216 total)