You are better off getting RedGate's SQLCompare or ApexSQL's SQLDiff products which do the comparison's for you. RedGate has 14 day free trail and I believe ApexSQL has a...

I'm not sure what you are asking. Do you want to take the data from the first table and create a table from the data? Does this need...

You have posted in an inappropriate forum. You would have gotten better results if you had posted in the appropriate forum.

You might want to check this link, http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/run-time-error-2147467259-80004005-connection-failure-1250981?cv=expanded

Did you install the Reporting Services service and web site on the your pc? When you go to Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration...

Great, glad I could help.

That's why...

Generally putting a user-defined function in your SELECT list will not perform well because the function has to be evaluated for each row, thus causing RBAR.

As Steve suggests you would...

Will this be a one time thing or something done on a regular basis? Are you keeping the same structures or importing into a new structure?

I suggest looking at...

If you are refreshing daily use truncate then insert into - select

Glad Gail answered this one. I have always personally preferred option 2 because I find the LEFT JOIN syntax easier to read, but I have learned that the EXISTS/NOT...

The only issue with Ronald's post is that using a function (Replace) in the where clause negates any indexes you may have on the code column.

If the code is always...

TO my knowledge there is no way to get the SQL statement executed from within a DML trigger. If you need to log SQL statements you would need to...

Also in the Dataset properties you can assign the same report parameter to both the query parameters.

Not that I am aware of. SSMS will only display 2000 and above.

Might I ask why you want to purposely slow down an application?