1) Open SQL Server Management Studio and Login
2) In Object Explorer, click Security followed by Logins
3) Right click sa user and select Properties.
4) Uncheck Enforce password policy
5) Select Status. Click the Grant and Enabled radio buttons. Click OK
6) In the Registered Servers top pane, right click on the database and choose restart
Login failed for user 'sa'. Reason: The account is disabled.
Gönderen
pantepember
27 Ağustos 2009 Perşembe
Etiketler: login failed , sa , sql server
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1
Gönderen
pantepember
19 Ağustos 2009 Çarşamba
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1
Hatalı:
BEGIN
SET NOCOUNT ON;
BEGIN TRAN
BEGIN TRY
IF(...)
BEGIN
...
COMMIT TRAN
SELECT 1
END
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT ERROR_MESSAGE() -- işlem başarısız
END CATCH
END
Doğru:
BEGIN
SET NOCOUNT ON;
IF(...)
BEGIN TRY
BEGIN TRAN
...
COMMIT TRAN
SELECT 1
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT ERROR_MESSAGE() -- işlem başarısız
END CATCH
END
Etiketler: begin try , sql , tran , transaction