Viewing 15 posts - 1 through 15 (of 1,654 total)
Another option would be using an database audit specification using the SCHEMA_OBJECT_ACCESS_GROUP
June 5, 2019 at 9:58 am
Sorry missed that in my first reply.
But after some more testing I think it must be related to your SSMS version. I cannot reproduce the issue with SSMS 2014. Also...
November 27, 2014 at 7:38 am
Why would you think this is a bug?
If anything, the restore sequences shown in SSMS 2008 is wrong, but then again connecting with SSMS 2008 to a SQL 2014...
November 27, 2014 at 3:42 am
Philip,
The rendering process in Report Server is the operations the report do to show the report content (paint report items, paint data, pagination,…) on the renderer selected (in this case...
October 29, 2013 at 2:19 am
Obviously, adding more memory results in a different, less efficient plan.
Could you try what happens if you simulate even more memory, like let's say 16Gb.
You can do this by using...
October 25, 2013 at 6:46 am
To answer your question in the subject header, it depends on your collation. Each collation contains some special varchar characters, but they vary.
What is the collation of your column?
October 15, 2013 at 4:58 am
You can only configure the synch settings for the AG, not per database.
Either synch both databases or create two AG's one having only one secondary and another AG having...
October 4, 2013 at 3:28 am
Are you using SCCM?
Could be the same issue as here http://social.msdn.microsoft.com/Forums/officeapps/en-US/4dee5138-4726-4c5b-a7e5-a79ab3a6286c/sql-passive-node-could-not-open-error-log-file ?
October 2, 2013 at 7:11 am
Just like the DB Engine, SSAS contains several DMV's you can query for this kind of data.
As a starter open a DMX Query window and run:
SELECT * FROM $System.DBSCHEMA_CATALOGS
SELECT *...
October 2, 2013 at 5:57 am
kishoremcp (10/2/2013)
I have an sql query in Excel Existing connections through which i am able to pull the data. I am giving the required date range manually in sql...
October 2, 2013 at 3:26 am
While keeping one witness for one production database instance makes sense to me, why on earth would I want one witness for multiple DB instances?
One reason could be licensing fees,...
October 1, 2013 at 7:35 am
We have a SP which is giving performance issues. As an example it has been executed 4 times and has an total elapsed time of 68961914. It is the costliest...
October 1, 2013 at 6:03 am
Or did I misunderstand you? You think that because it is pre-release it might change until the official release of SQL Server 2014? Then of course forget my remark above....
October 1, 2013 at 1:35 am
You can't do it directly from SSMS, but you can download the SQL 2005 report definitions from here:
http://blogs.msdn.com/b/managingsql/archive/2006/08/30/ssms-reports-3.aspx
You can then upload these to your own SSRS instance (a few changes...
October 1, 2013 at 1:21 am
Not sure about this question.
I think there is no correct answer given, because even the link provided for SQL 2014 says "Topic Status: Some information in this topic is...
October 1, 2013 at 1:06 am
Viewing 15 posts - 1 through 15 (of 1,654 total)