Viewing 15 posts - 1 through 15 (of 463 total)
You could check msdb.dbo.sysmail_allitems to see if an email was generated, and if it failed or not.
August 18, 2011 at 2:55 pm
Look at the second link in http://weblogs.sqlteam.com/joew/archive/2009/02/17/60844.aspx. The BI components are covered specifically on page 4.
July 14, 2011 at 7:32 am
Ideally SSRS would sit on a separate server, but this means an additional license is required - the cost factor may make the decision for you.
If you install on the...
July 13, 2011 at 11:24 am
Take a look at http://www.techtalkz.com/microsoft-sql-server/266255-sql-server-agent-wmi-event-alert.html which has some information.
July 13, 2011 at 10:51 am
Seems to me that most companies wanting to run Denali will probably be running Win7 or Vista, and those that are just fine on XP are probably going to be...
June 24, 2011 at 1:10 pm
Assuming that you are already locking down the server to only IDs that need access, that really leaves 3 methods of accessing the database:
1) machine admin stops the server, copies...
June 22, 2011 at 12:29 pm
Are you just adding the column or also adding it into the primary key?
June 20, 2011 at 2:42 pm
Could the query be running twice? The first time creates the stub, the second turns it into a compiled plan with usecount of 1.
June 20, 2011 at 1:26 pm
Sorry, I wasn't clear enough - run the first command from the mirror server, and the second command from the primary.
June 20, 2011 at 12:58 pm
The fact that you have 15000+ stubs implies that it is enabled; as Jerry mentioned, existing plans are not cleared
June 20, 2011 at 12:39 pm
If everything was working nicely up to the point of failover and the original database wasn't disturbed (it didnt need restoring etc) then when mirroring comes back online it should...
June 20, 2011 at 12:30 pm
Make sure your endpoints are set up for mirroring by certificate (I don't believe you have any choice about this if you are not on a domain) - I don't...
June 20, 2011 at 12:17 pm
The reports allow you to execute stored procs to generate the required data instead of defining queries. Instead of granting read permissions to every table used in the report(s)...
April 18, 2011 at 8:46 am
The method I used in this scenario was to use a stored credential against specified reports. That credential was granted exec permissions against only the procs used by those...
April 7, 2011 at 4:01 pm
If the endpoints are created correctly and you just want to initiate mirroring the databases, you can run the following on each database. SSMS validates the FQDN, but the...
February 23, 2011 at 3:57 pm