To my knowledge you should not have any problems.  I would suggest you put the SQL code into a stored procedure (obviously) and as long as you have your begin...

It appears you are trying to create a data warehouse.  Have you considered using Analysis Services and instead of backup/restores create jobs to move only the new data (denormalizing in...

I would suggest doing this in two steps.

First step is the update process.  Don't worry about if the non-key fields match or not because if they match the update won't...

You are not missing anything (at least to me).  However, I would suggest option 3 and that is the truely normalized version.  The fact that you have a large number...

To provide real assistance I'll need a general idea of the table structure transferred from Access and I have a feeling the solution that will work in the end is...

I think you'll need to use a cursor to do it.  yuck.

declare curCallNotes cursor static for select call, note from tCalls open curCallNotes

declare @Call int --This would be whatever the key...

There isn't a limitation, but why on earth would you do it?  What are you trying to achieve?  This would be a performance killer.  Also, be aware your cursors will...

It appears either the function fn_trace_getinfo doesn't exist on the server OR the function does exist but system_function_schema isn't the owner/schema name for the function.

c

I agree with Phillip on this.  Use the books online and pay attention to how SQL Server usings the various types in calculations.  Size and expected use are the keys...

I follow a similar structure throughout my database designs (Identity fields as primary keys) for the following reasons:

1) It allows me the assumption that a primary key is always an integer...

Can you supply some sample data of what you are passing?  If the character strings are not in a usuable format you could get a null.

It is possible to do it but you would be taking a performance hit in order to do so.  You either write all the code within the proc and only...

I don't know the actual answer, but turn on the profiler and then get the info from enterprise manager.  You should then be able to get the SQL from the...

What is the table structure and the VB code? 

Is the front end Visual Basic 6?  If it is, you may want to create a global subroutine to loop through the recordsets of the Stored Procedure.  I use the...