Viewing 15 posts - 676 through 690 (of 7,472 total)
I hope you are logging failed logins somehow. In the detail information it states the actual reason for the failure.
there must be more detailed information about the failure.
Maybe my article...
January 31, 2022 at 3:04 pm
You had better started a new forum post ! Whenever I see new answers to old Questions, I skip it
January 31, 2022 at 10:00 am
But isn't a semi colon required I the CTE is in a stored procedure?
the point is to end the previous statement with a semi colon
and showing examples of CTE's...
January 29, 2022 at 1:50 pm
you could implement a database ddl trigger handling on object creation for tables starting with those prefixes
( handle registration of create table + timestamp and drop table (+ timestamp...
January 26, 2022 at 8:12 am
I think RedGate has got some nice tools to handle that kind of operation
January 26, 2022 at 8:03 am
.....
Create another filegroup, and duplicate the table on the new file/filegroup. Use the SWITCH command to move the data from the old to the new table.
ALTER TABLE schema.OldTable SWITCH TO...
January 25, 2022 at 1:09 pm
too many ? There should only be a single one !
ref: https://blog.sqlauthority.com/2020/04/11/sql-server-multiple-log-files-to-your-databases-not-needed/
( I only temporarily used a second ldf file to be able to extend to a new disk and...
January 25, 2022 at 1:03 pm
Also keep in mind by default it will only report progress every 10 % !
Use Jeffrey's script to have the prognosis.
January 25, 2022 at 7:51 am
Here is a nice reference by Brent Ozar regarding RCSI: "Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide"
Have a look at the "Gotchas With Implementing...
January 19, 2022 at 11:41 am
How correct do you need your results to be ?
Check this great blog post by Paul White: "The Read Uncommitted Isolation Level"
January 17, 2022 at 3:01 pm
Asking around how colleagues handle it or web search for a minute, especially nowadays, chances are someone already 90% published of what you need.
Although I must admit: "what you automate,...
January 17, 2022 at 2:53 pm
Ask for "view definition" to be granted to you, so you can seed an objects composition.
GRANT view definition TO [user_or_role]
January 17, 2022 at 9:13 am
also keep in mind, the SQLServer service account needs to be granted usage of the given paths !
January 13, 2022 at 7:29 am
Did someone add the registry key settings to disable the old TLS and/or SSL protocols ? ( and not reboot the node at that time )
January 12, 2022 at 12:45 pm
That is not advisable as this will always start the job, even when it is disabled !
My point is: When a sysadmin or "sqlagent job manager" disables a job for...
January 10, 2022 at 7:20 am
Viewing 15 posts - 676 through 690 (of 7,472 total)