lost etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster
lost etiketine sahip kayıtlar gösteriliyor. Tüm kayıtları göster

2 Ocak 2015 Cuma

SQL SERVER - If noone has Sysadmin rights or SA password is lost?

Go to pproperties of relates servers from SQL Server Configuration Manager. Advanced->Properties than put "-m" parameter. Carefull about you have to put ";" after last parameter and put no space! I mean ";-m" (Without quotes).
Restart to SQL Server. Server will run in single mode.
Run SQLCMD.EXE as administrator. Give Sysadmin rights to your Windows user which you use at login for your SQL Server:
EXEC sp_addsrvrolemember "myserver\myuser","sysadmin";
GO


or

EXEC sp_password NULL, 'newpwd', 'sa';
GO

Don't forget delete parameter and restart server at regular mode!..

Source:
http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

17 Temmuz 2014 Perşembe

AX 2012 - My New Field's Value Disappearing when Editing VendInvoiceInfoTable

I add a new field to VendInvoiceInfoTable When try to edit with VendEditInvoice form I saw my new field's value is empty. After a long research I found out Axapta copy source record to another record and edit this new record. Meanwhile Axapta skips my new field. Axapta uses table method copyFromHeader while copying. Add my new line:

    this.VendorRequestedWorkerEmail = _header.VendorRequestedWorkerEmail;
    //my new field
    this.myNewField     = _header.
myNewField;

Problem overed. Same method valid for related VendInvoiceInfoLine table too.