No announcements
Found 1631401 threads
-
0 Votes
IDENTYTY_INSERT is set to OFF.
Perhaps you would be better off ask this question in MS Access forum...Unanswered | 1 Replies | 550 Views | Created by DagF - Thursday, January 23, 2020 8:10 AM | Last reply by Uri Dimant - Thursday, January 23, 2020 9:44 AM -
0 Votes
IDENTYTY_INSERT is set to OFF.
Since MS Office updateed on build 12325.20288 I receive error IDENTYTY_INSERT is set to OFF. ...Unanswered | 2 Replies | 759 Views | Created by DagF - Thursday, January 23, 2020 1:13 PM | Last reply by Karl Donaubauer - Thursday, January 23, 2020 1:26 PM -
0 Votes
IDENTYTY_INSERT is set to OFF. (#544)
Since office updates 12325.20288 I receive the folowing error IDENTYTY_INSERT is set to OFF. (#544) when i want to add a ...Proposed | 3 Replies | 878 Views | Created by DagF - Tuesday, January 14, 2020 9:19 AM | Last reply by Rachel_Wang - Wednesday, January 15, 2020 6:37 AM -
0 Votes
Reverse accidentially overiding the err object
I actually went to the Object Browser and searched for ERR, turns out, I hadn't renamed the form field that referred to the query field, so there was still an ERR.Answered | 3 Replies | 1712 Views | Created by Barry Smith -XYZ- - Friday, April 27, 2012 8:55 AM | Last reply by Barry Smith -XYZ- - Friday, April 27, 2012 9:45 AM -
1 Votes
Err vs.
OK, that helps - I'll avoid using the Err properties.Answered | 3 Replies | 4671 Views | Created by Jay W. _ - Monday, March 16, 2009 8:55 PM | Last reply by Jason Kresowaty - Wednesday, March 18, 2009 1:48 AM -
1 Votes
Getting Deadlocked Schedulers err
I’m getting * Deadlocked Schedulers err msg on two instances and it’s causing all the instances not be accessible.Answered | 1 Replies | 3821 Views | Created by Alex Polinskaya - Wednesday, October 26, 2011 9:03 PM | Last reply by Sergei T - Thursday, October 27, 2011 8:13 AM -
0 Votes
Set autocommit OFF in oracledataprovider
I am not Oracle person, but if Oracle provider follows same pattern as SQL Server then you could execute SET AUTOCOMMIT OFF command using ExecuteNonQuery method of the Command ...Answered | 2 Replies | 4909 Views | Created by stokarchuk - Wednesday, March 4, 2009 8:41 PM | Last reply by Jimmy Hutson - Friday, March 20, 2009 8:37 PM -
0 Votes
set encryption off
Hi, I restore Master key after dropping it just to do tests and i restored certificate backed up .. i create a Database encryption key and finally i set encryption on .. ...Answered | 3 Replies | 14041 Views | Created by Dora_TDE - Wednesday, February 16, 2011 6:03 PM | Last reply by SCEFails - Tuesday, April 28, 2015 5:43 PM -
1 Votes
SET QOUTED_IDENTIFIER ON/OFF
SET QUOTED_IDENTIFIER ON CREATE TABLE "TABLE" (abcAnswered | 2 Replies | 4982 Views | Created by mj_developer - Saturday, January 9, 2010 9:30 PM | Last reply by Ranjith Kumar S - Sunday, January 10, 2010 11:03 AM -
1 Votes
CTE Err Help
I need your help with this err; Msg 207, Level 16, State 1, Line 31 Invalid column name 'CustomProperty09'.Answered | 3 Replies | 1870 Views | Created by emmim44 - Wednesday, September 12, 2012 6:50 AM | Last reply by emmim44 - Wednesday, September 12, 2012 7:38 AM -
3 Votes
sql syntax err
NOINIT will keep appending the (zipfile) a file with every backup I run NAME =N'Selected Databases Backup from BICDB-TXD', -- It is just a name we can ...Answered | 6 Replies | 878 Views | Created by Neilcse - Sunday, October 28, 2018 6:45 PM | Last reply by Erland Sommarskog - Tuesday, October 30, 2018 10:21 PM -
1 Votes
SET Quoted_Identifier ON/OFF
My guess is that the procedure was deployed with SQLCMD, which by default connects with QUOTED_IDENTIFIER OFF.Answered | 6 Replies | 2563 Views | Created by VinodKan - Wednesday, June 10, 2015 2:15 PM | Last reply by Erland Sommarskog - Wednesday, June 10, 2015 9:30 PM -
4 Votes
SQL Server set ansi_null_default off
thanks alter database CloseMonitoring set ansi_null_default ...Answered | 9 Replies | 4664 Views | Created by shamas2121 - Tuesday, January 28, 2014 11:36 AM | Last reply by Darren Woodford - Monday, April 29, 2019 11:18 AM -
0 Votes
IDENTITY_INSERT is set to OFF
BOL example: " -- SET IDENTITY_INSERT to ON.Answered | 2 Replies | 4121 Views | Created by Philosophiae - Thursday, March 14, 2013 5:56 PM | Last reply by Kalman Toth - Friday, March 15, 2013 2:41 PM -
0 Votes
Settings Implementation Issue - Unable to turn off Setting
Yep, I'm using Callisto for Settings.Answered | 6 Replies | 1811 Views | Created by ReignOfComputer - Sunday, July 29, 2012 1:55 PM | Last reply by ReignOfComputer - Wednesday, August 8, 2012 5:47 AM -
1 Votes
IDENTITY_INSERT is set to OFF
So first you need to set IDENTITY_INSERT property to ON for your table so you can INSERT rows by defining your identity value for that column explicitly and after that you need to ...Answered | 9 Replies | 6535 Views | Created by ryguy72 - Tuesday, October 18, 2011 7:34 PM | Last reply by Hasham Niaz - Tuesday, October 18, 2011 9:31 PM -
0 Votes
Cannot insert explicit value for identity column in table '#Temp when IDENTITY_INSERT is set to OFF
If IDENTITY_INSERT is OFF, you can't explicity insert into an identity column.Answered | 3 Replies | 7609 Views | Created by John Basedow - Tuesday, November 17, 2009 7:57 PM | Last reply by John Basedow - Tuesday, November 17, 2009 8:24 PM -
1 Votes
Set custom errors to Off on a subsite?
This was posted on a different forum: "There was an additional web.config in the LAYOUTS directory which had the customErrors set to On.Answered | 3 Replies | 11029 Views | Created by tsw_mik - Tuesday, November 24, 2009 3:49 PM | Last reply by Randy Drisgill MVP - Tuesday, November 24, 2009 11:44 PM -
7 Votes
syntax err in creating view
I also tried the below in SP it is throwing err DROP VIEW IF EXISTS vv_view1 GO...Answered | 9 Replies | 583 Views | Created by Neilcse - Wednesday, October 24, 2018 12:25 PM | Last reply by Visakh16 - Thursday, October 25, 2018 5:46 AM -
0 Votes
SQL Server 2019 Behavior change with scope of SET IDENTITY_INSERT ON/OFF
We are migrating to SQL Server 2019 RTM version and noticed that one of our stored procs that uses SET IDENTITY_INSERT ON/OFF statements is failing which works properly in SQL 2017 ...Answered | 3 Replies | 1022 Views | Created by gana2k1 - Friday, November 15, 2019 4:50 PM | Last reply by gana2k1 - Monday, November 18, 2019 6:01 PM - Items 1 to 20 of 1631401 Next ›
No announcements