Viewing 15 posts - 16 through 30 (of 80 total)
Thanks for all the input!
Ellis, I've used the right click generate scripts method quite often. In this case I needed something automated.
Greg, the Transfer SQL Server Objects task in...
January 29, 2008 at 8:29 am
Thank you for doing the leg work on this!
December 12, 2007 at 12:37 pm
MDFs and LDFs are on separate RAID5 SAN drives. There are no other files on these drives. All servers have the same configuration and reside on the same SAN. Backups...
September 5, 2007 at 9:52 pm
Thanks for the advice.
September 5, 2007 at 2:39 pm
How is the text log file being created? If it's from the Advanced section of the job step, you could simply check "Log to table" as well. In your final...
August 28, 2007 at 11:53 pm
I think Rudy has some great ideas that deserve investigation. Most networks and most database systems have one thing in common... change. Just because everything was running smooth a year...
August 25, 2007 at 11:40 pm
When setting @sql2, append @criteria... set @sql2 = ']' + ', NextLevel = case ' + @criteria.
You also have Count in your insert statement. I think you want...
August 22, 2007 at 9:51 pm
I'm interested in seeing what others recommend, but I think there are several approaches. One approach is to give sysadmin rights at the server level and db_owner rights at the...
August 20, 2007 at 1:58 pm
There is a small script that you would need to run on the SQL 2000 server to allow a remote call from SQL 2005. Calling SQL 2005 from SQL 2000...
August 20, 2007 at 1:50 pm
One possible cause to the long running job is blocking. It may have been waiting for a resource for the majority of the time.
This could be extremely difficult to debug...
August 20, 2007 at 1:45 pm
If you set a maximum file size, eventually you will run out of space.... unless of course you are doing transaction log backups.
Check books online for "Backing Up and Restoring...
August 16, 2007 at 11:43 am
If you change it in Enterprise Manager I don't think it requires you to know the old password.
August 16, 2007 at 11:29 am
You guys are hilarious. I'm trying to *avoid* downtime.
Actually, I'm wondering if it has anything to do with the max server memory setting. ...
August 15, 2007 at 3:03 pm
Hmmm... it helps but it's not what I wanted to hear. And it is what I assumed... I was hoping that there was a silver bullet that I was thinking. ...
August 15, 2007 at 2:00 pm
Ok, I've made some progress on this so I figured I'd share. Setting max server memory does not put a cap on sql's memory usage as one might guess. It...
August 14, 2007 at 1:59 pm
Viewing 15 posts - 16 through 30 (of 80 total)