Viewing 15 posts - 1,156 through 1,170 (of 2,436 total)
What collation are you using ? If it is case sensitive it may appear that XXX\LOGIN could actually be xxx\Login or XXX\Login.
September 13, 2006 at 4:48 pm
In actuality you are not creating a unicode text file. By not specifying th -c (character mode) parameter your bcp out file is in the default 'native' format.
September 12, 2006 at 11:38 am
There is never time to do it right but always time to do it again.
It's time to go back to the basics - edit your parameters (API arguments) for:
September 11, 2006 at 4:23 pm
5 years ago: Fex-time. 45-50 hours a week, 5-10 hours is remote support. Telecommuting 1 day a week. Round trip travel time to/from the office 2 hours 30 minutes per...
September 11, 2006 at 4:11 pm
In my organization there is a team of "System Engineers" each with a specialty - AD, Exchange, PC Architecture, SMS/MOM and mine SQL. We all possess 3 logins: domain user,...
September 11, 2006 at 12:28 pm
RGR, we have a few specific vendor supplied applications that require the entrie server, not just the database, to use Latin_1_General_Bin. These SQL Servers interface to AS400's and related applications...
September 6, 2006 at 2:08 pm
Sybase and SQL Server were once the same beast - I mean absolutely identical - just different labels (Sybase 4.9.2 and SQL v4.21). At present you could call them different...
September 1, 2006 at 11:29 am
You may want to check the Wins setting on your server NIC card(s).
September 1, 2006 at 10:25 am
A few questions first ...
September 1, 2006 at 10:16 am
Jason - there is no such thing as a 'typical' day froa DBA. You will probably find as many definitions for a 'typical' day as there are opinions amongst the...
September 1, 2006 at 10:08 am
The biggest issue with autogrowth is that it will usualy occur at the most inopportune moment. I'll not touch the growth parameters since that coiuld be another entire thread. What helps...
September 1, 2006 at 10:01 am
Since you are using SQL Server authentication the issue of different domains should not matter. I'd first try to ping the SQL Server. If that works then try a telnet...
September 1, 2006 at 9:43 am
Try looking at a function whose name begins with: USP_GET_ENCODED_DATA
If you can replace it's functionality, and things then woork then it's the culprit. But for the actual cause and fix...
August 31, 2006 at 11:37 am
Buy new and use the old machine as is for dev/test or even take it home for the kids.
August 29, 2006 at 9:54 am
Viewing 15 posts - 1,156 through 1,170 (of 2,436 total)