Got a possible solution......

Try creating a stored procedure. Call it something like dbo.usp_addnewdb.

Make it a two step procedure.

1. the procedure runs sp_attach_db

2. the procedure then adds the role to...

They have to be added as a user somehow. How do you add them as a user now? Do you do it yourself?

They either need to be sysadmin, have...

I was just on Microsoft's web site for Reporting Services and you have to have a license for it. So, it's not free with the Enterprise Edition.

http://www.microsoft.com/sql/prodinfo/previousversions/rs/howtolicensers.mspx

-SQLBill

quote: We can locate it on the enterprise disk

Did you mean to say you 'can't' find it on the disk? I'm not sure that Reporting Services comes as...

Why don't you just check for the existance of the table and drop it if it already exists? That's how I do my scripts that create #temp and ##temp tables.

-SQLBill

quote: At the end, it say that files are copied and doesn’t ask to reboot.

Have you rebooted it anyways? I seem to recall that there is at least...

being a dbcreator should be good enough. But it isn't.

Yes it is. BOL doesn't say anything about dbcreater being able to use EM to attach/detach databases. It says dbcreater...

I would tell them to stop it and set their backpup to ignore/skip the .mdf/.ldf files.

Why? Because it's messing up your backups. If they are using a SQL Server agent,...

Did you really detach it? Or did you just accidentally delete the file?

Have you tried to stop and restart SQL Server (stopping and starting SQL Server rebuilds the TEMPDB...

You might want to look at the BOL for using the WITH STOPAT .

-SQLBill

This is also true of FULL backups and LOG backups. If you append them, rather than overwrite, you have to know the proper file number to restore. Otherwise, you restore...

Steve,

Ever follow a diesel bus or truck...see all that black smoke that comes from the exhaust? Plus, diesel engines have to be kept running longer, that's why 18-wheelers leave their...

What mark did you put in your transaction? STOPATMARK only works if you use marks in your transactions.

Refer to the BOL, use the index tab, enter 'marking transactions'.

-SQLBill

Look at the function fn_get_sql in the BOL. That will get you the full SQL that is run (unlike DBCC INPUTBUFFER which only gets the first 255 characters).

-SQLBill

To follow up on my post......I can submit a command that updates every single row in the table.

UPDATE mytable

SET mycolumn = 'new value'

Let's say that takes 15 minutes to complete....