you want to use Datetime for all values

here i am stripping out time to get the first day of the current week/Monday, and adding either one or two...

one of the know requirements when you upgrade is to update statistics for all tables, as the optimizer is different.
did you rebuild your indexes/update statistics yet, after upgrading to...

you want to store it with the line feeds in place already.

INSERT INTO YourTable ( ID, NickName,Category,Phrase)
SELECT 1,'excitedBirthday','Birthday',
'I bet you''re so excited
Excited...

its also possible with OpenXML and a script task, but the learning curve to learn to get that right is pretty steep.
once you have it though, you can decide...

stick with the SSIS wizard and avoid a linked server.
 the SELECT INTO FROM linkedServer... will be a massive logging operation, and you might run out of disk space due...

yes, i store queries like that in a table, and execute them all the time.
there are two simple ways, note i had to escape the single quotes within the...

grid view always compresses the data to a visible sinlge row, and makes CrLf appear as spaces.
what you want is to make sure a copy/paste from a grid still...

here is an example, splitting the list of all your tables in your current database, into five columns;

i think you can adapt that to only have four columns,...

the issues is object owner chaining.  cross schema or cross database queries break the object chaining inheritance, and require select permissions to teh underlying tables.
you don't want that, you...

if you have the enterprise version, Data Driven subscriptions are an option.
with data driven subscription, you might have a view that has all the info on a per row...

here's a  scripts i actually put into views ie (GoodMail and FailMail) by toggling the WHERE statement; very handy for at a glance status of emails.
so i can review...

I would assume that some other process is toggling all rows back to zero, and not that SQL is not updating after it explicitly said it updated/Completed.

this link describes numbered procedures fairly well; it is a little used capability that is now deprecated.

you can have different versions of the same procedure, or even completely...

i've been using a modified version of this script sp_help_revlogin_roles, which scripts logins and some server roles for you for an easier migration:

https://www.itprotoday.com/strategy/cloning-security-objects-between-servers

sp_send_dbmail is asynchronous. the whole process is already a service broker.
it returns success and an mail_od immediately without actually sending anything, and puts it in a queue.

the...