Jvector Map Türkiye

Merhaba Jvectormap güzel bir uygulamadır ancak Türkiye haritası mevcut değil Elinizde olması adına Türkiye Vector Map turkey_jvectormap.rar

Converter için  Pyton vb şeylere ihtiyacınız var onun için de referans
http://stackoverflow.com/a/13520307/3391710

Assertion failure: "(!"SetThreadContext failed")"

Alıntıdır http://cc.embarcadero.com/Item/27521 This is an informal fix for debugger problems that occur when running Delphi 2007, C++Builder 2007, or RAD Studio 2007 on Windows 7. The primary problem being fixed is a debugger assert that usually occurs when terminating a process being debugged on a 64-bit version of Windows 7. The text of the assert is: Assertion failure: "(!"SetThreadContext failed")" This version also fixes a few minor problems when debugging on Windows 7. Before applying this fix, it is highly recommended that you make a backup copy of your existing bordbk105N.dll. Installation instructions: 1) Unzip the zip file. 2) Copy the bordbk105N.dll file into the bin directory of your Delphi 2007, C++Builder 2007, or RAD Studio 2007 installation. A typical location for this on a 64-bit machine is: C:\Program Files (x86)\CodeGear\RAD Studio\5.0\bin Standard disclaimers apply. This fix has not been tested at all, and it is not supported in any way by Embarcadero. If it works for you, great... if not, you've been warned.

SPID SQL COMMAND

sp_who ya da sp_who2 ile aldığımız Spid ID sinin çalşıtırdığı sql komutunu görmek için DBCC INPUTBUFFER (spid) yazmanız yeterli :) Çok acil yazdım çıkmam lazım

Comport İn use

spMSforeachtable

Merhaba

sp_Msforeachtable güzel bir sistem prosedürü bir ara işinize yarayabilir
Sayfadan aldığım örnek ve kullanımı ile ilgili detaylı bilgi

xec @RETURN_VALUE=sp_MSforeachtable @command1, @replacechar, @command2,
@command3, @whereand, @precommand, @postcommand
Where:

@RETURN_VALUE - is the return value which will be set by "sp_MSforeachtable"
@command1 - is the first command to be executed by "sp_MSforeachtable" and is defined as a nvarchar(2000)
@replacechar - is a character in the command string that will be replaced with the table name being processed (default replacechar is a "?")
@command2 and @command3 are two additional commands that can be run for each table, where @command2 runs after @command1, and @command3 will be run after @command2
@whereand - this parameter can be used to add additional constraints to help identify the rows in the sysobjects table that will be selected, this parameter is also a nvarchar(2000)
@precommand - is a nvarchar(2000) parameter that specifies a command to be run prior to processing any table
@postcommand - is also a nvarchar(2000) field used to identify a command to be run after all commands have been processed against all tables
As you can see, there are quite a few options for the "sp_MSforeachtable" SP. Let's go through a couple of different examples to explore how this SP can be used to process commands against all the tables, or only a select set of tables in a database.

First let's build on our original example above and return row counts for tables that have a name that start with a "p." To do this we are going to use the @whereand parameter. Here is the code for this example:

use pubs
go
create table #rowcount (tablename varchar(128), rowcnt int)
exec sp_MSforeachtable
@command1 = 'insert into #rowcount select ''?'',
count(*) from ?',
@whereand = 'and name like ''p%'''
select top 5 * from #rowcount
order by tablename
drop table #rowcount
On my machine, the above code produced the following output:

tablename rowcnt
------------------ -----------
[dbo].[pub_info] 8
[dbo].[publishers] 8
By reviewing the code above, you can see I am now using the @command1, and the @whereand parameter. The @whereand parameter above was used to constrain the WHERE clause and only select tables that have a table name that starts with a "p." To do this I specified "and name like ''p%''" for the @whereand parameter. If you needed to have multiple constraints like all tables that start with "p," and all the tables that start with "a," then the @whereand parameter would look like this:

and name like ''p%'' or name like ''a%''
Note, that in the @command1 string in the above example there is a "?". This "?" is the default replacement character for the table name. Now if for some reason you need to use the "?" as part of your command string then you would need to use the @replacechar parameter to specify a different replacement character. Here is another example that builds on the above example and uses the "{" as the replacement character:

create table #rowcount (tablename varchar(128), rowcnt int)
exec sp_MSforeachtable
@command1 = 'insert into #rowcount select
''Is the rowcount for table {?'',
count(*) from {',
@replacechar = '{',
@whereand = 'and name like ''p%'''
select tablename as question, rowcnt from #rowcount
order by tablename
drop table #rowcount
Here is the output from this command on my machine:

question rowcnt
------------------------------------------------ -----------
Is the rowcount for table [dbo].[pub_info]? 8
Is the rowcount for table [dbo].[publishers]? 8
There are two more parameters to discuss, @precommand, and @postcommand. Here is an example that uses both of these commands:

exec sp_MSforeachtable
@command1 = 'print ''Processing table ?''',
@whereand = 'and name like ''p%''',
@precommand = 'Print ''precommand execution '' ',
@postcommand = 'Print ''postcommand execution '' '
Here is the output from this command when run on my machine:

precommand execution
Processing table [dbo].[pub_info]
Processing table [dbo].[publishers]
postcommand execution
As you can see, the "PRINT" T-SQL command associated with the "@precommand" parameter was only executed once, prior to processing through the tables. Whereas, the "@postcommmand" statement was executed after all the tables where processed, and was only executed once. Using the pre and post parameters would be useful if I had some processing I wanted done prior to running a command against each table, and/or I needed to do some logic after all tables where processed.

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

VSS kURULUMU

Merhaba VSS ile internet ile ilgili takılı iseniz bakabilirsiniz

http://alinconstantin.homeip.net/webdocs/scc/vss_internet.htm

FIX: Error Code 29506, While installing SQL Management Studio Express on Windows Vista x64

Merhaba windows Vista 64 bit işletimli bir makinaya SQL Server Management Studio kurar iken karşınıza yukarıdaki resimdeki gibi bir hata çıkarsa yapmanız gerekenler aşağıaki gibi

1. CMD komut istemcisini yönetici olarak çalıştırın .
2. daha sonra kurulum paketini buradan komut olarak çalıştırın :
Örnek
C:\>E:\Downloads\SSMS_x64.msi
3.Sonra gelen yönergelere göre işleminiz tamamlayın

IndexFragmentation

Merhaba Index fragmantasyonu ve ayrıntılı bilgiler bigün lazım olur

Veri tabanınızda indexlerin berbat durumda olup olmadığını,external veya internal fragmentation gerçekleşip gerçekleşmediğini anlamak istiyor iseniz aşağıdaki karışık T-SQL komutunu çalıştırmanız gerekiyor.

SELECT OBJECT_NAME(dt.object_id), si.name,
dt.avg_fragmentation_in_percent, dt.avg_page_space_used_in_percent
FROM
(SELECT object_id, index_id, avg_fragmentation_in_percent, avg_page_space_used_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID('AdventureWorks'), NULL, NULL, NULL,'DETAILED')
WHERE index_id <> 0) as dt --does not return information about heaps
INNER JOIN sys.indexes si
ON si.object_id = dt.object_id
AND si.index_id = dt.index_id


Çıkan sonuca baktığımızda
· Eğer avg_fragmentation_in_percent değeri 10’un üstündeyse o index için external fragmentation vardır denir.
· Eğer avg_page_space_used_in_percent değeri 75’in altında ise bu durumda da internal fragmentation vardır denir.

Tabloya bakarak AdventureWorks veri tabanının indexlerinin halinin pekde içaçıcı olmadığı söylenebilir.

ayrıntılı anlatımı aşağıdaki sayfada bulabilirsiniz
http://www.msegitim.net/sql/IndexFragmentation.aspx


http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

SQL Server Alt Toplam Almak için güzel örnekler

Merhaba Arkadaşlar
internette gezinirken ilgimi çeken bir kaç güzel SQL
Kaynak site : http://www.sqlusa.com/bestpractices2005/subtotaltotalgrandtotal/

Execute the following Microsoft T-SQL example scripts in SQL Server Management Studio Query Editor to demonstrate the architecting of subtotal, total and grand total queries.

Grand Total definition- the sum of the TOTALs of several groups of numbers.

—SQL grand total simple, quick syntax - isnull is used to make report readable
SELECT isnull(convert(VARCHAR,ProductID),'GRAND TOTAL') AS ProductID,
sum(Quantity) AS 'Total In Inventory'
FROM AdventureWorks2008.Production.ProductInventory
WHERE ProductID >= 800
GROUP BY ProductID WITH ROLLUP
ORDER BY ProductID;
GO
/* Partial results
ProductID Total In Inventory
996 970
997 153
998 155
999 194
GRAND TOTAL 65709
*/

------------

-- SQL sales subtotal, total, grand total - simple logic - month, year, all times
SELECT isnull(convert(VARCHAR,Year(OrderDate)),'GRAND TOTAL') AS YEAR,
CASE
WHEN YEAR(OrderDate) IS NOT NULL
THEN isnull(convert(VARCHAR,Month(OrderDate)),'YEARLY TOTAL')
ELSE ''
END AS MONTH,
-- SQL currency formatting
'$'+CONVERT(varchar,SUM(TotalDue),1) AS [MONTHLY SALES SUBTOTAL]
FROM AdventureWorks2008.Sales.SalesOrderHeader
GROUP BY Year(OrderDate),
Month(OrderDate) WITH ROLLUP
ORDER BY YEAR,
MONTH
/* Partial results

YEAR MONTH MONTHLY SALES SUBTOTAL
2004 4 $4,722,890.74
2004 5 $6,518,825.23
2004 6 $6,728,034.99
2004 7 $56,178.92
2004 YEARLY TOTAL $32,196,912.42
GRAND TOTAL $140,707,584.82
*/

------------

First complex example: GROUP BY..WITH ROLLUP is used to generate subtotal at the Quarter level, total at the Year level and grand total for all times AdventureWorks Cycle in business. While the output is easily understandable, the total query is on the complex side.

------------
-- Microsoft SQL grand total, total, subtotal generation with T-SQL GROUP BY ROLLUP
------------
-- MSSQL grouping function
USE AdventureWorks2008;

SELECT TotalType = CASE
WHEN GROUPING(left(CONVERT(CHAR(8),OrderDate,112),4)) = 1
THEN 'GRAND TOTAL'
WHEN GROUPING(left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1)) = 1
THEN 'TOTAL - YY'
WHEN GROUPING(left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1) +
right('0' + CONVERT(VARCHAR,month(OrderDate)),2)) = 1
THEN 'SUBTOTAL - QQ'
ELSE ''
END,
[Year] = ISNULL(left(CONVERT(CHAR(8),OrderDate,112),4),''),
[Quarter] = ISNULL(left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1),
''),
[Month] = COALESCE(left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1) + right('0' +
CONVERT(VARCHAR,month(OrderDate)),2),
''),
Purchases = '$' + CONVERT(VARCHAR,SUM(SubTotal),1)
FROM Purchasing.PurchaseOrderHeader
GROUP BY left(CONVERT(CHAR(8),OrderDate,112),4),
left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1),
left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1) + right('0' +
CONVERT(VARCHAR,month(OrderDate)),2) WITH ROLLUP
ORDER BY GROUPING(left(CONVERT(CHAR(8),OrderDate,112),4)),
[Year],
GROUPING(left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1)),
[Quarter],
GROUPING(left(CONVERT(CHAR(8),OrderDate,112),4) + 'Q' +
CONVERT(CHAR(1),(month(OrderDate) - 1) / 3 + 1) + right('0' +
CONVERT(VARCHAR,month(OrderDate)),2)),
[Month]

/* Results

TotalType Year Quarter Month Purchases
2001 2001Q2 2001Q205 $103,895.82
SUBTOTAL - QQ 2001 2001Q2 $103,895.82
TOTAL - YY 2001 $103,895.82
2002 2002Q1 2002Q101 $299,239.98
2002 2002Q1 2002Q102 $700,406.63
2002 2002Q1 2002Q103 $328,572.46
SUBTOTAL - QQ 2002 2002Q1 $1,328,219.07
2002 2002Q2 2002Q204 $646,975.84
2002 2002Q2 2002Q205 $298,745.12
2002 2002Q2 2002Q206 $106,491.00
SUBTOTAL - QQ 2002 2002Q2 $1,052,211.96
2002 2002Q3 2002Q307 $655,405.08
2002 2002Q3 2002Q308 $116,119.65
2002 2002Q3 2002Q309 $499,186.65
SUBTOTAL - QQ 2002 2002Q3 $1,270,711.38
2002 2002Q4 2002Q410 $186,121.65
2002 2002Q4 2002Q411 $388,868.98
SUBTOTAL - QQ 2002 2002Q4 $574,990.63
TOTAL - YY 2002 $4,226,133.03
2003 2003Q1 2003Q103 $131,485.79
SUBTOTAL - QQ 2003 2003Q1 $131,485.79
2003 2003Q2 2003Q205 $641,097.40
2003 2003Q2 2003Q206 $924,127.80
SUBTOTAL - QQ 2003 2003Q2 $1,565,225.19
2003 2003Q3 2003Q307 $105,014.51
2003 2003Q3 2003Q308 $98,304.85
2003 2003Q3 2003Q309 $5,100,678.73
SUBTOTAL - QQ 2003 2003Q3 $5,303,998.10
2003 2003Q4 2003Q410 $3,449,392.92
2003 2003Q4 2003Q411 $1,775,204.15
2003 2003Q4 2003Q412 $3,424,287.10
SUBTOTAL - QQ 2003 2003Q4 $8,648,884.17
TOTAL - YY 2003 $15,649,593.25
2004 2004Q1 2004Q101 $4,266,022.62
2004 2004Q1 2004Q102 $4,137,584.18
2004 2004Q1 2004Q103 $4,704,085.56
SUBTOTAL - QQ 2004 2004Q1 $13,107,692.37
2004 2004Q2 2004Q204 $5,172,365.20
2004 2004Q2 2004Q205 $5,729,967.42
2004 2004Q2 2004Q206 $5,522,963.61
SUBTOTAL - QQ 2004 2004Q2 $16,425,296.24
2004 2004Q3 2004Q307 $6,710,223.01
2004 2004Q3 2004Q308 $6,824,989.46
2004 2004Q3 2004Q309 $743,151.66
SUBTOTAL - QQ 2004 2004Q3 $14,278,364.13
2004 2004Q4 2004Q410 $1,020.00
SUBTOTAL - QQ 2004 2004Q4 $1,020.00
TOTAL - YY 2004 $43,812,372.74
GRAND TOTAL $63,791,994.84
*/
------------

Second complex example: summary query generates Subtotal, Total and Grand Total for monthly, yearly and all times sales. In data warehousing, the dates are referred to as date (or time) dimension with 3 levels.

------------
-- GRAND TOTAL (all times), TOTAL (year), SUBTOTAL (month) mssql select query
------------
-- Microsoft T-SQL derived table rpt generates the report - select from select
-- The outer query does the final filtering and sorting
USE AdventureWorks;

SELECT *
FROM
(
SELECT YY=COALESCE(CONVERT(varchar,YEAR(OrderDate)),''),
MM=COALESCE(LEFT(CONVERT(varchar,OrderDate,111),7),''),
ORDERS = COUNT(*),
SALES = '$'+CONVERT(varchar,SUM(TotalDue),1),
GRPMM = CASE WHEN
GROUPING(LEFT(CONVERT(varchar,OrderDate,111),7)) = 0
AND GROUPING(YEAR(OrderDate)) = 1
THEN 'SUBTOTAL' ELSE '' END,
GRPYY= CASE WHEN GROUPING(YEAR(OrderDate)) = 0
AND GROUPING(LEFT(CONVERT(varchar,OrderDate,111),7)) = 1
THEN 'TOTAL' ELSE '' END,
GRPALL = CASE WHEN
GROUPING(LEFT(CONVERT(varchar,OrderDate,111),7)) = 1
AND GROUPING(YEAR(OrderDate)) = 1
THEN 'GRAND TOTAL' ELSE '' END

FROM Sales.SalesOrderHeader
GROUP BY YEAR(OrderDate), LEFT(CONVERT(varchar,OrderDate,111),7)
WITH CUBE
) rpt
WHERE
GRPMM != '' OR GRPYY !='' OR GRPALL !=''
ORDER BY
CASE WHEN GRPALL!= '' THEN 3
WHEN GRPYY != '' THEN 2
ELSE 1 END,
YY, MM
GO
/* Partial results

YY MM ORDERS SALES GRPMM GRPYY GRPALL
2004/04 2127 $4,268,473.54 SUBTOTAL
2004/05 2386 $5,813,557.45 SUBTOTAL
2004/06 2374 $6,004,155.77 SUBTOTAL
2004/07 976 $56,178.92 SUBTOTAL
2001 1379 $12,693,250.63 TOTAL
2002 3692 $34,463,848.44 TOTAL
2003 12443 $47,171,489.55 TOTAL
2004 13950 $28,887,306.04 TOTAL
31464 $123,215,894.65 GRAND TOTAL
*/

------------

Third complex example: the MonthlyOrderSummary stored procedure will generate Account Number Total (subtotal), Day Total (total)and Month Total (grand total) columns.
------------
-- T-SQL grand total, total, subtotal stored procedure
------------
-- T-SQL create stored procedure
USE AdventureWorks2008;
GO
CREATE PROCEDURE MonthlyOrderSummary
-- ALTER PROCEDURE MonthlyOrderSummary
@Year INT,
@Month INT
AS
BEGIN
SELECT soh.AccountNumber,
PO = isnull(soh.PurchaseOrderNumber,''),
convert(CHAR(10),soh.OrderDate,111) AS 'Order Date',
soh.TotalDue,
CASE
WHEN SalesOrderID = (
SELECT TOP 1 SalesOrderID
FROM Sales.SalesOrderHeader
WHERE convert(CHAR(10),OrderDate,111) =
convert(CHAR(10),soh.OrderDate,111)
ORDER BY SalesOrderID DESC) THEN (SELECT '$' +
convert(VARCHAR,sum(TotalDue),1)
FROM Sales.SalesOrderHeader
WHERE SalesOrderID <= soh.SalesOrderID AND convert(CHAR(11),OrderDate,111) = convert(CHAR(10),soh.OrderDate,111)) ELSE ' ' END AS 'Day Total', CASE WHEN SalesOrderID = ( SELECT TOP 1 SalesOrderID FROM Sales.SalesOrderHeader WHERE year(OrderDate) = @Year AND month(OrderDate) = @Month ORDER BY OrderDate DESC) THEN (SELECT '$' + convert(VARCHAR,sum(TotalDue),1) FROM Sales.SalesOrderHeader WHERE year(OrderDate) = @Year AND month(OrderDate) = @Month) ELSE ' ' END AS 'Month Total' FROM Sales.SalesOrderHeader soh WHERE year(OrderDate) = @Year AND month(OrderDate) = @Month ORDER BY SalesOrderID END GO -- MSSQL execute stored procedure with 2 parameters EXEC MonthlyOrderSummary 2003, 7 GO /* Partial results - TotalDue is SUBTOTAL Day Total is TOTAL Month Total is GRAND TOTAL AccountNumber PO Order Date TotalDue Day Total Month Total 10-4030-011069 2003/07/30 2563.589 10-4030-011101 2003/07/30 2696.189 10-4030-026306 2003/07/30 830.2307 10-4030-024421 2003/07/30 2703.9903 10-4030-022398 2003/07/30 596.689 $23,476.44 10-4030-019435 2003/07/31 2715.3497 $4,681,520.64 */ ------------

delphi 2007 Output directory problem

Merhaba Codegear 2007 de 64 bit işletim sistemine yüklediğimizde output Directoy ye exe dosyasını oluşturmuyor.Bu durumda yapmanız gerekenler aşağıda ayrıntılı olarak anlatılmış


http://support.embarcadero.com/article/37522


http://support.codegear.com/article/37251

Doğa İçin Çal 2

Merhaba 2. kez Doğa için çalmışlar

Doga icin Cal 2 / Uzun ince bir yoldayim - official video from Doga icin cal on Vimeo.

Sql server 2008 de log dosyasını truncate etme

Merhaba Artık sql server 2008 de log dosyalarının boyutunu küçültmek isterseniz aşağıdaki komutu kullanabilirsiniz.

DBCC SHRINKFILE (2, TRUNCATEONLY)

Doğa İçin Çal

Bugün sizlere farklı bir içerik malumunuz çevremiz küresel ısınma diğer bir sürü şey var bunun için örnek bir çalışma

Doga icin cal ! / Divane Asik Gibi - Official Video from Doga icin cal on Vimeo.

Sql Server 2008 Reporting Service Access Denied

Merhaba XP işletim sistemli makinalarda SQL Server Reporting Service kurulup yönetimsel olarak girmeye çalıştığımızda 403.1 Accsess Denied hatası alabiliriz.Bu hatayı gidermek için yapılması gereken Windowsta basit dosya yönetimini kapatıp kullanıcıya o dizinlere erişim hakları vermelisiniz Basit dosya yönetimini kapatmak ve erişim izni vermek için izlenecek adımlar aşağıdaki gibidir.

1. herhangi bir Explorer Penceresinden araçlar mönüsünden klasör seçenekleri açın
2. Görünüm sekmesine geçip basit dosya paylaşımını kullan(Öenrilen ) işaretini kaldırın
3. ve program files altında SSRS2008 in kurulu olduğu dizinde ReportManager klasörünü sağ tıklayıp özelliklerinde güvenlik sekmesini açın ve girmeye çalıştığınız kullanıcıya yetkiler verin (Aynı şeyi ReportServer dizini için de gerçekleştirin)
4. Daha sonra SSRS 2008 i yeniden başlatıp tekrar deneyin
   

Alter failed for Login 'sa'. (Microsoft.SqlServer.Smo)

Sql Server 2008 management toolu kulanırken 2005 deki sa şifresini değiştirmek isterseniz aşağıdaki gibi bir hata alıyorsanız yapmanız gereken şudur

Login properties penceresinde Map to Credential onay kutusunu (checkboxu) işaretleyip şifreyi değiştirmeniz yeterli olacaktır.

daha fazlası için

http://support.microsoft.com/default.aspx/kb/956177


TITLE: Microsoft SQL Server Management Studio
------------------------------
Alter failed for Login 'sa'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot set a credential for principal 'sa'. (Microsoft SQL Server, Error: 15535)
------------------------------

Yine Askerden Merhaba

Biz askerliğe devam ediyoruz ama biter bitmez bu bloğun adını çok duyacaksınız Tabi sizin desteklerinizle az kaldı diyemiyorum ama elbet bir gün bitecek

Askerden Merhaba

Uzun süredir buralara yazamadım ama artık askerim elimin altında NET namına sadece KaraNET var :) hafta sonları anca internetle haşır neşir olabiliyorum napalım buda bitecek inşallah herkes kendine iyi davransın askerlik kısalsın başka ne isteyelim MYO lulara kısaltacaklardı ama oda olmadı yapacak bişi yok Yaylalar yaylalar ama daha bir kez bile söylemedik eskidenmiş onlar

Mysql::Error: #42000Identifier name 'index_globalize_translations_on_table_name_

Merhaba Ruby globalization çoklu dil desteği için sık kullanılan pluginlerden biri de Globalize for Rails bu plugini kurarken karşıma çok ilginç bir hata mesajı çıktı ve nasıl çözüleceğini biraz araştırdıkan sonra bulabildim Mysql de index isimlerinde bir kısıtlama varmış (onu da bu sayede öğrendim :) (64 karaktermiş ) ama bizim plugin 70 karakterlik bir index ismi oluşturduğu için
kızıyordu) Neyse daha sonra uygulamanın vendor/plugins/for-1.1/tasks/data.rake dosyasının
71. satırındaki

ActiveRecord::Base.connection.add_index :globalize_translations, [:table_name, :item_id, :language_id]

ActiveRecord::Base.connection.add_index(:globalize_translations, [:table_name, :item_id, :language_id], :name => 'gt_tbl_item_lng')

ile değiştirdiğimde sorunum çözülmüş oldu

Mysql::Error: #42000Identifier name 'index_globalize_translations_on_table_name_
and_item_id_and_language_id' is too long: CREATE INDEX `index_globalize_transla
tions_on_table_name_and_item_id_and_language_id` ON globalize_translations (`tab
le_name`, `item_id`, `language_id`)

Delphi 7 C# web servisinde parametrelerin boş gitmesi

Merhaba
c# asp.net 2.0 yazılmış bir webservice uygulamasına  delphide yazılan bir uygulama ile bağlanılıyorsa
ve bu bağlantı sırasında göndermiş olduğunuz parametreleri c# web servisi kontrol etmeme gibi
bir problemle karşılaşırsanız initilaze kısmına
böyle bir satır yazmanız gerekir

InvRegistry.RegisterInvokeOptions(TypeInfo(xxx), ioDocument);

Not:xxx  SOAP arabirim adı
Örnek benim servisim (WelfWebServisleri) eklenecek satır 
InvRegistry.RegisterInvokeOptions(TypeInfo(
WelfWebServisleri), ioDocument);


http://www.bobswart.nl/Weblog/Blog.aspx?RootId=5:798

SQL Server 2000 installation fails with "...previous program ...

Merhaba Sql server kurarken (özellikle MSDE ) böyle bir hata ile karşılaştım şöyle bir çözümü var
Registryde bazen eski setuplar takılabiliyor
Bunun için
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
bu dizin altındaki
PendingFileRenameOperations değerini silip tekrar kurmayı deneyin

Daha fazla ilgi için
http://support.microsoft.com/kb/312995