Viewing 15 posts - 27,706 through 27,720 (of 39,769 total)
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...
July 24, 2008 at 10:37 pm
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....
July 24, 2008 at 10:35 pm
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...
July 24, 2008 at 10:33 pm
If you want to try a new technology, Powershell can do this.
Do you want info inside SQL Server for something?
July 24, 2008 at 10:32 pm
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...
July 24, 2008 at 10:31 pm
Output the SQLCMD stuff to the same file, appending the data from each. Then you can dig in and build a report.
July 24, 2008 at 10:30 pm
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?
July 24, 2008 at 10:29 pm
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...
July 24, 2008 at 10:28 pm
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...
July 24, 2008 at 10:27 pm
You need a variable to do this.
select @cmd = 'update tableA set '
-- cursor start here
select @cmd = @cmd + @column_name + '= ''value'' where ' + @column_name + '...
July 24, 2008 at 10:25 pm
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...
July 24, 2008 at 10:22 pm
This isn't something you change with T-SQL, it would be done in the Configuration Manager in 2005 or the Server network Utility in 2000.
July 24, 2008 at 3:31 pm
select a.value, b.value
from tableA a
inner join tableA b
on a.id = b.parentid
July 24, 2008 at 3:30 pm
Queries against master have no impact on the server other than using resources to execute the query. There is not reason this should corrupt anything.
July 24, 2008 at 3:28 pm
If you get this with a local backup, you have IO subsystem issues.
July 24, 2008 at 3:26 pm
Viewing 15 posts - 27,706 through 27,720 (of 39,769 total)