Viewing 15 posts - 166 through 180 (of 2,893 total)
We bought CozyRoc at a previous job. It worked well. I later found another similar product for about 1/2 price, but don't remember the name.
January 21, 2022 at 5:17 pm
Run this for all DBs ?
exec sp_MSforeachdb 'use [?] select ''?'' as Database, * from sys.certificates'
January 10, 2022 at 10:06 pm
You can write a stored procedure to check the money limit, then set up SQL Mail and use sp_send_dbmail to generate the email based on the limit.
Then use a scheduled...
December 27, 2021 at 2:40 pm
Less important who does it, but all "stakeholders" should be aware of "what" , "when" , "why" ....
Generally DBA does it where I've worked.
December 22, 2021 at 4:53 pm
You can first insert into a TEMP Table to see the results, then insert from Temp table back into target table.
It's an extra step, but helps you test & verify...
December 20, 2021 at 3:40 pm
I sent them an email in regards to SQL Server connections
So you sent yourself an email? The website for this app is literally in your bio. By...
December 13, 2021 at 9:02 pm
Yes. Easy to test. Create a tiny test database and leave an open transaction during backup. Then restore it and look at the data.
"...If it's important for you to know,...
December 10, 2021 at 4:31 pm
The default is for certificates to expire in 1 year. It can be changed to a different value when creating the certificate.
I didn't realize that, and backups failed a year...
December 1, 2021 at 2:38 pm
What is the value of PDWEDT ?
November 30, 2021 at 3:26 pm
Ignore "code" and GROUP BY on Company ID# ?
November 29, 2021 at 6:32 pm
It's preferred to copy-paste schemas, code etc into your post instead of as an attachment. Many of us don't open attachments due to virus risks. Use the "Insert/Edit code sample"...
November 29, 2021 at 6:14 pm
Absolutely. I use some meaningful abbreviation of the table name.
"...And, meaningful alias names make a big difference...."
November 29, 2021 at 4:34 pm
"...It is my opinion that the first syntax is best avoided, as I think it is not absolutely clear what the target is..."
How is "update dbo.tablename" unclear ?
I think the...
November 29, 2021 at 2:42 pm
How big are the DBs ? Do you need to subset all the tables, or just a few big ones ? Do they have referential integrity to complicate subsetting ? ...
November 23, 2021 at 7:23 pm
Chant: "Mo-den ...Mo-den...Mo-den !!!"
November 22, 2021 at 3:12 pm
Viewing 15 posts - 166 through 180 (of 2,893 total)