Viewing 15 posts - 5,686 through 5,700 (of 6,216 total)
Thats what, 4 processors? Half a million transactions...per minute? Day?
October 12, 2001 at 11:32 am
How many transactions are we talking? Replication usually only generates a load of 5-10% on the machine, less if multi processor. What hardware configuration, SQL version?
Andy
October 12, 2001 at 11:20 am
One way would be to capture the results in a table, then BCP/DTS it out.
Andy
October 12, 2001 at 11:16 am
I look at cpu usage, disk usage, number of connections. If I have a problem I add more to focus in on where I suspect the problem might be. I...
October 12, 2001 at 11:12 am
Not that I know of. Why would you not use replication? Replication solves all of this at very little cost.
Andy
October 12, 2001 at 11:11 am
Haven't tried it that way, but I know that you can do merge replication from SQL to Access, so that is one way you could do it. Access has its...
October 12, 2001 at 11:07 am
You might want to monitor in more detail - couple ideas I have - one, it could be doing a lot of disk reads to cache data based on a...
October 12, 2001 at 4:56 am
Cmon guys - believe it or not, I COULD have written the SQL. We're not here to do homework or class assignments or help anyone else that hasn't tried first....
October 12, 2001 at 4:54 am
The only I can see that you could make this work is if your Progress DB supports replication to a SQL 7 subscriber - if it does, then you would...
October 12, 2001 at 4:47 am
String truncation just means you're trying to push a string into a column that is not wide enough. You'll either have to identity which column it is and fix that...
October 12, 2001 at 4:45 am
Well, lets narrow it down a bit. What part does SQL Server play in your business? Does it store/generate the attachments?
Andy
October 12, 2001 at 4:43 am
I guess the first question is - do you have a requirement to backup the individual files and not the entire database? Is the value of text1.text = "Jantzen_Data"?
I'll...
October 11, 2001 at 8:17 pm
Hi Vanessa,
We'd be glad to help - how about posting your best effort so far, we'll offer suggestions from there?
Andy
October 11, 2001 at 7:25 pm
Well, at a certain point it doesn't matter about the problem, only getting it fixed. I'd suggest uninstall, then manually remove all remaining files/folders associated plus clean out the registry...
October 11, 2001 at 4:20 pm
Not aware of any issues. You might try looking at the source for sp_rename, either stepping through the debugger or make a copy and modify the source with print statements...
October 11, 2001 at 4:16 pm
Viewing 15 posts - 5,686 through 5,700 (of 6,216 total)