Script out entire SQL Server

Is there a way to easily generate a script for an entire SQL Ser开发者_StackOverflow社区ver instance?

I need..

• all databases
• all users
• all server objects
• all sql jobs

pretty much everything. I need this find out where a given string e.g "xxxxxx" has been used.

---

How much of what you want to check isn't queryable via the system catalogs?

• Databases: select name from sys.databases
• Roles/Users: select name from sys.database_principals
• Server Objects: select name from sys.objects

etc

---

If you need to find database objects (e.g. tables, columns, triggers) by name - have a look at the FREE Red-Gate tool called SQL Search which does this - it searches your entire database for any kind of string(s).

It's a great must-have tool for any DBA or database developer - did I already mention it's absolutely FREE to use for any kind of use??