Viewing 15 posts - 1 through 15 (of 46 total)
That was an awesome article!
May 23, 2022 at 7:32 pm
This is a little quicker
SELECT OBJECT_SCHEMA_NAME( OBJECT_ID) AS [Schema], Name
FROM sys.All_OBJECTS AS AO
WHERE OBJECT_SCHEMA_NAME( OBJECT_ID) NOT IN ( 'sys', 'INFORMATION_SCHEMA' )
AND OBJECT_SCHEMA_NAME( OBJECT_ID) = 'dbo'
AND LEFT(name,3) NOT...
November 17, 2020 at 6:44 pm
That worked DATABASE needs to be DATABASE not master.
Doug
November 10, 2020 at 3:17 pm
What is the syntax to drop the trigger,
DROP TRIGGER trgBlockMasterUserObjects
Since the above does not work
Doug
November 10, 2020 at 2:26 pm
Thought your script on clustered GUIDs would want to ignore system objects - it dropped my positives from 10 to 1.
SELECT OBJECT_SCHEMA_NAME( IC.Object_ID ) + '.' +...
October 8, 2020 at 7:09 pm
Grant,
I see the link on each email.
I’m getting a bunch of emails from Jeff Moden. If I click on the link - I see his name with a link to...
May 8, 2019 at 3:06 pm
No not the authors Sue - I think I’m being pretty clear - there is no way to unfollow an author once you follow them. I’m getting 20-25 emails a...
May 8, 2019 at 12:10 am
That is not the case - there is only a ‘follow’ link.
Seems like they might be in violation of the ‘Canned Spam’ act - https://www.ftc.gov/tips-advice/business-center/guidance/can-spam-act-compliance-guide-business - I’m just...
May 7, 2019 at 11:43 pm
So the trick is to use your server's IP address, as well as the listening port.
So for me, sqlcmd -S 127.0.0.1,1434 -E ( where 1434 is the default listening...
February 13, 2019 at 6:40 am
October 8, 2018 at 5:52 am
1) Don't put SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in any...
October 5, 2018 at 1:25 pm
The better way to set this is via
UPDATE [msdb].[dbo].[sysjobsteps]
SET
Flags = 22,
Output_File_Name = 'D:\SQLAgentJobLog\AgentOutput.txt'
-- 15 checks Log to table box
-- 16...
September 13, 2018 at 8:33 am
How about this
DECLARE
@sqlTrexec NVARCHAR(MAX)='';
SELECT @sqlTrexec = @sqlTrexec + '
EXECUTE sp_refreshview N''' + QUOTENAME( SS.Name ) + '.' +...
June 5, 2018 at 11:35 am
I recall back in my engineering school days we always used 365.25 to account for leap year.
SQLOzzie
April 9, 2018 at 6:05 am
So here are my final scripts, since no one seems to ever post the 'final' result
SQL Agent Jobs where you are not configured to receive email
March 2, 2018 at 7:09 am
Viewing 15 posts - 1 through 15 (of 46 total)