No announcements
Found 4054321 threads
-
1 VotesRAISERROR in and database compatability level in SQL 2012
issue with the fact that the raiserror syntax has changed in SQL 2012. I do have the database set to compatibility level 100 (2008) so I'm rather ...Answered | 11 Replies | 12448 Views | Created by Assaf Rahav - Thursday, April 4, 2013 5:32 PM | Last reply by Erland Sommarskog - Saturday, March 25, 2017 5:51 PM
-
1 Votes
RAISERROR in SQL 2012 since SQL 6.5
possible to change in a automated way (not manually please) all the RAISERROR in the database? Or may we to put the compatibility level to SQL ...Answered | 6 Replies | 2787 Views | Created by Max Berganza - Monday, August 19, 2013 3:30 PM | Last reply by remcaro - Wednesday, September 18, 2013 7:11 PM -
1 Votes
database compatability level
Hi I thought setting database compatability level to an older version will automatically check for errors in the code , am i wrong ? i ...Answered | 4 Replies | 4911 Views | Created by prk - Thursday, November 18, 2010 8:36 PM | Last reply by prk - Sunday, November 21, 2010 8:02 PM -
2 Votes
SQL Server 2012 Compatability
Database engine features deprecated in SQL Server 2012 Cheers, ShashankAnswered | 10 Replies | 2223 Views | Created by Tech01230 - Wednesday, October 12, 2016 7:02 AM | Last reply by Shanky_621 - Monday, October 17, 2016 5:24 AM -
0 Votes
CDC in SSIS 2012 & Database Compatability Levels
Hi We are to trying implement Change Tracking using CDC Control Task in SSIS 2012. Everything worked fine with Proof of Concept with Test ...Answered | 2 Replies | 1555 Views | Created by VenSree - Tuesday, March 12, 2013 4:14 AM | Last reply by VenSree - Tuesday, March 12, 2013 8:52 PM -
0 Votes
Considering Compatability Level
another Sql Server hosting another application, but that Sql Server is 2008. So, I am thinking that I can 1. create the database in the ...Answered | 4 Replies | 16951 Views | Created by JackWaldon - Friday, September 25, 2009 9:56 PM | Last reply by Alan Brewer [MSFT] - Tuesday, August 2, 2011 5:22 PM -
1 Votes
Database Level SQL Audit in SQL Server 2012 Standard Edition
Hi All, I would like to have a database level SQL audit specification in my SQL server 2012 but my edition is just ...Answered | 4 Replies | 1807 Views | Created by Harn - Wednesday, May 6, 2015 2:28 AM | Last reply by Ekrem Önsoy - Thursday, January 5, 2017 8:28 PM -
0 Votes
Raiserror @message_id @message (undocumented) is not supported anymore in SQL Server 2012 and onwards.
"RAISERROR in the format RAISERROR integerAnswered | 4 Replies | 1330 Views | Created by Pranshul Gupta - Friday, February 19, 2016 8:29 AM | Last reply by Erland Sommarskog - Friday, February 19, 2016 2:07 PM -
0 Votes
Compatability between SQL 2008 & 2012
Hi all, Apologies if this is the wrong forum. I have a view in a SQL database which was created in SQL ...Answered | 4 Replies | 585 Views | Created by Graeme SP - Thursday, July 21, 2016 9:36 AM | Last reply by Graeme SP - Thursday, July 21, 2016 2:02 PM -
0 Votes
Raiserror and SQL Agent Jobs
the database and clean old files). Now create second sub-plan and do the same, except that in this sub-plan the schedule Start date ...Answered | 6 Replies | 2432 Views | Created by bawarbis - Monday, February 8, 2016 5:33 PM | Last reply by pituach - Tuesday, February 9, 2016 12:08 AM -
3 Votes
RAISERROR in sql job step
job to fail, comment out the exec statement and place in the following -- Set @RunStatus = 0 and run the job. This should complete successfully. Change this to be ...Answered | 1 Replies | 9980 Views | Created by raj_kumar123 - Thursday, October 20, 2011 9:13 PM | Last reply by Warwick Rudd - Friday, October 21, 2011 2:29 AM -
0 Votes
error in database mail in sql 2012
User-307604573 posted I have configured database mail in sql 2012 and my smtp server is configured is using account administrator ...Answered | 1 Replies | 7 Views | Created by Anonymous - Tuesday, September 16, 2014 3:51 AM | Last reply by Anonymous - Tuesday, September 16, 2014 3:54 AM -
0 Votes
Retrieve RAISERROR-Messages with Severity Level <= 10
Administrator 2008 MCITP Microsoft SQL Server 2008, Database Development db Berater ...Answered | 6 Replies | 3288 Views | Created by Uwe Ricken - Sunday, March 4, 2012 9:45 AM | Last reply by Uwe Ricken - Monday, March 12, 2012 8:52 AM -
2 Votes
Changing Compatability Level ?
Functionaility from this database and eventually the whole application. Until this we can not change the compatability ...Answered | 15 Replies | 1165 Views | Created by Dave Rolph - Thursday, October 18, 2012 9:39 AM | Last reply by Yann Duran - Thursday, November 1, 2012 12:39 PM -
1 Votes
raiserror syntax and printf
code %s. Compare this to: RAISERROR ('Error in % procedure', 16, 0, N'usp_InsertCategories'); Which produces: Msg 2787, ...Answered | 3 Replies | 683 Views | Created by James N San - Tuesday, September 12, 2017 7:18 PM | Last reply by James N San - Wednesday, September 13, 2017 2:52 AM -
0 Votes
RAISERROR in Microsoft SQL Server Management Studio
does not honor the SET_XACT_ABORT ON setting. You will get the behavior you expect if you use THROW instead. If you are pre-SQL 2012, you'll need to ...Answered | 3 Replies | 2300 Views | Created by Asi Pesa - Sunday, August 4, 2013 2:32 PM | Last reply by TiborK - Sunday, August 4, 2013 5:12 PM -
1 Votes
Database Compatibility Level for MDS 2012
Hello Henry, MDS 2012 SP1 creates any new databases with 100 (SQL Server 2008 and 2008 R2) compatibility mode and would not recommend changing ...Answered | 1 Replies | 4938 Views | Created by Henry Ong - Wednesday, February 13, 2013 10:14 PM | Last reply by M Vega - Thursday, February 14, 2013 8:26 AM -
3 Votes
RAISERROR in CLR Routines
do (provided that you prefer to log errors outside of SP) is to add an output parameter of type string to the CLR SP. CLR SP would not use RAISERROR at all. Just assign ex.Message to this ...Answered | 9 Replies | 14458 Views | Created by Sam Barnes - Tuesday, January 9, 2007 3:26 PM | Last reply by Sam Barnes - Monday, January 15, 2007 10:43 AM -
0 Votes
sql server 2012 replication versions compatability
replication between sql 2008 and 2012 should work just fine. I am about to test the same with 2008r2 developer and 2012 expressHope it ...Answered | 3 Replies | 1619 Views | Created by Yaniv Etrogi - Tuesday, February 12, 2013 8:41 AM | Last reply by Yaniv Etrogi - Tuesday, February 12, 2013 3:17 PM -
0 Votes
RAISERROR
User1608082067 posted Hello, I am raising an error on my SQL 2005 procedure as follows: RAISERROR(@ErrorMessage, ...Answered | 1 Replies | 5 Views | Created by Anonymous - Friday, September 14, 2007 2:12 PM | Last reply by Anonymous - Friday, September 14, 2007 2:41 PM - Items 1 to 20 of 4054321 Next ›
No announcements
