1,034 reputation
2526
bio website
location Sydney, Australia
age
visits member for 1 year, 8 months
seen Apr 7 at 6:09

Apr
7
accepted How to set the Tablix Outer border width weight?
Apr
6
revised How to set the Tablix Outer border width weight?
added 87 characters in body
Apr
6
revised How to set the Tablix Outer border width weight?
added 13 characters in body
Apr
6
revised How to set the Tablix Outer border width weight?
added 22 characters in body
Apr
6
asked How to set the Tablix Outer border width weight?
Apr
3
awarded  Popular Question
Apr
3
asked Creating Excel files in SSIS based with a predefined format
Mar
21
awarded  Popular Question
Feb
26
awarded  Notable Question
Jan
7
awarded  Famous Question
Dec
17
revised Importing data from Firebird to SQL Server 2008 R2 using ODBC
added 1 characters in body
Dec
17
asked Importing data from Firebird to SQL Server 2008 R2 using ODBC
Dec
16
awarded  Popular Question
Dec
16
awarded  Popular Question
Dec
12
comment Move values from one table to another one via stored procedure in sql server 2008
I think the best way is using the trigger as described below by Kin, otherwise even if you implement a stored proc, how do you want to call it? Trigger is the best option for this.
Dec
11
comment Uniqueidentifier vs. IDENTITY vs. Material Code --which is the best choice for primary key?
I agree with Joel. Sometimes the natural keys are subject to change or duplication. In these cases, obviously they are not good candidate for primary keys.
Dec
9
comment OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
I installed it from the link above, reopen the SQL management studio but still this provider is not listed there. Is there anything else should be done to add it to the provider list?
Dec
9
comment OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
Thanks for your time. I think the reason it's not working for me, is because I don't have 'Microsoft.Ace.OLEDB.12.0' among the providers as you specified in your answer. Could you please advise me how to add it? I've edited my question to include the provider lists I've got currently.
Dec
9
revised OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries
added 143 characters in body
Dec
8
asked OpenRowSet - How to configure OLE DB Provider to be used for for distributed queries