Viewing 15 posts - 406 through 420 (of 2,496 total)
The first option is to try doing more frequent log backups. If this does not keep the log size under control then you have to accept that a larger...
July 14, 2014 at 3:46 am
I think that when you use an Access FE with a SQL Server BE, then Access will use 'pass-through' queries to get the data. The entire query text is...
July 14, 2014 at 3:40 am
I know that Microsoft made some improvements to the patching process in SQK 2008, but this is so long ago I cannot remember the exact details.
It is always worth taking...
July 14, 2014 at 3:18 am
So what is important to your organisation - beating the completion or complying with process?
It sounds like you have a lot of managers who do not understand what is needed...
July 7, 2014 at 5:15 am
This link shows how to create a loopback linked server http://www.kodyaz.com/sql-server-2012/create-local-linked-server-in-sql-server.aspx
July 1, 2014 at 6:57 am
Thanks Perry, I stand corrected and have learned something new.
June 30, 2014 at 5:24 am
As Paul and Grant say, check what you actually downloaded. You are being asked to install Windows 2008 Sp2, not SQL 2008 SP2.
Service Pack 2 for Windows 2008 is...
June 30, 2014 at 4:06 am
How about SSIS 2012, where everything in the project deployment model is stored inside the SSISDB database? Can SSIS be clustered in that case?
If you are certain that there will...
June 30, 2014 at 3:58 am
If you can be certain that you will only ever have one SQL instance on your Windows cluster then it can be safe to cluster SSIS in the way referred...
June 30, 2014 at 3:44 am
If you switch to Simple recovery mode then you break the log chain. The only way forward for your log shipping is to switch back to Full and send...
June 30, 2014 at 3:28 am
You should not restore system databases across different versions of SQL Server.
Each version of SQL Server has version-specific information in master, resource, and msdb. If you do...
June 30, 2014 at 3:22 am
As you say, you can not install SQL 2012 or above on Windows 2003. You need Windows 2008 or above to install these versions of SQL Server.
I have some...
June 30, 2014 at 3:18 am
It is also worth looking at SQL FineBuild. This helps you produce standardised and repeatable installations of SQL Server, which can aid in your documentation process.
June 30, 2014 at 2:55 am
I somehow think those spammers in some Eastern Europian country will laugh when they receive an invoice
A lot of the companies linked to in the spams had .co.uk addresses. ...
June 23, 2014 at 4:19 am
AFAIK you can apply standard CUs to SQL Express 2008 and above.
CUs are not possible on SQL2005 Express, but Security Update KB2716427 which provides the latest publicly available...
June 23, 2014 at 3:53 am
Viewing 15 posts - 406 through 420 (of 2,496 total)