Friday, February 24, 2012

about SET IDENTITY_INSERT

Hello,
If I did this,
SET IDENTITY_INSERT [ database. [ owner. ] ] { table } ON
how do I verify it's ON in EM?
Bingbing wrote:
> Hello,
> If I did this,
> SET IDENTITY_INSERT [ database. [ owner. ] ] { table } ON
> how do I verify it's ON in EM?
> Bing
I do not think that is possible. In fact, I'm not sure how to query that
value from T-SQL. Keep in mind that the setting is session-based and not
permanaent. If one user has the option turned on, other users cannot make
use of it.
David Gugick
Quest Software|||Hi,
Yu cant do that using Enterprise manager
Thanks
Hari
SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:D1590FF7-4DB9-4AC4-82A7-D47EFDA689EA@.microsoft.com...
> Hello,
> If I did this,
> SET IDENTITY_INSERT [ database. [ owner. ] ] { table } ON
> how do I verify it's ON in EM?
> Bing

No comments:

Post a Comment