Viewing 15 posts - 6,916 through 6,930 (of 7,429 total)
Backup the 6.5 server in full first and restore to another location for safety and to be sure your backup does work. Next I would go with builder another server...
March 10, 2002 at 3:21 pm
Simple enough on using and why. However here I really don't agree.
quote:
Also, as more SQL Server databases grow, there will...
March 10, 2002 at 7:44 am
Yeah, really trying to get my department to move to SQL 2000 on all our servers as I can already point out about 10 improvements that would make. Especiialy with...
March 10, 2002 at 7:32 am
Did you find an answer? If not is SQLAgent service also running. I believe it checks that state as well, if not see if there is any trouble with it...
March 9, 2002 at 4:42 pm
quote:
My problem is that if in a month the number of paid members is more than 75, how to keep track of...
March 9, 2002 at 11:15 am
You can copy the code from EM and paste in QA then change CREATE PROCEDURE to ALTER PROCEDURE, make your changes and execute (note: make sure you are in the...
March 8, 2002 at 9:20 pm
Wait I think I remember why I never see ' but it does normally work.
SQL considers ' as a text delimiter for lack of a better term. I think what...
March 8, 2002 at 4:51 pm
Ok this looks right but I think it may be the ' instead of none or ". I have never seen it with a '. Try these
BCP DBsta..vWeb_Tab_Date out StatusReportDate.txt...
March 8, 2002 at 4:47 pm
I have not seen anything but we general start with 2 processors minimum for parrallel processing. Basically I would suggest doing you best guestimate with double the minimum required at...
March 8, 2002 at 4:31 pm
It is the last item on the top blue menu bar. However just look for rebuildm.exe in SQL Books Online, you will want to be carefull and I suggest the...
March 8, 2002 at 4:25 pm
Try this switch
/m maxerrors Maximum number of errors that can occur before the BCP operation is terminated. Each failed insert counts as one error. Default value is 10 (optional). If...
March 8, 2002 at 4:13 pm
You deleted all, wow I didn't think you could destroy sp_login and such with turning on access to system objects. I don't believe you can properly readd those objects and...
March 8, 2002 at 4:07 pm
Ok egg on my face, not seen those before, and they keep coming. I will have to check those out, thanks.
"Don't roll your eyes at me. I will tape them...
March 8, 2002 at 4:04 pm
However those are SQL statements not VBScript.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 8, 2002 at 3:50 pm
This is all I do all day, think about ways to do things to fix or improve our existing code. And I have had serveral situations where I needed 0...
March 8, 2002 at 3:38 pm
Viewing 15 posts - 6,916 through 6,930 (of 7,429 total)