Viewing 15 posts - 1 through 15 (of 39 total)
Can you get to http://localhost/reports and see everything ok?
In report configuration manager (in all programs..sql server...configurations) put a local admin in the service account and restart the ssrs...
May 11, 2011 at 6:37 am
dant12 (8/5/2010)
August 5, 2010 at 5:57 pm
First, thanks for the comments on the blog Steve. Appreciate that 🙂
I've noticed this over time and always been curious how that works out and how the patterns seem...
October 5, 2009 at 10:30 am
Very nice! I would optimize some things in the coding for large installations with hundreds of backups going on every hour (logs etc..) though. Example would be to...
June 4, 2009 at 8:09 am
SQLFool also has a very well written one here http://sqlfool.com/2009/03/automated-index-defrag-script/
May 17, 2009 at 4:23 pm
Sorry to hear that. It's a very tough spot to be in. Stopping data services may get their attention for sure though. Kind of scary to say...
May 16, 2009 at 5:14 pm
Tim is correct in not to worry unless you are asking due to performance issues you may be experiening. I have 12 instances that stay at 100% memory usage...
May 16, 2009 at 8:07 am
call a OS command to "NET STOP MSSQLSERVER" or any named instance
But that's kind of a scary thing to put in a job. What are you trying to accomplish?
May 15, 2009 at 3:08 pm
You need quotes around the command you are sending to shell when there are spaces in the path
Declare @cmd varchar(1000)
select @cmd = '''C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec'' /f'' "S:\Microsoft SQL...
May 15, 2009 at 3:03 pm
A few of my favorites as a DBA doing file tasks that don't need to go all the way to SSIS
public static void WriteToFile(String content, String...
May 15, 2009 at 3:00 pm
Recent blogs spawned several discussions on this topic that may interest you
Adam Machanic follows up here then with
Recommend reading the comments closely. Several of...
May 15, 2009 at 2:08 pm
There may be nothing to troubleshoot. By the nature of SQL Server it will consume as much memory as you allow it to have. Once it does so,...
May 15, 2009 at 1:57 pm
without budget for software you can also script this type of task looking at the INFORMATION_SCHEMA views. You can also cross instances using linked servers. I'm guessing there...
May 15, 2009 at 1:18 pm
If I had to do this entire process I would
Step 1) bulk insert the text into a table with a primary key being a seed or unique value identitfying...
May 15, 2009 at 12:40 pm
Viewing 15 posts - 1 through 15 (of 39 total)