Here is an article posted on this site today that explains how to do this for a "wrapper" around sp_send_dbmail:

http://www.sqlservercentral.com/articles/Security/68873/#

This is another article, this one wrapping CREATE LOGIN:

http://blogs.msdn.com/lcris/archive/2005/06/15/sql-server-2005-procedure-signing-demo.aspx

Yes, you need to use dynamic SQL to do this. Which means that whoever causes the stored procedure to execute needs the appropriate permissions to create logins, modify database users,...

According to BOL, the CREATE USER statement is "Requires ALTER ANY USER permission on the database." This will be in addition to having EXECUTE permission on your stored procedure in...

Check out this other topic: Reverse Engineer Huge Database (Table...

at http://www.sqlservercentral.com/Forums/Topic773121-146-1.aspx

They have much the same problems as you. Several tools were discussed, such as Embarcadero's ER/Studio, that will try to...

I suggest that you write your code in modules and in a way that it can be run later to add new servers and/or databases as they are added to...

There are plenty of open source projects out there. Look for something that interests you, then volunteer to help out on the small stuff, including documentation. At first, you probably...

In fact, the SHRINKFILE is so safely coded, you may have to do another log backup and shrinkfile before you actually see the full shrinkage. This is because, unlike the...

A quick SQL Server 2005 script to list tables with APPROXIMATE row counts:

-- List Tables with Row Counts

-- WARNING: Row counts are APPROXIMATE values!!!

--This uses sysindexes for efficiency, which...

If you're using ER/Studio, you can do (and should) do sub-models fairly easily. Some things you may not have found yet.

1) Make sure the Overview window is open: View ->...

In the middle ages, the first gothic cathedrals were relatively simple stone structures, possibly with a couple of wooden doors at the entrances. The chief mason was the person responsible...

This is covered in SQL Server 2005 Books Online (September 2007) under "Moving System Databases" at

http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

There is an old TechNote out there for SQL 7.0 and 2000 that says it...

I see VARCHAR(MAX) mainly for stored procedure/function parameters and local variables, not for database fields.

It is possible that a future SQL Server would allow page sizes greater than 8KB. This...

I've noticed that if you DBCC REINDEX a large, heavily indexed database in full recovery mode, the transaction log backup can be larger than a full backup. This is because...

"Minimally logged operations" such as BULK INSERT, BCP.EXE and CREATE INDEX operate as fully logged operations in Full Recovery Mode, but are minimally logged in Simple and Bulk-Logged Recovery Mode....

The original databases must either be detached, read-only, or shutdown the SQL Server service before copying. Database activity occurs in the buffer pool and gets copied back to the data files on...