Viewing 8 posts - 241 through 248 (of 248 total)
asamykin - Tuesday, December 18, 2018 9:52 AMDespite it's not an official way, it saved us efforts, time and money.
forgot to mention:...
December 19, 2018 at 7:39 am
Another option to do in-place downgrade without any new instances is to use registry keys
http://sqlserverstore.blogspot.com/2013/12/how-to-downgrade-sql-server-2008-r2.html
We used this approach 4 years ago to downgrade about 20 servers...
December 18, 2018 at 9:52 am
thanks for idea, Andy!
I have the almost same task to set Transactional replication non continuous.
It turned out that logread.exe doesn't require Ctrl+C command at least in SQL2008R2.
So, I've just removed...
November 19, 2015 at 5:42 am
Rudy, hi!
Regarding this portion of script :
-------------------------------------
--> SQL Server Settings <--
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
SELECT
[name]
,[description]
,[value]...
October 1, 2014 at 11:39 am
How many free bytes are available for storing data on a SQL S 2000 PAGE?
8192 or 8069?
Karin 😉
8039 😉
http://www.sqlservercentral.com/articles/Miscellaneous/pagesize/497/
April 19, 2010 at 7:54 am
why not
((totalextents-usedextents)*64)/1024)
instead of
((totalextents*64)/1024)-((usedextents*64)/1024)
?
February 8, 2008 at 3:58 am
February 8, 2008 at 3:48 am
You should use stored procedure xp_cmdshell
books online : infocenter.sybase.com
December 28, 2007 at 3:03 am
Viewing 8 posts - 241 through 248 (of 248 total)