Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 9
Newest
 Teacher
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Jun
1
comment What is the optimal way to design an approval queue and audit trail for entities in SQL Server 2008 R2?
@JNK, since that i wasn't in the chat room at the time you explained all the concepts, is it possible to tell us how to solve the problem where another table can link to one customer only but the customer exist twice (one version approved and one version not approved) since they share the same CustomerId?
Jan
26
accepted How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Jan
17
awarded  Teacher
Dec
23
awarded  Popular Question
Dec
17
answered How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Nov
25
comment How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Yes i've also tried to add permissions on the folder where the .mdb resides.
Nov
25
awarded  Commentator
Nov
25
comment How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
I tried to add permissions to the TEMP folder without success. If i add the user to the Administrator group, it work (only for an AD user, not SQL Server user)
Nov
25
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
added 4 characters in body
Nov
24
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
added 683 characters in body
Nov
22
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
edited tags
Nov
22
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
added 97 characters in body
Nov
20
asked How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Jun
17
awarded  Notable Question
Nov
21
awarded  Popular Question
May
3
accepted What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
May
3
comment What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
We havent developed anything yet. Everything is fresh on SQL Server 2012. So i guest the best bet is to use the newest configurtion everywhere.
May
3
asked What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
Apr
22
awarded  Scholar
Apr
22
accepted import csv data stored in a blob column