Viewing 15 posts - 136 through 150 (of 966 total)
If I were you I would set this up in a lab so you can get your procedures down and practice this before trying it on a live system.
May 31, 2016 at 1:52 pm
If they are SQL logins Microsoft has a support article that has you covered.
How to transfer logins and passwords between instances of SQL Server
May 28, 2016 at 5:08 am
You can also take a look at Change Data Capture. It can also provide you a complete change history on tables you identify. Like triggers it will be a change...
May 26, 2016 at 6:06 pm
Interesting. Not the problem I would have expected you to have moving from 32-bit to 64-bit. Since this is a job working with Excel files my first thought is the...
May 26, 2016 at 5:55 pm
I would take a look here first:
How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)
https://msdn.microsoft.com/en-us/library/ms191545(v=sql.90).aspx
How to: Remove a SQL Server 2005 Failover Clustered Instance (Setup)
https://msdn.microsoft.com/en-us/library/ms190438(v=sql.90).aspx
(Hopefully...
May 26, 2016 at 5:46 pm
What is your error message?
Have you checked the following?
https://msdn.microsoft.com/en-us/library/aa337540.aspx?f=255&MSPPError=-2147217396
May 22, 2016 at 3:42 pm
Check this out. If you have the default trace enabled and the file from when the trace was created is still available you might be able to find out what...
May 19, 2016 at 3:29 am
Try wrapping the powershell script in a batch file and calling that instead. In the batch file redirect output to a file and review the file after the script was...
May 19, 2016 at 12:05 am
Are there any failures in the job history? If so can you copy/paste some of the errors?
May 18, 2016 at 4:03 pm
I never really used data models, so I cannot speak to them much. However it looks like they are still available with Report Builder 3.0 and referred to as report...
May 18, 2016 at 1:40 am
When you say "AlwaysOn HA" I am assuming you are meaning an availability group, correct? Both FCIs and AGs can provide HA. If you are using an AG, you can...
May 18, 2016 at 1:36 am
With AlwaysOn (FCIs and AGs) all nodes must be a part of the same WSFC. You can have an AG with multiple FCIs in different locations, but they still have...
May 17, 2016 at 4:03 pm
You can also use this to get running trace info:
select * from sys.fn_trace_getinfo (0);
May 17, 2016 at 3:58 pm
I think you would have to get it through the Report Manager interface of an installed, running older version of SSRS.
Just curious, why can't you use Report Builder 3.0?
May 17, 2016 at 3:54 pm
Viewing 15 posts - 136 through 150 (of 966 total)