No announcements
Found 1631159 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 | 632 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 | 853 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 | 1000 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 | 1870 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 | 4867 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 | 4033 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 | 5166 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 | 14311 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 | 5152 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 | 2055 Views | Created by emmim44 - Wednesday, September 12, 2012 6:50 AM | Last reply by emmim44 - Wednesday, September 12, 2012 7:38 AM -
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 | 2821 Views | Created by VinodKan - Wednesday, June 10, 2015 2:15 PM | Last reply by Erland Sommarskog - Wednesday, June 10, 2015 9:30 PM -
0 Votes
IDENTITY_INSERT is set to OFF
BOL example: " -- SET IDENTITY_INSERT to ON.Answered | 2 Replies | 4345 Views | Created by Philosophiae - Thursday, March 14, 2013 5:56 PM | Last reply by Kalman Toth - Friday, March 15, 2013 2:41 PM -
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 | 1094 Views | Created by Neilcse - Sunday, October 28, 2018 6:45 PM | Last reply by Erland Sommarskog - Tuesday, October 30, 2018 10:21 PM -
4 Votes
SQL Server set ansi_null_default off
thanks alter database CloseMonitoring set ansi_null_default ...Answered | 9 Replies | 5022 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
Settings Implementation Issue - Unable to turn off Setting
Yep, I'm using Callisto for Settings.Answered | 6 Replies | 1931 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 | 6927 Views | Created by ryguy72 - Tuesday, October 18, 2011 7:34 PM | Last reply by Hasham Niaz - Tuesday, October 18, 2011 9:31 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 | 11184 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 -
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 | 7870 Views | Created by John Basedow - Tuesday, November 17, 2009 7:57 PM | Last reply by John Basedow - Tuesday, November 17, 2009 8:24 PM -
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 | 1243 Views | Created by gana2k1 - Friday, November 15, 2019 4:50 PM | Last reply by gana2k1 - Monday, November 18, 2019 6:01 PM -
3 Votes
Err attching MDF
Hello, I have a DB when I try to attach it to SQL 2005 I get this err: --- Could not open new database 'BMS'.Answered | 10 Replies | 4841 Views | Created by rbachir - Monday, January 4, 2010 5:25 PM | Last reply by SandeepM_ - Tuesday, January 5, 2010 5:10 AM - Items 1 to 20 of 1631159 Next ›
No announcements