Reputation
2,369
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
4 12
Newest
 sql-server
Impact
~215k people reached

  • 0 posts edited
  • 0 helpful flags
  • 124 votes cast
Apr
19
awarded  sql-server
Apr
1
awarded  Enlightened
Apr
1
awarded  Nice Answer
Jan
10
awarded  Nice Answer
Oct
31
awarded  Yearling
Oct
31
awarded  Yearling
Sep
24
awarded  Autobiographer
Aug
15
awarded  Nice Answer
Oct
31
awarded  Yearling
Oct
29
awarded  Announcer
Apr
29
awarded  Revival
Dec
6
answered How can I stop SQL from validating an OPENROWSET query when its not going to be executed?
Dec
5
revised Generate insert statements for table AND related data
added 1560 characters in body
Dec
5
revised Generate insert statements for table AND related data
added 1560 characters in body
Dec
5
comment Generate insert statements for table AND related data
Could you elaborate on what you mean by "tie up the FK / PK"? Is that "find all of the records which exist in DB1.dbo.T1 and not in DB2.dbo.T1, and add those to DB2's T1" or do you mean something else by that?
Dec
5
answered Generate insert statements for table AND related data
Dec
4
comment SQL Server 2008R2 - How to prevent a role from creating or altering views within a database?
You are correct. What's interesting is that MSDN implies that this denying create should then deny alter (msdn.microsoft.com/en-us/library/ms177518.aspx), but it is not the case.
Dec
4
answered SQL Server 2008R2 - How to prevent a role from creating or altering views within a database?
Dec
4
revised SQL Server - How to know when a database has been restored
Added another query to flesh out this answer.
Dec
4
answered SQL Server - How to know when a database has been restored