Viewing 15 posts - 121 through 135 (of 187 total)
Just to answer, yes that is what you need to do in order to migrate the packages from 2000 to 2005.
However, depending on the types of packages that you have,...
February 18, 2009 at 1:22 pm
The old box (the monster) I would definitely want to know what the RAID configuration is set to for the drives that the SQL Server resides on and exactly how...
February 18, 2009 at 12:30 pm
Data Driven Subscriptions are available in Developer and Enterprise, so I am sure that is your issue.
http://www.microsoft.com/sqlserver/2005/en/us/reporting-services-features.aspx
This is also true on 2008.
February 18, 2009 at 11:56 am
I would be curious if you looked at the statistics io if they are the same on both machines. They should be but my thinking is that perhaps the...
February 18, 2009 at 11:42 am
It seems to me that you need a higher level here. There should only be a single "Root". In this case you are trying to...
February 18, 2009 at 8:12 am
As said above, get rid of the cursor. It probably would also not hurt to look at indexing to see if you are 1. updating the clustering key hopefully...
February 18, 2009 at 7:20 am
To add a little to this, if you do want check for long running jobs and it is a scheduled job within the SQL Agent, you can use the xp_sqlagent_enum_jobs...
February 16, 2009 at 9:28 pm
Jonathan Kehayias (2/11/2009)
MANU (2/11/2009)
You will get it from sys.dm_db_partition_statsselect * from sys.dm_db_partition_stats
where object_id='Enter the ID here'
and Index_id='Enter the ID here'
MJ
Look at the output of...
February 11, 2009 at 3:17 pm
You can definitely do this and there are invariably dozens of different possible solutions I am guessing.
I would probably create a table structure populated with the tables that you think...
February 11, 2009 at 10:09 am
When I was first doing this a few weeks ago I was struggling finding it on BOL as well until I did a key word search on Latitude, which found...
February 10, 2009 at 1:33 pm
You would absolutely have to create a job step on Server A to make the call.
In terms of Server B as long as you have a Schedule set up with...
February 10, 2009 at 1:02 pm
You could create a linked server between Server A and Server B and then run the
EXEC [ServerB].msdb.dbo.sp_update_jobschedule
@job_name = 'JobName',
@name = 'ScheduleName',
@enabled = 1,
@active_start_date = YYYYMMDD,
@active_start_time...
February 10, 2009 at 12:36 pm
Jonathan Kehayias (2/10/2009)
February 10, 2009 at 9:23 am
Mirroring is a great option, but for many shops (like mine) the extra SAN/Disk space is FAR more costly than having an additional server.
Couple that with the fact that you...
February 10, 2009 at 8:50 am
You essentially are allowing SQL to take up 18.5 GB out of 20 total and SQL is obviously happy to do so. That is not necessarily bad, but...
February 10, 2009 at 8:46 am
Viewing 15 posts - 121 through 135 (of 187 total)