Toad World® Forums

Toad-ss vs SSMS Table Alter syntax difference


#1

Toad-SS 5.0.1.554 takes a an entirely different tack from SQLSERVER Management
Studio 2008 R2 in performing a Table Alter, where a various Set options are
used in SSMS but not Toad-SS

The most interesting difference is the inclusion on SSMS the following statement
à ALTER TABLE clinical.FactEncounterTbl2 SET (LOCK_ESCALATION = TABLE )

Therefore, is Toad-SS FULLY handling this functionality as best it could?

Toad-SS-Beta (current iteration Table Alter not working)

Hank Freeman

Senior SQL Server DBA /Data Architect

hfreeman@msn.com

678-414-0090 my cell Primary

/*

Wednesday, March 30, 201111:53:43 AM

User: XXXXXX

Server: 64.38.45.35

Database: xxx_DWH

Application:

*/

/* To prevent any potential data loss issues, you should review this script in
detail before running it outside the context of the database designer.*/

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET ARITHABORT ON

SET NUMERIC_ROUNDABORT OFF

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

COMMIT

BEGIN TRANSACTION

GO

ALTER TABLE clinical.FactEncounterTbl2 ADD

  ScheduledTime time( 0 ) NULL

GO

ALTER TABLE clinical.FactEncounterTbl2 SET (LOCK_ESCALATION = TABLE )

GO

COMMIT

/

image001.gif

image002.jpeg


#2

Hank,

Toad doesn’t support this feature yet.

There is ER83784 for that.

Regards,

Valentin Baev

www.quest.com | Twitter | Facebook | Youtube | LinkedIn
image002.jpeg


#3

Hank,

Toad doesn’t support this feature yet.

There is ER83784 for that.

Regards,

Valentin Baev

www.quest.com | Twitter | Facebook | Youtube | LinkedIn
image001.gif