When I create a new database in SSMS either using the creation wizard or the
CREATE DATABASE command the database will contain a stored procedure called Searchinall. This procedure has never been added to new databases previously, but since 2 days it will be created in every new database, no matter how I create it. I have tried creating a database from a different Computer on this server as well, but the stored procedure will still appear.
When I tried looking online for a procedure Searchinall I could not find any results, so I suspect it is not a new feature and nothing that should be created by default.
Could someone have maybe accidentally added it as a default stored procedure to be created in every new database on the server? If so, how can I disable it?
modeldatabase. All newly created Sql Server databases use the MODEL database as a template and any objects (tables, views, stored procedures, etc.) that exists in
modelbe will a part of any new database created on that SQL Server instance.