Viewing 15 posts - 38,356 through 38,370 (of 39,466 total)
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
yes. or whenever you create the table. If you are creating the table from Access, then use the table designer to change the key later in Enterprise Manager.
Steve Jones
January 9, 2002 at 2:02 pm
yep. hate that task. Unreliable IMHO. I stick to detach/attach or backup/restore
Steve Jones
January 9, 2002 at 2:00 pm
Something happened during install. This usually means the server is not running (that you are trying to connect to). Is it running? If so, then can you uninstall and...
January 9, 2002 at 1:58 pm
You can manually change this in the system tables, but it is not recommended. Personally I'd backup the db, drop it, recreate it as needed and restore.
Steve Jones
January 9, 2002 at 1:57 pm
January 9, 2002 at 11:01 am
Viewing 15 posts - 38,356 through 38,370 (of 39,466 total)