Viewing 15 posts - 1,441 through 1,455 (of 2,497 total)
You can access your Filestream data via T-SQL. However, you can also read your Filestream data directly via a C# (etc) program, without any need to pass the data...
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
March 9, 2009 at 10:25 am
You can use DTS in both SQL Server 2005 and 2008. You need to install the 'DTS Designer' component from the SQL Server Feature Pack.
On SQL Server...
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
March 9, 2009 at 10:22 am
I assume you do have enough space in other file in the filegroup to hold the last bit of data? Otherwise all I can suggest is Googling this problem...
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
March 4, 2009 at 2:58 am
When I was developing on DB2 m/f all I used was BEGIN TRANSACTION and END TRANSACTION...
...I sometimes used to add some SQL in the middle...
and I just remembered that DB2...
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
March 3, 2009 at 10:14 am
Does DB2 mainframe v7 support the MERGE statement? I don't know when this sttement got to the various DB2 versions. If it is supported then it would be...
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
March 3, 2009 at 9:07 am
I am not sure what bit of the SHRINKFILE processing causes it to fail after the EMPTYFILE keyword is used, but fail it does. Even if you issue a...
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
March 3, 2009 at 5:17 am
Have a look at the services running on the box. If Notification Services is not there then it is not installed.
Be aware that Notification Services is deprecated 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
March 3, 2009 at 3:25 am
I would recommend going to 64-bit SQL Server 2008 running on Windows 2008. This will give you a platform that will remain current technology for a few years to...
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
March 3, 2009 at 3:23 am
I hope you get this to work - you seem to be getting through most of the problems.
Oracle does indeed deal with NULL values differently to SQL Server and DB2....
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
March 3, 2009 at 3:20 am
The SQL Server FineBuild Reference manual has a good description on how SQL proxy accounts are used, how to create them, what security is needed, and best practices for 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
March 3, 2009 at 3:12 am
In my experience, once you have used the EMPTYFILE keyword on a shrink, you must do a OS close and open on the file before you can drop it.
Stopping and...
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
March 3, 2009 at 3:02 am
SQL Server 2005 SSRS needs IIS on the box before it will install. All other components will install without IIS being on the box.
SQL Server 2008 SSRS 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
March 3, 2009 at 2:53 am
Gift, you are right. On re-reading the thread I see the OP problem has nothing to do with the .Net level.
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
February 26, 2009 at 8:04 am
You can get some multi-layer insulation that may do what you need. It is similar in concept to what NASA use to insulate spaceships. There are a lot...
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
February 26, 2009 at 5:30 am
SQL Server needs components that are at the .Net 2 level and will not use the equivalent .Net 3 components.
Do not be surprised if you have problems installing .Net 2...
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
February 26, 2009 at 5:21 am
Viewing 15 posts - 1,441 through 1,455 (of 2,497 total)