Viewing 15 posts - 1,441 through 1,455 (of 9,641 total)
Check out the Scripts library here on SSC. There are several scripts there that do this. You can do a search on security and then limit it to...
April 24, 2013 at 6:57 am
What is your connection to the SAN? Are you connecting using iSCSI, or fibre channel. I've seen iSCSI saturated very easily.
April 24, 2013 at 6:55 am
I would definitely look into the index because of the number lock escalation attempts. This means that SQL Server is having to take so many row or page locks...
April 24, 2013 at 6:51 am
Duplicate post. Please post answers in this post
April 24, 2013 at 6:43 am
As far as I am aware this is expected behavior and upgrading the app server to use the latest SQL Connectivity tools should solve the problem.
April 24, 2013 at 6:39 am
Here are a some links to scripts in the SSC scripts library that should at least get you started:
http://www.sqlservercentral.com/scripts/75191/
April 24, 2013 at 6:37 am
I have to ask. Why do you need to reduce the size of this file? If it is using 55GB and growing, eventually you will need the space...
April 24, 2013 at 6:31 am
Jason,
It's not like we all haven't been there before. Just glad you got the issue sorted out.
-Jack
April 24, 2013 at 6:21 am
Without seeing the code, it's hard to say what is really happening.
What are you doing to mitigate against the risk of SQL Injection in the dynamic SQL?
April 10, 2013 at 8:16 am
Okay. I'm not used to using the report viewer client and rdlc files. Do report executions from rdlc files get logged in the ReportServer Database? If so,...
April 9, 2013 at 1:32 pm
f you are running a slipstreamed install then you are going to get whatever SP's or CU's are included in the slipstream.
April 9, 2013 at 10:57 am
Glad you figured it out. Doesn't really seem to make sense that report builder would be case-sensitive when BIDS isn't :crazy:
April 9, 2013 at 9:52 am
charlesd (4/9/2013)
I found the error and was able to get the script to run on SQL Server 2008 R2. I needed to change every occurrence of 'path' to 'T.[path]'.Thanks!
Sorry...
April 9, 2013 at 9:31 am
arnipetursson (4/9/2013)
When you add the instance via the setup program, it will be the same SP as the existing instance.Reboot should not be required.
Can you point to documentation that says...
April 9, 2013 at 9:27 am
I believe that the users need to add the prod site to the trusted sites in IE.
April 9, 2013 at 9:25 am
Viewing 15 posts - 1,441 through 1,455 (of 9,641 total)