Viewing 15 posts - 1,606 through 1,620 (of 1,932 total)
tom.wauters (4/2/2012)
First of all, your databases will be in the newer environment, which has lots of improvements compared to SQL Server...
April 2, 2012 at 10:39 am
SQLRNNR (3/30/2012)
Rod at work (3/30/2012)
March 30, 2012 at 10:30 am
Jason, when you said:
This is behavior that I have seen occasionally. It is fixed with 2008.
Did you mean SQL Server 2008 (or SQL Server 2008 R2), or did you mean...
March 30, 2012 at 10:28 am
Another question, which is related to this issue, concerns the different versions of SSRS. Our production database server is a SQL Server 2005 Standard Edition. We've got, on...
March 30, 2012 at 9:18 am
tom.wauters (3/30/2012)
My first thoughts for your problem:
1. Make sure that the person who develops the report in SSRS is connecting with the...
March 30, 2012 at 9:15 am
SQLRNNR (3/29/2012)
We have multiple schemas and use ssrs to access procs in those different schemas.If you log on as the particular user, can you see the proc in question?
I just...
March 30, 2012 at 8:40 am
Gail and Lynn, thank you both very much for your help. Using your advise I've come up with a couple of simpler maintenance plans (no shrinking of any databases),...
March 28, 2012 at 9:58 am
anthony.green (3/28/2012)
In terms of what Owner SSRS runs under what do you mean? It runs under what ever account you have specified in the data source to connect to...
March 28, 2012 at 8:08 am
GilaMonster (3/27/2012)
Re log backups...
March 27, 2012 at 2:59 pm
Lynn Pettis (3/27/2012)
Here is a link that covers what I was talking about regarding the master database: http://msdn.microsoft.com/en-us/library/ms191488.aspx.
Thank you, Lynn, I'm reading it now.
March 27, 2012 at 2:57 pm
Gail,
For me, this has been a great day of learning. I didn't know that MSDB stored jobs, job history, etc. Cool, thank you!
Concerning what our business needs are,...
March 27, 2012 at 2:23 pm
Gail, I didn't realize that it may not be necessary to backup the transaction logs of system databases. WOW, interesting. OK, I'll remove that.
As you suggest, our database...
March 27, 2012 at 1:09 pm
Good question, Lynn. I was't sure how the previous student DBA had set the recovery model for the system databases, so I just checked. He set it up...
March 27, 2012 at 12:56 pm
Gail, what you said makes sense. When I was setting up a backup scheme on our test database server, I asked on these forums about how to do it....
March 27, 2012 at 11:40 am
I believe I may have been rude with the initial post of this thread. If in fact you found my initial post to be rude, then I am truly...
March 27, 2012 at 10:47 am
Viewing 15 posts - 1,606 through 1,620 (of 1,932 total)