Viewing 15 posts - 1,966 through 1,980 (of 2,497 total)
After a silence of respect, a story about floors...
A few years back a big insurance company in France decided to build a new data center. For DR purposes they duplexed...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 11, 2007 at 3:43 am
You can get virtually the same functionality for DTS in SQL 2005 as in SQL 2000. I have done this and it works.
First, you must have the DTS Designer components installed.
Second,...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 11, 2007 at 3:26 am
I think I am getting close to why SAC does not display all services. It looks to be a permissions issue, but I have not yet completely identified the cause.
Recently...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 10, 2007 at 2:36 am
What type of proxy did you create? SQL 2005 has lots of different proxies and you need to create the right one. Also, you only need to create proxies...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 7, 2007 at 6:37 am
The install media for SQL Server 2005 is split into 2 - a Server folder and a Tools folder. If you do a server components install the tools will not...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 7, 2007 at 3:45 am
If you run SQL Server 2005 32-bit on a 32-bit OS, the same rules apply as for SQL Server 2000 32-bit for /3GB, /PAE in the OS and AWE in SQL. ...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 7, 2007 at 3:38 am
I have not played with importing DTS to SSIS, but I have used DTS Designer in SQL 2005. I think the two ways of doing this are mutually exclusive -...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 6, 2007 at 6:04 am
Use EM, right-click on the instance and select Properties. If you see Product Version 8.00.2187 (SP4) you know you have the Hotfix Rollup level 2187 applied on top of SP4. ...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 6, 2007 at 4:45 am
What fix level are you on? If you are using SQL 2000 SP4, get the latest Hotfix rollup. SP4 introduced a new bug that prevents SQL using more than half...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 5, 2007 at 2:19 pm
I have used 'full function' enterprise job schedulers in the past, such as IBM OPC/A and BMC CTRL-M. I have also seen Tivoli and CA job scheduling in action, but have...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 5, 2007 at 7:54 am
It is (relatively) easy enough to add extra steps to the end of each job that would interrogate some schedule information and start the next job in sequence, but it...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 5, 2007 at 5:45 am
What would be FAR better is for Agent to support dependencies between jobs, and job suites.
With dependencies, you could chain jobs together, so that job B automatically starts after job...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 5, 2007 at 5:28 am
The interface from the main SQL Server engine to Service Broker is T-SQL, so just run the relevant T_SQL statements in your .Net application. They can be either traditional dynamic SQL or...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 5, 2007 at 5:20 am
What type of proxy did you create? SQL 2005 has lots of different proxies and you need to create the right one. Also, you only need to create proxies if...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
September 5, 2007 at 4:10 am
If you want to restore your database to what it was like a few days ago, you will need a backup from that time to restore it to.
It does not...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 31, 2007 at 3:35 am
Viewing 15 posts - 1,966 through 1,980 (of 2,497 total)