810 reputation
618
bio website
location New York, NY
age 37
visits member for 3 years, 1 month
seen Apr 14 at 13:10

Mar
4
accepted Pull Access schema into a SQL Server table
Mar
4
answered Pull Access schema into a SQL Server table
Mar
4
asked Will a primary key be added as a clustered index?
Mar
1
awarded  Yearling
Mar
1
comment Pull Access schema into a SQL Server table
The assembly that is failing is a visual basic procedure. Unfortunatly the Ace Driver is failing to connect to the DB for him but the same driver is working fine with my linked servers. We've been through tons of support and work with the assembly and at this point were looking to see if there is another option
Feb
27
asked Pull Access schema into a SQL Server table
Feb
15
awarded  Popular Question
Feb
8
accepted identify blocking and send alert
Feb
7
comment identify blocking and send alert
@Aaron Bertrand I can't stop smiliing. That was done very well. I'll look into it. Albeit I doubt I'll be able to get any expenditures past my boss at the moment.
Feb
7
comment identify blocking and send alert
@Aaron Bertrand that sounds great. Are there any that you recommend?
Feb
7
asked identify blocking and send alert
Feb
5
accepted comma delimited column fix
Feb
5
comment comma delimited column fix
Thanks. Yes the UI is expecting to do DML against the view. I'll read the link
Feb
5
comment comma delimited column fix
@Martin Smith - Excellent question. The queries include data modification statements.
Feb
5
comment comma delimited column fix
@Thomas Stringer - I've updated the question with the information
Feb
5
revised comma delimited column fix
added 712 characters in body
Feb
5
asked comma delimited column fix
Jan
31
accepted return percentage of records based on value in column
Jan
31
asked return percentage of records based on value in column
Jan
28
comment Invalid use of side-effecting operator 'INSERT EXEC' within a function
Aaron Bertrand - I'm looking to send in a SQL query as @SQL and return a delimited list of the results.