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

.NET Developer (C#):

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

Sep
24
awarded  Autobiographer
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