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.
Joie Andrew
"Since 1982"
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
https://support.microsoft.com/en-us/kb/246133
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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?
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
May 17, 2016 at 4:03 pm
You can also use this to get running trace info:
select * from sys.fn_trace_getinfo (0);
Joie Andrew
"Since 1982"
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?
Joie Andrew
"Since 1982"
May 17, 2016 at 3:54 pm
Viewing 15 posts - 136 through 150 (of 966 total)