Yes, there are default permissions (to public) on objects in master and msdb. For example, any user (public) can execute sp_password or any user can select * from sysfiles...

To grab the latest backup file? Assuming you know what the backup file filename is. You'd either need to know the filename or have some scheme to get...

Yea, the cards can also leverage your storage costs - but using storage costs to justify anything is just silly anymore

Space is really all you'll save....

If a DTS package suits your purpose (or maybe it does and you don't know it yet ) - transformations from a SQL Server can use sp's....

HaHAHaa. It looked like everyone's guesses are spread evenly across the answers.

It should be an analysis server category of question if there is a such category. Definately not...

Yea, I figured the underlying MS supplied function isn't handling the nulls properly. This one caught me off guard- Where are the emaill addresses? Some outputs I'd written...

As far as I know there is no way to automate or script the task to create the fmt files. If you're familiar with FMT files, .. er,...

Uh, how about a dynamic stored procedure. Like this:

Declare @tablename sysname

declare @tablecount int

declare @strsql varchar(8000)

set @tablename = 'authors'

select @strsql = 'create procedure #temptest (@variable int = null OUTPUT) as...

Look up CREATE TABLE in BOL (and read under TEMPORARY TABLES) for the full explanation. I cut this excerpt out:

A local temporary table created in a stored procedure is...

In the stored procedure write:

declare @tablecount int

select @tablecount = count(*) from authors

quote:

---

Not much to go on. If you can reproduce it, I'd call MS support about it.

Andy

http://www.sqlservercentral.com/columnists/awarren/

---

September 3, 2003 at 10:03 am