You can give create permission, but drop goes to teh table owner. I'd give them create under their user name, so they'd create tables as

bill.mytable

You can use sp_changeobject_owner to move...

Not that I know of. Lumigent's Log Explorer, Log PI, Apex SQL, all have tools to read the log. I built one awhile ago, but it had flaws.

Big hammer held...

It should be related to backup and recovery. Lost tape, backup failed, not checked, restore didn't work becaues of paths, server blew up, had to cobble one from desktops, ...

temporary tables, assuming this isn't a ##mytable and it a #mytable, are unique to each person. Even if you create the same name, SQL server will change the name internally...

I agree that text would be better. If you want to try and save space, you could set the text_in_row for this table to 1000 or 1500 and get all...

There might be something with terminal services. The client tools aren't necessarily designed for this work. I've had some issues with this before, but I tend to run terminal services...

Need 1433, TCP open. 1434 UDP if looking for instances.

I haven't done this, but in my understanding, you can install in English and add the database, table, or even just the columns that you need to support a particular...

How is it inserting them? It appears that something is trying to show a dialog box.

I have separate databases, but there is no reason you cannot have them in one. SQL Server supports multiple schemas. The terminology here is "owner" instead of "schema". You can...

There are some times when EM is performing some actions, like reindex, etc. where it will  freeze until the action is complete. I've seen this happen when connecting to a...

Yes you can. These are completely recorded in the log. Bulk changes are only recorded at a gross level, the page level I think, so you can't recover to an...

Curious why you htink 2048 is more manageable?

To do this, if you have free space, you can execute a dbcc shrinkfile to lower the size of the existing databases. I'd...

I agree with Bill. Shrink after reindex.

http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp

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

http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp