Viewing 15 posts - 38,611 through 38,625 (of 39,717 total)
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
Be careful in that someone could exploit dynamic sql as a security breech.
I just implement multiple stored procedures and absorb the workload.
Steve Jones
January 9, 2002 at 10:59 am
Interesting, but this still doesn't solve the key issue. Transmitting the key along with the data defeats the purpose to some extent. Any tool like profiler or a network sniffer...
January 9, 2002 at 10:55 am
January 9, 2002 at 10:54 am
January 9, 2002 at 10:50 am
Viewing 15 posts - 38,611 through 38,625 (of 39,717 total)