如何改变2008年本地安装 Sql 服务器的sa 密码?
<强 > 注:我不知道sa账户的密码
线条的回复真的迟了 但我刚刚丢失了 并重设了SA的密码
你们在简易的步伐之下,
在窗口验证模式中连接 SQL 服务器 。
前往“ 坚固” 安全 < / 坚固”, 并探索它 。
跳转到 < 强度 > 安全 < 强度 > 下 < 强度 > /强度 < 强度 > 。
选择用户 < 加固>sa
点击 < 强度 > / 强点 < 强度 > 并选择 < 强度 > properies
You will get reset password option here, change it and log-in with new password again.
欢呼声:
单行
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N NewPassword
GO
也可以进入安全,右单击 ss,选择属性并在密码字段中更改属性
I need to declare 12 decimal variables, corresponding to each month s year, with a cursor I sum values to this variables, then later I Update some sales information. I don t know if sql server has ...
Does anyone have experience with using indexed view in MS SQL Server 2008? I am trying to find out how does indexed view affect performance of insert / update statements, that are adding / updating ...
In Microsoft SQL Server Management Studio 2008, is there a secret to be able to edit one row based on a key? There s an option to do "Edit Top 200 Rows", but what if I want to select some other row ...
Has anyone any experience moving a number of identical SQL Server databases (with unique data) from individual local servers to a single internet based server? We currently have 10 companies using ...
While altering a table (removing a column) in SQL Server 2008, I clicked the Generate Change Script button and I noticed that the change script it generated drops the column, says "go" and then runs ...
I have a Money column in my SQL Server 2008 table. In my below query how can I round it to nearest 5$ select FineAmount from tickets Thanks
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
I am starting a project to create an "object versioning" feature for our software (.NET 3.5 / SQL Server 2008), basically it needs to do this: a user is looking at a customer: last name is "Smith-...