How can we help you today? How can we help you today?
anders_rehnstrom
Activity overview Badges (0) Posts (1) Comments (3)

Activity overview

Latest activity by anders_rehnstrom

Great, thanks! /Anders / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Different collation on user db and SQL Server instance.
Great, thanks! /Anders
0 votes
So according to you, #tmpErrors is the only real temporary table that is created during script-generation?! /Anders / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Different collation on user db and SQL Server instance.
So according to you, #tmpErrors is the only real temporary table that is created during script-generation?! /Anders
0 votes
We have noticed you (as SQL Server Management Studio) using TMP_XXX as temporary tables (that is ordinary tables within the database) and these are of no problem since they obey the collation of the current db. In which cases do you create real temp tables reciding within tempdb using # or ## before the table name? (These are the objects of concern) /Anders / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Different collation on user db and SQL Server instance.
We have noticed you (as SQL Server Management Studio) using TMP_XXX as temporary tables (that is ordinary tables within the database) and these are of no problem since they obey the collation of th...
0 votes
Different collation on user db and SQL Server instance.
  1. Community
  2. SQL Compare Previous Versions
My user data base and SQL Server instance has different collation. Having different collation might cause problem when "combining" temporary tables (same collation as SQL Server instance) and user ...
2 followers 6 comments 0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1