16 reputation
7
bio website ardinsys.eu
location Hungary
age 33
visits member for 4 years, 7 months
seen Nov 28 at 11:11

I just want to get an Autobiographer badge ;-)


Sep
12
awarded  Popular Question
Oct
22
awarded  Suffrage
Aug
25
awarded  Supporter
Aug
12
awarded  Teacher
Aug
11
answered Windows 7 / Samba “access denied” message from xcopy
Jun
2
comment What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?
"Well, except some exotic stuff, like fetching the result set of nested stored procedures." Which can prove to be a nontrivial problem when simply using four part naming and INSERT-EXEC, try googling "An INSERT EXEC statement cannot be nested". In my case, I want to query the execution status of jobs from a T-SQL script, for which the adequate facility seems to be sp_help_job (see microsoft.com/technet/abouttn/flash/tips/tips_060804.mspx). I want to use sp_help_job in an automated script, and fetch its result set with INSERT-EXEC, in which case I get the mentioned error message.
Jun
2
comment What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?
This is technically correct if speaking of real linked servers. This case is specific, however: I want to enable OPENQUERY-like access to the local server. With the right credentials, one can already do a lot of malicious business without this setting enabled. Well, except some exotic stuff, like fetching the result set of nested stored procedures. Not really the thing that a potential attacker would wish for, I guess.
May
31
awarded  Student
May
28
revised What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?
misspelled first name
May
28
revised What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?
small grammatical error
May
27
awarded  Editor
May
27
revised What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?
added 92 characters in body
May
27
asked What are the possible disadvantages of enabling the “data access” server option in sys.servers for the local server?
May
27
awarded  Autobiographer