Reputation
5,121
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 18 43
Impact
~584k people reached

Jan
11
asked View SQL's errorlog in Amazon RDS
Jan
10
comment Query two SQL Server databases in same function but on two different servers
The code I included above is an example of a cross-server join. YourTable is being joined to OtherTable, but they each exist on different servers.
Jan
3
answered Multiple triggers vs a single trigger
Jan
2
answered Transaction and Try-catch in SQL Server Job
Dec
17
awarded  Revival
Dec
6
awarded  Enlightened
Dec
6
awarded  Nice Answer
Nov
19
accepted Drop constraints vs disable constraints during a data import
Nov
10
answered Is there a backup operator role in Microsoft SQL Server 2008?
Nov
5
answered Download SQL Server Profiler for SQL Server Management Studio
Nov
1
accepted Does adding page compression to a table also compress existing indexes?
Nov
1
asked Does adding page compression to a table also compress existing indexes?
Oct
19
revised What permissions are required to view the contents of a catalog on a remote server?
added 88 characters in body
Oct
18
comment What permissions are required to view the contents of a catalog on a remote server?
I would not have added the mysql tag, because the issue is not at the mysql end. The same login is being used (as defined in the linked server definition) regardless of what SQL Server account is currently logged in.
Oct
18
asked What permissions are required to view the contents of a catalog on a remote server?
Oct
5
comment Potential risks of users connecting to SQL Server, through Excel, as sysadmin?
TPTB = The Powers That Be
Oct
4
revised Could not find the Server Agent in SSMS
Added an explanation.
Oct
3
answered What tasks can only sysadmin's do in SQL Server 2000?
Oct
1
answered Could not find the Server Agent in SSMS
Sep
30
revised SQL Server 2008 and compatibility level 80
added 234 characters in body