125 reputation
5
bio website
location
age 34
visits member for 1 year, 9 months
seen Feb 17 at 9:31

.NET Developer (C#):

  • .ADO NET / Entity Framework
  • WCF
  • WPF
  • MEF
  • N-tier applications.

Aug
19
awarded  Popular Question
Feb
17
awarded  Popular Question
Sep
16
comment Why SMO's Transfer tries to login into linked server when scripting?
The problem is that I don't need metadata of linked server's object at all. For example, there's a stored proc in my database, which retrieves something from linked server. I understand, why I need to be logged in for executing this SP. But I don't understand, why I need this for retrieving SP's body, which is stored as a text.
Sep
16
asked Why SMO's Transfer tries to login into linked server when scripting?
Apr
2
accepted SQL Server uses only 1 CPU of 4 available
Apr
2
comment SQL Server uses only 1 CPU of 4 available
@EdHarper: thanks for the link, I think, the problem is that on my work machine I have 1 CPU with 4 cores, and on production - 4 CPUs.
Apr
2
comment SQL Server uses only 1 CPU of 4 available
Do you mean physical CPU or cores?
Apr
2
asked SQL Server uses only 1 CPU of 4 available
Dec
10
awarded  Scholar
Dec
10
awarded  Supporter
Dec
10
accepted Can't grant role permissions under sysadmin login
Dec
7
comment Can't grant role permissions under sysadmin login
@ThomasStringer: yes, I'm sure. If I modify script a little to GRANT ALTER ON ROLE::[AdaptTemplate] TO [AdaptAdmin] (so, instead of AdminSapr I'm using security context of my current login), then it being executed successfully.
Dec
7
awarded  Student
Dec
7
comment Can't grant role permissions under sysadmin login
@dezso: no, there are no any limitations. Looks like AdminSapr hasn't sufficient rights to grant alter role.
Dec
7
asked Can't grant role permissions under sysadmin login