Reputation
294
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 12
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 30 votes cast
Jul
29
asked Permissions To Update Legacy DTS Packages
Jul
21
comment Linked Server Query Failures Due To Indexes
Hi Kin. Thank you for the reply. I used sp_MSset_oledb_prop to search our entire enterprise and every provider we have is setup with "Index as access path" = 0. Oddly though, none of the providers have any linked servers associated with them when viewing through Provider Options although we have a fair number of functioning linked servers.
Jul
20
revised Linked Server Query Failures Due To Indexes
deleted 5 characters in body
Jul
20
asked Linked Server Query Failures Due To Indexes
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
@AaronBertrand thanks!!
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
@AaronBertrand, how do you usually setup servers? Do you turn browser off and leave Hide Instance = NO?
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
Thanks to both of you!
Jul
8
comment Hiding a SQL Server vs Turning Off SQL Browser
Thanks much Kin. I do have 3 server instances that are hidden; however, I can reach them via TCP/IP. I can confirm that by connecting to the instance from my local machine or a DSN using "ServerName,1433". Is that being translated on the server to shared memory somehow? I believe that that is true only if you turn off all TCP/IP and Named Pipes.
Jul
8
accepted Hiding a SQL Server vs Turning Off SQL Browser
Jul
8
asked Hiding a SQL Server vs Turning Off SQL Browser
Jun
25
awarded  Popular Question
May
15
awarded  Critic
Apr
9
revised “Access is denied” when connecting SSMS to Integration Services
Better explanation
Apr
9
answered “Access is denied” when connecting SSMS to Integration Services
Apr
9
comment Can I retrieve all database objects owned by a particular user?
@JonSeigel I have written one using a UNION to the above. Can you post yours so I can compare and improve mine?
Feb
9
comment SQL Server: Invalid Log Scan Number (…) passed to log scan in database (…) is not valid
Thanks Dan! I saw this when you posted it but forgot to say something. We are planning to do this over the weekend.
Feb
1
awarded  Teacher
Jan
31
answered SQL Server: Invalid Log Scan Number (…) passed to log scan in database (…) is not valid
Jan
31
awarded  Editor
Jan
31
revised SQL Server: Invalid Log Scan Number (…) passed to log scan in database (…) is not valid
deleted 8 characters in body and bulleted artical search