Viewing 15 posts - 38,431 through 38,445 (of 39,466 total)
January 7, 2002 at 10:39 am
Can you install the client tools on a workstation and see if this works?
Also, please don't use sa and blank for anything other than this test.
Steve Jones
January 7, 2002 at 10:33 am
Can you install the client tools on a workstation and see if this works?
Also, please don't use sa and blank for anything other than this test.
Steve Jones
January 7, 2002 at 10:32 am
January 7, 2002 at 10:22 am
I took the 7 test last year because there are tons of 7 sites. More than 2000 sites. It was the first very widely adopted SQL version. It will be...
January 7, 2002 at 10:17 am
I'd assume this is it:
Windows locale LCID
(locale ID)
Collation designator Code page
Hindi 0x439 Hindi Unicode only
If it isn't there, you will probably have to check with...
January 7, 2002 at 10:14 am
Is this in the SQL log or on the client? Also, what OS, Service Pack, MDAC versions?
Haven't seen it.
Steve Jones
January 7, 2002 at 10:10 am
We'll let you know if you miss post. No harm though.
One other thing, I'm not sure the performance will matter either way as the control is pretty good with either...
January 7, 2002 at 10:08 am
This:
WHERE disc_cnum, disc_num IN
IS not valid. You have to do
where disc_cnum in ( select...)
OR disc_num in (select ...)
The OR could be AND depending on your logic.
Steve Jones
January 7, 2002 at 10:00 am
Is this on all clients? Are they sure nothing was changed on the client or server? My guess is something changed, but they do not remember or do not think...
January 7, 2002 at 9:58 am
1. I'd use CHAR for < 20 characters. I think I saw something about > 20 characers not really providing any benefits.
2. Use integers. They join quicker. I'd use...
January 7, 2002 at 9:57 am
from BOL:
data_type
Is the parameter data type. All data types, including text, ntext and image, can be used as a parameter for a stored procedure. However, the cursor data type can...
January 7, 2002 at 9:50 am
I'd agree with Brian. The firewall is the best place. If this is not possible, I am not sure what you can do. Profiler does not get this (the client...
January 7, 2002 at 9:48 am
Have you checked all the data for anomolies? Can you return the individual rows directly with a select?
Steve Jones
January 7, 2002 at 9:45 am
It is resource intensive (relatively), but it works if you are not under a heavy load. It's also simple.
Steve Jones
January 4, 2002 at 5:12 pm
Viewing 15 posts - 38,431 through 38,445 (of 39,466 total)