Viewing 15 posts - 38,596 through 38,610 (of 39,717 total)
An identity column has no "relationships" by default. If you want an identity to be the PK or an FK, you set that separately. If you reset the identity value,...
January 10, 2002 at 3:33 pm
January 10, 2002 at 3:01 pm
January 10, 2002 at 1:08 pm
January 10, 2002 at 1:08 pm
Whats the error? Looks ok, but I'm not sure .Move will overwrite. you might need to delete first.
Steve Jones
January 10, 2002 at 1:07 pm
yes for both?
Try a query into the URL, something simple like SELECT%20*%20FROM%20%pubs.dbo.orders
Steve Jones
January 10, 2002 at 12:31 pm
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
Viewing 15 posts - 38,596 through 38,610 (of 39,717 total)