Is this for a development or production database?

A simple GRANT CREATE PROCEDURE TO JOEUSER is sufficient for the user to create and execute procedures under their own schema. Anything...

sp_MStablespace gets it's info from sysindexes, which is the same place sp_spaceused reads from. This data is statistical in nature & is subject to become incorrect. DBCC UPDATEUSAGE...

Do they receive errors when the attempt to create an object?

NO?...

Are you sure they're not creating them under their own schema? A member of db_owner has to...

Assuming the server where the backups were generated is still good, you can also:

select mf.physical_device_name, bs.*
from msdb.dbo.backupmediafamily as mf
  join msdb.dbo.backupset as bs
    on mf.media_set_id =...

What do the job history and dts logs say? If the job is owned by an integrated security account, it may be failing to authenticate against the domain. ...

Personally, I'd leave the files in place and only copy the files that haven't been copied before, but that's just me.

There are several ways to do this. What's easiest...

First, use -F2 -L3 so you get rows 2 & 3. -F1 is never, ever going to skip the first row.

Next, since you've specified line numbers, I'm...

dbcc showfilestats

Total and Used extents are displayed in number of 64kb pages, so (extents * 64 / 1024) will give approximate size in MB.

Here's a script I wrote to summarize...

Are you wanting to call this SP from within the package, saving the result or output as a global var?

If the SP uses an output variable to return the value,...

You're referring to the original dup key issue? Bulk insert isn't going to clear your table for you before you load it, so that part's left up to you....

DBCC INPUTBUFFER will give you a little more detail. I use something similar to this:

declare @handle binary(20), @spid int

select top 1 @spid = blocked
from master..sysprocesses a
where a.blocked != 0...

It could mean an I/O bottleneck, or it could mean that there are some very inefficient operations running against the database server. Usually it will be the latter. ...

The default data file type for bulk insert is "char". Try:

bulk insert pubs2..authors from 'c:\pubs-authors.bcp' with datafiletype = 'native'

Sure... Use CEILING() instead of ROUND().

-Lance