A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Joined: Sep 19, 2005
Oct 04, 2005 22:46:00
I want to identify if a table has an "IDENTITY_INSERT" property using
is there any method to identify that...
database : MSSQLServer.
Thanks in advance.
Joined: Aug 04, 2004
Oct 05, 2005 02:13:00
No, this is something MSSQL specific, so use some MSSQL mechanism to detect this. There are lot of system stored procedures which should give you this information.
SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
It is sorta covered in the
JavaRanch Style Guide
Identity feild in Sybase.
Problem with OJB
Delete file when the file downloaded.
Identifying use cases
Trying to send "SET IDENTITY_INSERT...ON"
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014