Viewing 15 posts - 106 through 120 (of 1,583 total)
@sql Galaxy - you should be able to change the script to easily monitor a single server
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 2, 2015 at 7:44 am
jonathan.hickford (2/2/2015)
I've seen a few different change tracking systems, some using the default trace, and others using DDL triggers/ What are your (and others) thoughts about...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 2, 2015 at 5:52 am
No problem, glad that helped
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2015 at 1:14 pm
That's because you are serving them the wrong link 😀
My guess is you are giving them the web service URL - something like:
http://<<SSRSServerName>>/ReportServer
But you should be using the Report Manager...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2015 at 12:40 pm
Did you enabled the TCP/IP protocol in the SQL Server Network configuration?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2015 at 11:28 am
No, there is no dependency on IIS for reporting services whatsoever
If you are hosting this link from a web application, then the web application will/should have its own application...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2015 at 11:23 am
@Siberian - I've got an article being published next week here on SSC that you can use to keep track of those events - I believe it comes out on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2015 at 11:09 am
Personally I would start over again and not used the backup and just go with snaphots (I say this ONLY because I've never had any luck with the restore); however...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2015 at 4:34 pm
I do not have much successful experience with restoring from the backup method. Actually i've never gotten it to work successfully!
But to take a stab at it, you'll...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 29, 2015 at 10:45 am
I'm pretty confident it" did not break anything, but your previous snapshot that you created (yesterday) might not have completed yet so it has some lingering actions that it's trying...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2015 at 11:52 am
adding the article should be quick, providing the immediate_sync and anonymous setting are set to 0 (using the script provided)
You can then start the snapshot agent at an appropriate time...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2015 at 6:14 am
steve.roberts 86619 (1/28/2015)
So I guess it is trying to generate a complete snapshot straight away? If I disable this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2015 at 5:40 am
steve.roberts 86619 (1/28/2015)
Hi,Tried to run it yesterday and it ran for five minutes - causing timeouts etc... before I killed it..
Sounds like the result of the query I just added...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2015 at 5:36 am
Also since you're using the GUI, on your distribution server what is the result of running the query below?SELECT publisher_id, publication_id,
publisher_db,
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2015 at 5:31 am
check your running processes by selecting from sysprocesses or run sp_who2, etc
To clarify, have you already run this and it is still going? or is this more of a curiosity...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 28, 2015 at 5:23 am
Viewing 15 posts - 106 through 120 (of 1,583 total)