Viewing 15 posts - 466 through 480 (of 966 total)
If I set Kerberos now, will this cause any issues?
No, but there are a few things to note with Kerberos:
- If you have service accounts other than local system (and...
February 6, 2013 at 5:58 am
I know this thread is a little old, but I just came across it while troubleshooting a similar problem with SSRS 2008 R2. I could connect but would get an...
January 18, 2013 at 8:50 am
Just had a chance to look at this in an environment. Have you tried modifying the query in BIDS? That may be more effective.
January 18, 2013 at 7:37 am
January 17, 2013 at 1:28 pm
What do you mean by design view? Is this BIDS/Visual Studio, Report Builder, another application?
January 17, 2013 at 1:15 pm
i can't seem to get the calculations to work after countless attempts.
=Count(Fields!Pass_Fail.Value = "P") does not work...it simply counts all the rows instead of only the rows with "P"....
January 17, 2013 at 12:58 pm
use the local server group in SSMS and then use something like sp_readerrorlog to seach for what your looking for, not the most elegent, but just a thought I had
I...
January 17, 2013 at 12:52 pm
January 16, 2013 at 4:25 am
Curious if SQL had problems writing to the error log. Can you cycle the error log and try again?
EXEC sp_cycle_errorlog
January 16, 2013 at 4:11 am
What kind of credentials are used for the linked server, SQL or Windows? If it is windows I would check that Kerberos authentication is working because login errors with NT...
January 15, 2013 at 4:50 am
Before you go further down this rabbit hole, do you have backups of this database? It may be better to restore from full/logs before proceeding.
I hope those backups you removed...
January 15, 2013 at 3:05 am
But I still not understand why ?
In safety-mode, principal do not applied change on datafile until it's write in transaction log of the mirror.
So, if principal crashed, the transaction not...
January 14, 2013 at 1:22 pm
Edit the maintenance plan after the wizard creates it. You should have objects for each step the maintenance plan is doing and you can go and edit each one.
January 14, 2013 at 7:25 am
Just to clarify this is a SQL 2000 forum and it appears that your question is about SQL 2005, so it may not be seen by a lot of...
January 14, 2013 at 7:06 am
Check the file extension you set up for the maintenance cleanup task. It needs to be set as "bak" without the dot (.bak).
+1
Also, ensure that the "Include first level...
January 14, 2013 at 7:03 am
Viewing 15 posts - 466 through 480 (of 966 total)