Is it the database or the log that's growing?

You need to schedule backups for both of those regularly.

Don't give the users rights to do these tasks. By default, users have no rights to tables. If you do not use db_owner or sysadmin rights as a general rule,...

Please don't cross post. Post your question in only one forum.

You can profile at the statement level, which I think will catch statements inside stored procedures.

I'd go with Jeff's advice here. The other thing to consider is you need tempdb to be this large. Sizing tempdb depends on your application and you need to know...

Management studio doesn't create anything. It submits your code to the server, which compiles and executes it. The server process opens database files and holds them open while it's running....

You cannot move the transacitons from an LDF. That's a log file.

You'd need to do a log backup from production and apply that, but your full restore would need to...

If you want to try a new technology, Powershell can do this.

Do you want info inside SQL Server for something?

there are a few tools that can do this, however it's pretty simple to write this as mentioned above. Lots of scripts here on this site as well that can...

Output the SQLCMD stuff to the same file, appending the data from each. Then you can dig in and build a report.

Master really needs logins moved (and roles)

msdb needs jobs, maint plans, etc. moved. You might be able to script all this stuff out.

Model, what needs to be moved?

I'm not sure what the default time that the data is stored, but I bet that if the report only goes back 10 days, the data is gone. This isn't...

I believe the server security_admin can be given to fix this.

Or set up a job that can run under system context and run sp_change_users_login to sync things up. The logins...

You need a variable to do this.

select @cmd = 'update tableA set '

-- cursor start here

select @cmd = @cmd + @column_name + '= ''value'' where ' + @column_name + '...

There could be lots of reasons, but likely the application is not dealing with the time it takes for something to occur or the load of data being moved.

You haven't...