Viewing 15 posts - 38,341 through 38,355 (of 39,456 total)
January 10, 2002 at 12:29 pm
Interesting. Haven't had issues and I do this type of import all the time, though usually from Excel.
Are you positive there is no mapping from some field inthe text file...
January 10, 2002 at 12:25 pm
How are you getting the data in there. If this is a word document you are dropping in the field, there is overhead from Word that includes non-printables.
I'd go with...
January 10, 2002 at 11:08 am
January 10, 2002 at 11:00 am
This sounds like a permissions issue. Can you open this file using notepad?
Steve Jones
January 10, 2002 at 10:58 am
Keep in mind that SQL Mail runs as the SQLAgent user. you should log into the SERVER using the account that SQLAgent is running under. You then setup Outlook and...
January 10, 2002 at 10:38 am
January 10, 2002 at 10:24 am
Do you mean you ahve an XSL and XML template in your virtual directory?
Once you have the virtual directory, are you submitting a query bia url?
Steve Jones
January 10, 2002 at 10:10 am
Is there a user defined type in the source database? If so, it might not be being transferred and this would cause an error on the destination.
Steve Jones
January 10, 2002 at 10:01 am
January 9, 2002 at 4:29 pm
January 9, 2002 at 4:24 pm
January 9, 2002 at 3:25 pm
are you trying to insert the identity field? Can you post the DDL for the talbe and the text file?
Steve Jones
January 9, 2002 at 2:25 pm
you are welcome. It's better than editing system tables.
BTW, be sure you track you login/user mappings in case you need to manually fix this.
Steve Jones
January 9, 2002 at 2:08 pm
you can do this:
delete x
from product x
where x.name = 'test'
I don't think this is required and I've not used it to delete temp tables.
The first delete works below,...
January 9, 2002 at 2:07 pm
Viewing 15 posts - 38,341 through 38,355 (of 39,456 total)