Viewing 15 posts - 6,286 through 6,300 (of 7,429 total)
Can you post your bcp command line and if using a format file post it's contents?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
April 24, 2002 at 12:57 pm
Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q267550 and see if this applies to your case.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 12:53 pm
From BOL
quote:
You want to enforce uniqueness in a column that allows null values. You can attach unique constraints to columns that...
April 24, 2002 at 12:42 pm
If for some reason the DB gets upgraded by 2000 then you will not be able to put back. Have not heard of any direct issues otherwise but I would...
April 24, 2002 at 6:01 am
With SQL 7 none of those may free the log to allow it to shrink even thou the data is dumped. However here http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26 is a script to force the...
April 24, 2002 at 6:00 am
I still think something is left in one of the subfolders that is causing this. You stated the log files are on a seperate drive. I am refering to the...
April 24, 2002 at 5:12 am
Check out these items on the MS KB Site http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=22029&Queryc=22029&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25 and see if any of those apply. Usually is related if you are trying to do a transaction log backup...
April 24, 2002 at 4:42 am
Great to hear, I figured something had to be changing it.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 4:13 am
This is normal, the data files should still be in the old 7 path, they did not get moved. Also most things like log files are not moved as well....
April 24, 2002 at 4:10 am
Here i is with the HASH hint for the join.
SELECT
a.user_id,
a.mach_id,
loc.descp lc_descp,
plat.descp plat_descp,
rm.descp rm_descp,
CASE a.network_ind
WHEN '1' THEN 'Yes'
WHEN '2' THEN 'No'
END net_ind,
spd.descp spd_descp,
a.mach_platform_other
FROM...
April 24, 2002 at 4:08 am
Try this in Query Analyzer with Show Execution Plan turned on.
SELECT
a.user_id,
a.mach_id,
loc.descp lc_descp,
plat.descp plat_descp,
rm.descp rm_descp,
CASE a.network_ind
WHEN '1' THEN 'Yes'
WHEN '2' THEN 'No'
END net_ind,
spd.descp spd_descp,...
April 23, 2002 at 8:02 pm
When you ask if it can nest on itself directly with nothing else the answer is no. If you are talking about a while loop and collect the data as...
April 23, 2002 at 7:45 pm
First why are you generating the first 2 tables if you are going to union these results together just do the 2 queries unioned instead. Also how do you create...
April 23, 2002 at 7:44 pm
No body can be active in it icluding the person issuing the command. When you get this error testing immediately check from QA sp_who or sp_who2 to see what connections...
April 23, 2002 at 7:40 pm
Can you post the text data from the format file (you can open it in notepad), I just want to see what it thinks should be going on.
"Don't roll your...
April 23, 2002 at 7:25 pm
Viewing 15 posts - 6,286 through 6,300 (of 7,429 total)