{"id":1545,"date":"2016-01-27T12:48:37","date_gmt":"2016-01-27T10:48:37","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1545"},"modified":"2016-04-27T12:49:54","modified_gmt":"2016-04-27T09:49:54","slug":"logo-sql-2005-ve-sql-2008-collation-name-degisikligi-islemleri","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-sql-2005-ve-sql-2008-collation-name-degisikligi-islemleri\/","title":{"rendered":"Logo Sql 2005 Ve SQL 2008 Collation Name De\u011fi\u015fikli\u011fi i\u015flemleri"},"content":{"rendered":"

Bu\u00a0makalede veritaban\u0131n\u0131n collation name bilgisi nas\u0131l de\u011fi\u015ftirilece\u011fini anlat\u0131yor olaca\u011f\u0131z. Bu i\u015fleme ba\u015flamadan \u00f6nce collation<\/strong> nedir sorusunun cevab\u0131n\u0131 verelim.<\/p>\n

Collation, SQL Server da character set anlam\u0131na gelmektedir. E\u015fitliklerde, order i\u015fleminde, b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf ayr\u0131m\u0131nda karakterlerin hangi mant\u0131kta kullan\u0131laca\u011f\u0131n\u0131 belirler. Genelde T\u00fcrk\u00e7e database lerde kullan\u0131lan Turkish_CI_AS<\/em> yada <\/strong>SQL_Latin1_General_CP1254_CI_AS<\/strong><\/em> collation \u0131nda ki CI ifadesi Case Insensitive(B\u00fcy\u00fck k\u00fc\u00e7\u00fck harf ayr\u0131m\u0131 olmas\u0131n) anlam\u0131na gelmektedir.<\/p>\n

\u00d6zellikle SQL 2000\u2019de collation name olarak Turkish_CI_AS<\/em> <\/strong>se\u00e7ilmekteydi, fakat SQL 2005 ve SQL 2008\u2019e gi\u00e7i\u015f sonras\u0131nda daha \u00e7okSQL_Latin1_General_CP1254_CI_AS<\/strong><\/em> kullan\u0131lmaya ba\u015flanm\u0131\u015ft\u0131r.<\/em><\/p>\n

 <\/p>\n

\n

Firma g\u00fcncelleme s\u0131ras\u0131nda al\u0131nan (Cannot resolve the collation conflict between “SQL_latin1_General_CP1254_CI_AS<\/em><\/strong>” and “Turkish_CI_AS<\/em><\/strong>” in the equal to operation) hatas\u0131 g\u00fcncellenmek istenen firmaya ait tablolar LG_XXX_XX_….\u00a0 ile firma ba\u011f\u0131ms\u0131z tablalar\u0131n L_…. \u00a0collation namelerinin farkl\u0131 olmas\u0131ndan yada farkl\u0131 firma database kullan\u0131m\u0131 oldu\u011funda ve master database ile firma database\u00a0 tablolar\u0131n\u0131n collation nameleri farkl\u0131 oldu\u011fu durumlarda kar\u015f\u0131la\u015f\u0131lmaktad\u0131r<\/p>\n

\u00d6rne\u011fin;<\/p>\n

Master database tablolar\u0131ndaki collation bilgisi Turkis_CI_AS<\/em><\/strong>, firma database collation bilgisi ise SQL_Latin1_General_CP1254_CI_AS<\/em><\/strong> oldu\u011fu durumda firma g\u00fcncellemesi s\u0131ras\u0131nda LV_XXX_XX_TRDGRP view sorgusunda ge\u00e7en master databese alt\u0131ndaki L_TRADGRP tablosu ile firma database alt\u0131ndaki LG_XXX_XX_CLFLINE tablosu e\u015fitlenirken e\u015fitlenmek istenen varchar tipindeki alanlar\u0131n collation namelerinin farkl\u0131 olmas\u0131ndan kaynaklan\u0131yor olabilir.<\/p>\n

L_TRADGRP.GCODE = LG_XXX_XX_CLFLINE.TRADINGGRP<\/p><\/div>\n

\n\n\n\n
\"http:\/\/support.logo.com.tr\/images\/Documents\/NDS\/resim1.png\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n

Ya\u015fanan collation name sorunlar\u0131 \u00a0\u00e7\u00f6z\u00fcm\u00fc i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar s\u0131ras\u0131 ile izlendi\u011finde database ve tablolar\u0131n collation name bilgileri (Uyarlama tablolar\u0131da dahil) e\u015fitlenmi\u015f olacakt\u0131r.<\/p>\n

\u00d6NEML\u0130:<\/p>\n

\u0130\u015flem ad\u0131mlar\u0131na ba\u015flamadan tablo ve kolonlar\u0131n collation name bilgilerinin hatal\u0131 oldu\u011fundan emin olunmal\u0131d\u0131r. A\u015fa\u011f\u0131daki sorgu ile hatal\u0131 kay\u0131tlar tespit edilebilir.<\/p>\n

A\u015fa\u011f\u0131daki sorgu collation name bilgisi ‘SQL_Latin1_General_CP1254_CI_AS\u2019<\/em><\/strong> d\u0131\u015f\u0131ndaki kay\u0131tlar\u0131 listelemektedir.<\/p>\n

Not: Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

SELECT * FROM<\/p>\n

INFORMATION_SCHEMA.COLUMNS<\/p>\n

WHERE DATA_TYPE IN (‘varchar’)<\/p>\n

AND COLLATION_NAME NOT LIKE ‘SQL_Latin1_General_CP1254_CI_AS’<\/p>\n

\u0130\u015flem ad\u0131mlar\u0131;<\/p>\n

1 \u2013 Program\u0131 kullanan kullan\u0131c\u0131lar sistemden \u00e7\u0131kart\u0131lmal\u0131 ve database yede\u011fi al\u0131nmal\u0131d\u0131r.<\/strong><\/p>\n

———————————————————————————————————-<\/p>\n

2 –\u00a0 SQL Query Analizer a\u00e7\u0131lmal\u0131 ve collation name de\u011fi\u015fikli\u011fi yap\u0131lacak database se\u00e7ilmelidir. (Farkl\u0131 firma database kullan\u0131m\u0131 var ise her firma databasesi i\u00e7in ayn\u0131 i\u015flemler yap\u0131lmal\u0131d\u0131r)<\/strong><\/p>\n

Not: Bu i\u015flemler sadece Query Analizer \u00fczerinde yap\u0131labilir. Vtyonet.exe \u00fczerinden bu i\u015flemler yap\u0131lmamal\u0131.<\/p>\n\n\n\n
\"http:\/\/support.logo.com.tr\/images\/Documents\/NDS\/resim2.png\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

———————————————————————————————————-<\/p>\n

3 \u2013\u00a0 A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p NonClustered \u0130ndexler Silinmelidir.<\/strong><\/p>\n

Not: Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden ve yedekler al\u0131nd\u0131\u011f\u0131ndan emin olun.<\/p>\n

declare @ST_Indexes table<\/p>\n

(\u00a0\u00a0\u00a0 SiraNo\u00a0 int identity(1,1) primary key clustered,<\/p>\n

Tablo_Adi nvarchar(255),<\/p>\n

Index_Adi nvarchar(255))<\/p>\n

INSERT INTO @ST_Indexes<\/p>\n

(\u00a0\u00a0 Tablo_Adi, Index_Adi)<\/p>\n

SELECT\u00a0 sys.objects.name AS Tablo_Adi,<\/p>\n

sys.indexes.name AS Index_Adi<\/p>\n

FROM\u00a0\u00a0\u00a0 sys.indexes<\/p>\n

JOIN sys.objects ON sys.indexes.object_id = sys.objects.object_id<\/p>\n

WHERE\u00a0\u00a0 sys.indexes.type_desc = ‘NONCLUSTERED’<\/p>\n

AND sys.objects.type_desc = ‘USER_TABLE’ AND sys.objects.type=’U’<\/p>\n

DECLARE @Max INT<\/p>\n

SET @Max = @@ROWCOUNT<\/p>\n

SELECT * FROM @ST_Indexes<\/p>\n

SELECT @Max as ‘DIKKAT:Yukarida Listelenen NonClustered Index silinecektir. Query executed successffully mesajini bekleyin’<\/p>\n

DECLARE @I INT<\/p>\n

SET @I = 1<\/p>\n

DECLARE @TblName NVARCHAR(255), @IdxName NVARCHAR(255)<\/p>\n

DECLARE @SQL NVARCHAR(MAX)<\/p>\n

WHILE @I <= @Max<\/p>\n

BEGIN<\/p>\n

SELECT @TblName = Tablo_Adi, @IdxName = Index_Adi FROM @ST_Indexes WHERE SiraNo = @I<\/p>\n

SELECT @SQL = N’DROP INDEX ‘ +@IdxName+’ ‘+’ON’+’<\/a>\u00a0‘+@TblName +<\/a> ‘ ‘+’WITH (ONLINE=OFF );’<\/p>\n

EXEC sp_sqlexec @SQL<\/p>\n

SET @I = @I + 1<\/p>\n

END<\/p>\n

———————————————————————————————————-<\/p>\n

4 – A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p Clustered \u0130ndexler Silinmelidir.<\/strong><\/p>\n

Not:\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

declare @ST_Indexes table<\/p>\n

(\u00a0\u00a0\u00a0 SiraNo\u00a0 int identity(1,1) primary key clustered,<\/p>\n

Tablo_Adi nvarchar(255),<\/p>\n

Index_Adi nvarchar(255))<\/p>\n

INSERT INTO @ST_Indexes<\/p>\n

(\u00a0\u00a0 Tablo_Adi, Index_Adi)<\/p>\n

SELECT\u00a0 OBJ.name AS Tablo_Adi,<\/p>\n

INX.name AS Index_Adi<\/p>\n

FROM\u00a0\u00a0\u00a0 sys.indexes AS INX<\/p>\n

JOIN sys.objects AS OBJ ON INX.object_id = OBJ.object_id<\/p>\n

WHERE\u00a0\u00a0 OBJ.type_desc = ‘USER_TABLE’<\/p>\n

AND INX.type_desc = ‘CLUSTERED’<\/p>\n

DECLARE @Max INT<\/p>\n

SET @Max = @@ROWCOUNT<\/p>\n

SELECT * FROM @ST_Indexes<\/p>\n

SELECT @Max as ‘DIKKAT:Yukarida Listelenen Clustered Index silinecektir. Query executed successffully mesajini bekleyin’<\/p>\n

DECLARE @I INT<\/p>\n

SET @I = 1<\/p>\n

DECLARE @TblName NVARCHAR(255), @IdxName NVARCHAR(255)<\/p>\n

DECLARE @SQL NVARCHAR(MAX)<\/p>\n

WHILE @I <= @Max<\/p>\n

BEGIN<\/p>\n

SELECT @TblName = Tablo_Adi, @IdxName = Index_Adi FROM @ST_Indexes WHERE SiraNo = @I<\/p>\n

SELECT @SQL = N’ALTER TABLE ‘ +@TblName+’ ‘+’DROP<\/a> CONSTRAINT’+’ ‘+@IdxName<\/a>;<\/p>\n

EXEC sp_sqlexec @SQL<\/p>\n

SET @I = @I + 1<\/p>\n

END<\/p>\n

———————————————————————————————————-<\/p>\n

5 – A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p LV ile ba\u015flayan View tablolar\u0131 silinmelidir.<\/strong><\/p>\n

Not:\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

DECLARE @ST_LVDROP sysname<\/p>\n

DECLARE ST_DROP_LVTBL_CUR INSENSITIVE CURSOR FOR<\/p>\n

SELECT NAME FROM sysobjects WHERE name LIKE ‘LV_’+’%’ AND XTYPE=’V’<\/p>\n

OPEN ST_DROP_LVTBL_CUR<\/p>\n

WHILE 1 = 1<\/p>\n

BEGIN<\/p>\n

FETCH ST_DROP_LVTBL_CUR INTO @ST_LVDROP<\/p>\n

IF @@fetch_status NOT IN (‘0’)<\/p>\n

BREAK<\/p>\n

EXEC (‘DROP VIEW’ +’ ‘+@ST_LVDROP<\/a>)<\/p>\n

END<\/p>\n

DEALLOCATE ST_DROP_LVTBL_CUR<\/p>\n

———————————————————————————————————-<\/p>\n

6- A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p\u00a0 database collation nameleri\u00a0 SQL_Latin1_General_CP1254_CI_AS<\/em> olarak g\u00fcncellenir.<\/strong><\/p>\n

Not:\u00a0\u00a0\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

Sorguda ge\u00e7en Dbname alan\u0131na database ismi yaz\u0131lmal\u0131 ve 3 sorgu birlikte \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r.<\/p>\n

ALTER DATABASE Dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE<\/p>\n

–\/Database single user moda cekilir.<\/p>\n

GO<\/p>\n

ALTER DATABASE Dbname COLLATE SQL_Latin1_General_CP1254_CI_AS<\/p>\n

–\/Database collation name degisikligi yapilir.<\/p>\n

GO<\/p>\n

ALTER DATABASE Dbname SET MULTI_USER<\/p>\n

–\/Database single user moddan cikarilir.<\/p>\n

 <\/p>\n

Not: G\u00fcncel versiyonlarda fonksiyonlar ile ilgili hata al\u0131nmas\u0131 durumda, a\u015fa\u011f\u0131daki sorgu ayr\u0131ca \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r;<\/p>\n

 <\/p>\n

DECLARE @BKPDROP sysname
\nDECLARE DROP_BKPTBL_CUR INSENSITIVE CURSOR FOR
\nSELECT NAME FROM SYSOBJECTS WHERE NAME LIKE ‘%GET%COEF%’ AND XTYPE=’FN’ AND NAME LIKE ‘%002%’
\nOPEN DROP_BKPTBL_CUR
\nWHILE 1 = 1
\nBEGIN
\nFETCH DROP_BKPTBL_CUR INTO @BKPDROP
\nIF @@fetch_status 0
\nBREAK
\nEXEC (‘DROP FUNCTION’ +’ ‘+@BKPDROP<\/a>)
\nEND
\nDEALLOCATE DROP_BKPTBL_CUR<\/p>\n

— NOT:\u00a0 %002%\u00a0 — Alan\u0131na firma numaras\u0131 yaz\u0131lmal\u0131.<\/p>\n

———————————————————————————————————-<\/p>\n

7-\u00a0Collatin name de\u011fi\u015fikli\u011fi i\u015fleminin yap\u0131labilmesi i\u00e7in Collation name de\u011fi\u015fikli\u011fi \u00f6ncesi database’deki istatisliklerin silinmesi gerekmektedir.\u00a0<\/strong><\/p>\n

A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p database ismi de\u011fi\u015ftirildikten sonra \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r.<\/p>\n

— DATABASE’DEK\u0130 \u0130STAT\u0130SL\u0130KLER\u0130N S\u0130L\u0130NMES\u0130 —<\/p>\n

Declare @TableName nvarchar(250)
\nDeclare @StatsName nvarchar(250)
\nDeclare @TheSQL nvarchar(512)
\nDeclare @DBName nvarchar(200)
\n———————————————————-
\nSet @DBName =’LOGODB’ –LOGODB alan\u0131na kendi database isminizi yaz\u0131n…<\/p>\n

— \u0130statisliklerin False duruma getirilmesi —-<\/p>\n

exec(‘ALTER DATABASE [‘+@DBName+’<\/a>;] SET AUTO_CLOSE OFF WITH NO_WAIT’)
\nexec(‘ALTER DATABASE [‘+@DBName+’<\/a>;] SET AUTO_CREATE_STATISTICS OFF WITH NO_WAIT’)
\nexec(‘ALTER DATABASE [‘+@DBName+’<\/a>;] SET AUTO_SHRINK OFF WITH NO_WAIT’)
\nexec(‘ALTER DATABASE [‘+@DBName+’<\/a>;] SET AUTO_UPDATE_STATISTICS OFF WITH NO_WAIT’)<\/p>\n

—- \u0130statisliklerin silinmesi —-
\nDeclare Get_Tables CURSOR FAST_FORWARD FOR
\n(Select Object_name(object_id) as ‘Table Name’,name as ‘Stats Name’
\nFrom sys.stats SS
\nWhere (IndexProperty(object_id, name, ‘IsAutoStatistics’) = 1 and object_id >255 or user_created = 1) and not
\n(Select TOP 1 name FROM sys.objects where type_desc= ‘INTERNAL_TABLE’ and object_id = SS.object_id) is null)<\/p>\n

Open Get_Tables
\nFETCH NEXT FROM Get_Tables INTO @TableName,@StatsName
\nWHILE @@FETCH_STATUS = 0
\nBEGIN
\nset @TheSQL = ‘DROP STATISTICS ‘ + QUOTENAME(@TableName) + ‘.’+ QUOTENAME(@StatsName)
\nexec (@TheSQL)
\nFETCH NEXT FROM Get_Tables INTO @TableName,@StatsName
\nEND<\/p>\n

Close Get_Tables
\nDEALLOCATE Get_Tables<\/p>\n

 <\/p>\n

8- A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p\u00a0 tablo ve kolonlar\u0131n collation\u00a0 nameleri\u00a0 SQL_Latin1_General_CP1254_CI_AS<\/em> olarak g\u00fcncellenir.<\/strong><\/p>\n

Not:\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

declare @ST_ColDeg table<\/p>\n

(\u00a0 SiraNo\u00a0 int identity(1,1) primary key clustered,<\/p>\n

Tablo_Adi varchar(max),<\/p>\n

Column_Name varchar(max),<\/p>\n

Data_Tipi varchar(max),<\/p>\n

Uzunluk varchar(max))<\/p>\n

INSERT INTO @ST_ColDeg<\/p>\n

(Tablo_Adi,Column_Name,Data_Tipi,Uzunluk)<\/p>\n

SELECT<\/p>\n

TABLE_NAME AS Tablo_Adi,<\/p>\n

COLUMN_NAME AS Column_Name,<\/p>\n

DATA_TYPE AS Data_Tipi,<\/p>\n

CASE WHEN CHARACTER_MAXIMUM_LENGTH = -1 THEN ‘(max)’<\/p>\n

WHEN DATA_TYPE in (‘text’,’ntext’) THEN ”<\/p>\n

WHEN CHARACTER_MAXIMUM_LENGTH IS NOT NULL<\/p>\n

THEN ‘(‘+(CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH)+’)’ )<\/p>\n

ELSE<\/p>\n

ISNULL(CONVERT(VARCHAR,CHARACTER_MAXIMUM_LENGTH),’ ‘)<\/p>\n

END AS Uzunluk<\/p>\n

FROM INFORMATION_SCHEMA.COLUMNS<\/p>\n

WHERE DATA_TYPE IN (‘varchar’)<\/p>\n

AND TABLE_NAME NOT LIKE (‘LV_%’)<\/p>\n

AND COLLATION_NAME NOT LIKE ‘SQL_Latin1_General_CP1254_CI_AS’<\/p>\n

DECLARE @Max INT<\/p>\n

SET @Max = @@ROWCOUNT<\/p>\n

SELECT * FROM @ST_ColDeg<\/p>\n

SELECT @Max as ‘DIKKAT! Yukarida listelenen kolonlar i\u00e7in collation name degisikligi yapilacaktir,Query executed successffully mesajini bekleyin’<\/p>\n

DECLARE @I INT<\/p>\n

SET @I = 1<\/p>\n

DECLARE @TblName varchar(max), @ClmnName varchar(max),@DtTp varchar(max),@Uznlk varchar(max)<\/p>\n

DECLARE @SQL NVARCHAR(MAX)<\/p>\n

WHILE @I <= @Max<\/p>\n

BEGIN<\/p>\n

SELECT @TblName= Tablo_Adi,@ClmnName=Column_Name,@DtTp=Data_Tipi,@Uznlk=Uzunluk<\/p>\n

FROM @ST_ColDeg WHERE SiraNo =@I<\/p>\n

SELECT @SQL = N’ALTER TABLE ‘+@TblName+’ ALTER<\/a> COLUMN’+’ ‘+@ClmnName +<\/a> ‘ ‘+ @DtTp+”+@Uznlk +’<\/a> ‘<\/p>\n

+ ‘ ‘+’COLLATE’+’ ‘+’SQL_Latin1_General_CP1254_CI_AS’+ ‘ ‘ +’NULL’;<\/p>\n

EXEC sp_sqlexec @SQL<\/p>\n

SET @I = @I + 1<\/p>\n

END<\/p>\n

———————————————————————————————————-<\/p>\n

9- A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p\u00a0 sistem tablolar\u0131na ait database olu\u015fturulurken eklenen indexler\u00a0 olu\u015fturulur.<\/strong><\/p>\n

Not:\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

A\u015fa\u011f\u0131daki\u00a0sorgular sadece firma ba\u011f\u0131ms\u0131z tablolar\u0131n bulundu\u011fu ana database \u00fczerinde collation name de\u011fi\u015fikli\u011fi yap\u0131l\u0131yor ise kullan\u0131lmal\u0131d\u0131r.<\/p>\n

Firma database kullan\u0131m\u0131 var ve collation name de\u011fi\u015fikli\u011fi bu database \u00fczerinde yap\u0131l\u0131yor ise\u00a0bir sonraki i\u015flem ad\u0131m\u0131na ge\u00e7i\u015f yap\u0131lmal\u0131d\u0131r.<\/p>\n

ALTER TABLE [dbo].[L_CAPISIGN] ADD\u00a0 CONSTRAINT [CAPISIGN_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH<\/p>\n

(PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF, SORT_IN_TEMPDB = OFF,<\/p>\n

IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

CREATE UNIQUE NONCLUSTERED INDEX [CDBTMP_I1] ON [dbo].[L_CDBTMP]<\/p>\n

(\u00a0\u00a0\u00a0\u00a0 [MODULE_] ASC,[INFOTYPE] ASC,[OBJID] ASC,[INSTID] ASC<\/p>\n

)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF,<\/p>\n

DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_BRWSSTAT] ADD\u00a0 CONSTRAINT [BRWSSTAT_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF,<\/p>\n

SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON,<\/p>\n

ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_CAPITERMINAL] ADD\u00a0 CONSTRAINT [CAPITERMINAL_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF,<\/p>\n

SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 =<\/p>\n

ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_CAPIFIRM] ADD\u00a0 CONSTRAINT [CAPIFIRM_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF,<\/p>\n

SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_CAPIUSER] ADD\u00a0 CONSTRAINT [CAPIUSER_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC )WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 =<\/p>\n

OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 =<\/p>\n

ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_TSCONT] ADD\u00a0 CONSTRAINT [TSCONT_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF,<\/p>\n

SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_TSPROPS] ADD\u00a0 CONSTRAINT [TSPROPS_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF, SORT_IN_TEMPDB = OFF,<\/p>\n

IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

—<\/p>\n

ALTER TABLE [dbo].[L_USERCOM] ADD\u00a0 CONSTRAINT [USERCOM_I1] PRIMARY KEY CLUSTERED<\/p>\n

([LOGICALREF] ASC)WITH (PAD_INDEX\u00a0 = OFF, STATISTICS_NORECOMPUTE\u00a0 = OFF,<\/p>\n

SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS\u00a0 = ON, ALLOW_PAGE_LOCKS\u00a0 = ON) ON [PRIMARY]<\/p>\n

———————————————————————————————————-<\/p>\n

10-\u00a0 A\u015fa\u011f\u0131daki sorguyu \u00e7al\u0131\u015ft\u0131rarak collation name bilgisi hatal\u0131 olan kay\u0131t varm\u0131 tekrar kontrol edilebilir.<\/strong><\/p>\n

Not:\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

SELECT * FROM<\/p>\n

INFORMATION_SCHEMA.COLUMNS<\/p>\n

WHERE DATA_TYPE IN (‘varchar’)<\/p>\n

AND COLLATION_NAME NOT LIKE ‘SQL_Latin1_General_CP1254_CI_AS’<\/p>\n

———————————————————————————————————-<\/p>\n

11- A\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p L_CAPISIGN tablosundaki VERS alan\u0131 g\u00fcncellenmeli.<\/strong><\/p>\n

Not:\u00a0 Query Analizer\u2019da Do\u011fru database se\u00e7ildi\u011finden emin olun.<\/p>\n

UPDATE L_CAPISIGN SET VERS=1<\/p>\n

———————————————————————————————————-<\/p>\n

12- \u00a0A\u015fa\u011f\u0131ki ekran g\u00f6r\u00fcnt\u00fcs\u00fcnde oldu\u011fu gibi SYS\u2019ye giri\u015f yaparak Y\u00f6netim\\Genel Tablo Y\u00f6netimi alt\u0131kdaki se\u00e7enekler in hepsi i\u00e7in g\u00fcncellenme yap\u0131lmal\u0131d\u0131r.<\/strong><\/p>\n\n\n\n
\"http:\/\/support.logo.com.tr\/images\/Documents\/NDS\/resim3.png\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

———————————————————————————————————-<\/p>\n

13-\u00a0 SYS\u2019yede Y\u00f6netim\\Firmalar b\u00f6l\u00fcm\u00fcnde her firma i\u00e7in;<\/strong><\/p>\n

Tablolar\u0131 s\u00fcr\u00fcme g\u00f6re g\u00fcncelleme ve Uyarlama tablolar\u0131n\u0131 g\u00fcncelleme i\u015flemi yap\u0131lmal\u0131d\u0131r.<\/p>\n

Not:Go,GoPlus setlerinde uyarlama se\u00e7ene\u011fi olmad\u0131\u011f\u0131 i\u00e7in uyarlama g\u00fcncellemesine gerek bulunmamaktad\u0131r.<\/p>\n\n\n\n
\"http:\/\/support.logo.com.tr\/images\/Documents\/NDS\/resim4.png\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

———————————————————————————————————-<\/p>\n

\u00a014-\u00a0 SYS\u2019yede Y\u00f6netim\\Firmalar b\u00f6l\u00fcm\u00fcnde, Her firma alt\u0131ndaki d\u00f6nemler i\u00e7in Veritaban\u0131 Ara\u00e7lar\u0131n\u0131 Olu\u015ftur ve Uyarlama Tablolar\u0131n\u0131 G\u00fcncelleme yap\u0131lmal\u0131d\u0131r.<\/strong><\/p>\n

Not:Go,GoPlus setlerinde uyarlama se\u00e7ene\u011fi olmad\u0131\u011f\u0131 i\u00e7in uyarlama g\u00fcncellemesine gerek bulunmamaktad\u0131r.<\/p>\n\n\n\n
\"images\/Documents\/NDS\/resim5.png\"<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

———————————————————————————————————-<\/p>\n

\u00a015-\u00a0 SYS\u2019de gerekli g\u00fcncellemeler yap\u0131ld\u0131ktan sonra a\u015fa\u011f\u0131daki sorgu Query Analizer\u2019a kopyalan\u0131p Database alt\u0131ndaki Indexlerin tekrar g\u00fcncellenmesi sa\u011flanabilir.<\/strong><\/p>\n

Not:\u00a0 Bu i\u015flem \u00f6ncesinte Tekrar database yede\u011fi al\u0131n ve Sorgu \u00e7al\u0131\u015ft\u0131r\u0131lmadan \u00f6nce Do\u011fru database se\u00e7ildi\u011finden emin olun. (Bu i\u015flem uzun s\u00fcrebilir.)<\/p>\n

EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)”<\/p>\n

B\u00fct\u00fcn bu i\u015flemler sonras\u0131nda database collation name de\u011fi\u015fikli\u011fi tamamlanm\u0131\u015f olacakt\u0131r ve art\u0131k programa giri\u015f yapabirsiniz.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Bu\u00a0makalede veritaban\u0131n\u0131n collation name bilgisi nas\u0131l de\u011fi\u015ftirilece\u011fini anlat\u0131yor olaca\u011f\u0131z. Bu i\u015fleme ba\u015flamadan \u00f6nce collation nedir sorusunun cevab\u0131n\u0131 verelim. Collation, SQL Server da character set anlam\u0131na gelmektedir. E\u015fitliklerde, order i\u015fleminde, b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf ayr\u0131m\u0131nda karakterlerin hangi mant\u0131kta kullan\u0131laca\u011f\u0131n\u0131 belirler. Genelde T\u00fcrk\u00e7e database lerde kullan\u0131lan Turkish_CI_AS yada SQL_Latin1_General_CP1254_CI_AS collation \u0131nda ki CI ifadesi Case Insensitive(B\u00fcy\u00fck k\u00fc\u00e7\u00fck harf […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,10],"tags":[],"class_list":["post-1545","post","type-post","status-publish","format-standard","hentry","category-logo-genel-destek","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1545"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1545\/revisions"}],"predecessor-version":[{"id":1546,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1545\/revisions\/1546"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}