iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

  • Facebook
  • Instagram
  • LinkedIn
  • Phone
  • Twitter
  • YouTube

Copyright © 2025 · iT Synergy·

SQL – Saving Changes is not permitted
SQL – Saving Changes is not permitted avatar

May 31, 2013 By Ana María Orozco Zuluaga Leave a Comment

Have you been working on SQL Server when you realize that you need a new column in a table or make any kind of change like allow null for a specific column ?

The easy and fast way to make a change is using the design option to add the new column. Most of the time it allows you to introduce the name and the DataType you need to create.

By default SQL server, is going to show you an warning message when you committed the changes you have made in the table. The warning doesn’t allow you to save the changes and show you the follow message: “Saving change is not permitted”. The change you have made require the following tables to be dropped and re-create. You have either made changes that cant be recreate or enable the option prevent saving changes that require the table to be re-create.

This happens because SQL has activated an option by default, which doesn’t allow you to do that. in this post I am going to Show you how to change that option. However you have to be careful changing this and I recommend you just do it in a developer environment, not in production environment.

So, to change that go to Tool – Designers and Prevent saving change that require table re-creation as show the next figure:

 

Filed Under: SQL Tagged With: BI, SQL Server

Rebuild Indexes – SQL Server
Rebuild Indexes – SQL Server avatar

November 29, 2012 By Jaime Alonso Páez torres Leave a Comment

Una tarea que generalmente no tenemos en cuenta a menos que seamos DBA, es mantener los indices de las bases de datos . Hay varias formas de hacerlo:

  • De manera manual

Una vez dentro del SQL Server Management Studio,  ubicarse en el nodo de la base de datos correspondiente, expandir el nodo de Tables para luego entrar a Indexes, para que uno a uno dentro de cada indice se escoja la opción Rebuild.

clip_image001

  • De manera automática

Y a la vez, a la que tenemos más control y se ejecuta por medio de script. Navegando por Internet me encontre con el blog de Greg, SQL Server script to rebuild all indexes for all tables and all databases; el cual  hace rebuild de todos los indices de todas las tablas para todas las bases de datos.

El script trabaja para versiones SLQ Server 2000 o superiores, adicionalmente lo podemos actualizar para indicarle que base de datos queremos actualizar  (IN ) o cuales queremos descartar (NOT IN)

SELECT name FROM MASTER.dbo.sysdatabases  
WHERE name NOT IN ('master','msdb','tempdb','model','distribution') 

o incluir otras opciones.

Nota:  Ser cuidadoso cuando lo ejecutemos para indices o base de datos muy grandes.

Filed Under: SQL Server Tagged With: indexes, Rebuild, SQL Server

Team


Marco
Antonio Hernández

Jaime
Alonso Páez

Luis
Carlos Bernal

Ana
María Orozco

Juan
Camilo Zapata

Diana
Díaz Grijalba

Carlos
Alberto Rueda

Sonia
Elizabeth Soriano

Alexandra
Bravo Restrepo

Bernardo
Enrique Cardales

Juan
Alberto Vélez

Diana
Paola Padilla

Jhon
Jairo Rodriguez

Jesús
Javier Hernández

Alejandro
Garcia Forero

Gustavo
Adolfo Echeverry

Yully
Arias Castillo

Carlos
Andrés Vélez

Brayan
Ruiz

Jimmy
Quejada Meneses

Natalia
Zartha Suárez

Josué
Leonardo Bohórquez

Oscar
Alberto Urrea

Odahir
Rolando Salcedo

Carolina
Torres Rodríguez

Juan
Mauricio García

Mario
Andrés Cortés

Eric
Yovanny Martinez

Tag Cloud

.NET (9) 940px (1) Analysis Services mdx (1) An attempt was made to load a program with an incorrect format. (1) ASP.NET MVC (1) Azure (3) Backup (1) BAM (7) BAM API (1) BAMTraceException (2) BI (3) BizTalk (24) Business Intelligence (6) C# (2) caracteristicas de publicacion (2) Content Editor (3) ESB (15) ESB Toolkit (3) General (4) habilitar caracteristicas (3) indexes (2) Integration Services (2) Master Page (3) MDX (2) MSE (11) net.tcp (2) Office 365 (2) Oracle (2) Performance Point (2) Public Website (2) Receive Location (2) SDK (2) Servicio Web (2) Sharepoint 2010 (2) SharePoint 2013 (4) SharePoint Online (2) SOA (8) Soap Fault (2) Sort Months MDX (2) SQL Server (2) Visual (2) Visual Studio 2010 (2) WCF (19) Windows (3) Windows 8 (17)

Categories

  • .NET (33)
  • Analysis Services (1)
  • ASP.NET MVC (2)
  • Azure (7)
  • BAM (9)
  • BAM PrimaryImport (3)
  • BigData (1)
  • BizTalk (77)
  • BizTalk 2010 configurations (57)
  • BizTalk Application (60)
  • BizTalk Services (13)
  • Business Intelligence (4)
  • Cloud (3)
  • CMD (1)
  • CodeSmith – NetTiers (2)
  • CommandPrompt (1)
  • CRM OptionSet mapping component (1)
  • Desarrollo de software (6)
  • develop (6)
  • developers (3)
  • DropBox (1)
  • Dynamics (1)
  • Enterprise Architect (1)
  • Entity Framework (1)
  • Errores BizTalk (2)
  • ESB (27)
  • ETL (1)
  • Event Viewer (1)
  • Excel Services (1)
  • Foreach loop container (1)
  • General (4)
  • Gerencia de Proyectos (2)
  • Google (1)
  • Grouped Slices (1)
  • Human Talent (1)
  • IIS (4)
  • Integración (6)
  • Integration Services (3)
  • KingswaySoft (1)
  • Lync (1)
  • MSE (13)
  • Office 365 (2)
  • Oracle Data Adapter (2)
  • Performance Point (4)
  • Picklist (1)
  • Pivot Table (1)
  • Procesos (1)
  • Pruebas (1)
  • Public Website (2)
  • Reports (1)
  • SCRUM (1)
  • SDK (2)
  • SEO (1)
  • Servicios (2)
  • Sharepoint (9)
  • SharePoint 2010 (10)
  • SharePoint 2013 (4)
  • SharePoint Online (2)
  • SharpBox (1)
  • Shortcuts (1)
  • Sin categoría (1)
  • SOA (50)
  • SQL (5)
  • SQL Server (3)
  • SQL Server Management Studio (1)
  • SSIS (3)
  • SSL (1)
  • SSO (1)
  • Tracking Profile Editor (2)
  • Twitter (1)
  • Uncategorized (1)
  • Virtual Network (2)
  • Visual Studio 11 (1)
  • Visual Studio 2010 (2)
  • Visual Studio Online (1)
  • VMware (2)
  • WCF (24)
  • Web (1)
  • Web Api (1)
  • Windows (5)
  • Windows 8 (11)
  • Windows Azure (2)
  • Windows Live Write (1)
  • Windows Phone (7)
  • Windows Phone 8 (1)
  • Windows Scheduler (1)
  • windows8 (2)
  • WindowsRT (3)
  • WP7 SDK (1)

Manage

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org