Viewing 15 posts - 2,956 through 2,970 (of 3,061 total)
vundisrinivas (8/28/2008)
What are the steps we should take to increase the capacity and performace of the report server.
1- Capacity planning
2- Capacity monitoring
3- Figure it out if more resources are needed
4-...
September 9, 2008 at 4:41 am
:w00t: OMG!
Don't you see all this exchange can be traced down to a basic design concept which is the good-and-old production-environment/archiving-environment?
Even cavemen where able to do it after applying SP2...
September 9, 2008 at 4:20 am
How about looking at the fine Microsoft documentation?
Try this... http://msdn.microsoft.com/en-us/library/aa337285.aspx
September 9, 2008 at 4:15 am
I think sysjobsteps table in msdb database describes each job step in your environment, I would start there.
September 8, 2008 at 6:45 am
DBA (9/6/2008)
My question is , is this considered data warehousing?
No, it is not.
September 8, 2008 at 5:23 am
1- :w00t: I would never, ever put a custom storedproc in the Master database, that's very bad mojo.
2- Something is wrong with your setup. I would start from scratch setting...
September 8, 2008 at 5:20 am
"rpc" option does not affects remote query execution, only affects remote procedure execution.
September 8, 2008 at 5:08 am
"rpc" option only takes effect after restarting SQL Server services, are you sure server got recycled after rpc option was set?
How did you added the server? was it by using...
September 8, 2008 at 4:07 am
sbk.net (9/8/2008)
i want to create the two database.In one database its only for the old information and another is current information.But i need...
September 8, 2008 at 2:18 am
Just use SSMA, Micro$oft has invested tons of talent and money in developing the tool, why you wouldn't use it? 😉
September 7, 2008 at 3:50 am
Look at the history of the Job...
Check if the step is actually there and in the affirmative case if it runs or not.
If step is not there you have...
August 29, 2008 at 9:57 am
:w00t: This syntax has been deprecated!!!
August 29, 2008 at 9:54 am
Maintenance Plan should generate a Job, Job is executed by SQL Server Agent.
SQL Server Agent service must be up.
Check Job looking for the step that should run the Maintenance Clean...
August 29, 2008 at 9:51 am
Look at the properties of your plan, everything is in there.
Are you sure you specified the right path and extension for the files you want to purge?
...how about the scheduling?
...how...
August 29, 2008 at 9:38 am
Loner (8/29/2008)
When I pointed out her mistakes, her boss complained to my boss that I was a difficult person to work with!!!!! Oh well!!!!
Did you rat her out?
Let me...
August 29, 2008 at 9:35 am
Viewing 15 posts - 2,956 through 2,970 (of 3,061 total)