for SQL 2008 R2 SSMS was installed as part of the SQL Server installer - you can get it from there.

to avoid installing it on your pc I would check...

as it would be a unique index I don't believe there would be negative impact on that table (at least not significant).

for the trigger - yes the idea is that...

instead of a Primary Key you can define it as a Unique Index.

one of your issues is how you ensure that GSN_ID remains unique throughout the table. - a update/insert...

see this https://stackoverflow.com/questions/761121/performance-issue-comparing-to-string-format for a small compare rewrite - very specific but it kind of addresses performance.

and then https://hashnode.robinrottier.com/net-6-string-format-performance and https://devblogs.microsoft.com/dotnet/string-interpolation-in-c-10-and-net-6/

main issue with "format" is that it has soo much...

another question is why are you converting to NVARCHAR - is your software now going to be used by users that require data that does not fit  on a VARCHAR?...

had you google it you would have found it - its amazing the type of information you get if you search for it instead of waiting for someone to give...

it will execute fine without restarting the instance. and effect is immediate e.g. memory setting will apply immediately (unless the first one is a reduction of memory on which case...

for majority of uses within SQL Server itself you don't need the numerics formatted that way so as mentioned before the formatting should be done on the receiving UI -...

I don't know how you created your text file - but you missed the point. you need to MANUALLY go through each sp, through the object explorer, generate their script...

multiple ways - most commons are

• have a table on SQL server where you store the name of the zip files you already processed
• only process files with a create/modified...

• This reply was modified 3 years, 3 months ago by frederico_fonseca.

now go through each one of those sp's and see if any of them is populating the table - I should not have to tell you this!!

new link

https://docs.informatica.com/integration-cloud/cloud-mass-ingestion/current-version/mass-ingestion-databases/mass-ingestion-databases/mass-ingestion-databases-sources---preparation-and-usage/microsoft-sql-server-and-azure-sql-database-sources.html

and have you bothered going to the manuals and search for the tables I mentioned?

as you mentioned there is a proc that already reads the table in question, if that...

try to enable cdc on database manually before kicking the process.

please don't create new threads to continue your questions - keep this on the same original thread.

I will advise you to read the sql server manuals for the system functions...