I just noticed that User Defined Table Types do not show up in sys.objects by  the name you have given them, you have to look at sys.all_objects and Name LIKE...

Along the same lines, what techniques do people use to inject commas into, say, @@ROWCOUNT vs the FORMAT statement - FORMAT( @@ROWCOUNT ), '###,###,###,##0' ) AS RowCount

I still find it...

That was an awesome article!

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...

That worked DATABASE needs to be DATABASE not master.

Doug

• This reply was modified 4 years, 1 month ago by  SQLOzzie.

What is the syntax to drop the trigger,

DROP TRIGGER trgBlockMasterUserObjects

Since the above does not work

Doug

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 ) + '.' +...

• This reply was modified 4 years, 2 months ago by  SQLOzzie.
• This reply was modified 2 years, 9 months ago by  SQLOzzie.

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...

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...

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...

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...

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...

How about this

DECLARE
 @sqlTrexec NVARCHAR(MAX)='';

SELECT @sqlTrexec = @sqlTrexec + '
EXECUTE sp_refreshview N''' + QUOTENAME( SS.Name ) + '.' +...