Viewing 15 posts - 331 through 345 (of 966 total)
Not sure I would count DB Mirroring out just yet. I don't actually see it on the SQL Server 2014 deprecation list. Plus with AlwaysOn you are required to have...
April 25, 2014 at 8:13 am
Can i change the data type from ntext to nvarchar(max) and then will I be able to rebuild the index online?
If you are on SQL Server 2012 you should be...
April 23, 2014 at 8:03 am
Note that SQL Server logins do not map to AD groups. In option 1 you are still creating a Windows authenticated login, you are just associating it with an AD...
April 23, 2014 at 6:20 am
Don't think that will work. The instances involved in mirroring need to be able to tell each other apart. Plus if you use a monitoring server how would it tell...
April 23, 2014 at 6:14 am
Have you looked at your storage? Seems many symptoms are pointing there. Are you using a SAN? If so I would get with your SAN admins and have them tell...
April 23, 2014 at 5:13 am
Do you have another SQL instance available? You could setup mirroring between the two, create a database snapshot and have the report run from that. That way you won't be...
April 23, 2014 at 5:07 am
That's a good question. Not sure how much you will be able to do through SSMS.
You might be able to set and test it programmatically. If so you can...
April 23, 2014 at 4:59 am
I don't understand the issue with not being able to use a footer. It should not matter that your data is in a sub-report. If the signature data you need...
April 22, 2014 at 2:27 am
Well, __$operation = 1 is a deletion and __$operation = 3 is a value before an update. So I would image with a default value what you are seeing are...
April 21, 2014 at 4:15 pm
I second CDC. If you need a full history then CDC or a custom SQL audit (or several) is what you probably want. You wouldn't need to implement custom code...
April 21, 2014 at 2:41 pm
So you modified the column of the table to allow NULLs or you set the value of old records to be NULL for that column? The first just states that...
April 21, 2014 at 2:36 pm
Not sure I understand. You want to move subscriptions but you don't want to use the subscriptions? If you don't want to use the subscriptions why move them in the...
April 21, 2014 at 2:26 pm
Can we upgrade reporting services to 2012 without having upgrading our instance of sql server. Just need to know compatibility.
Yes.
Create a Report Server Database
Database Server Version Requirements
--------------------------------------------------------------------------------
SQL Server is used...
April 21, 2014 at 2:19 pm
Are you trying to install it from the command line or are you running setup.exe and choosing install from the installation center?
April 21, 2014 at 3:47 am
Is the node that you are trying to failover to listed as a possible owner for the cluster resources in cluster admin?
April 20, 2014 at 6:23 am
Viewing 15 posts - 331 through 345 (of 966 total)