Viewing 15 posts - 946 through 960 (of 2,496 total)
You can look at 'DBCC Page' to look at the contents. Google can show you how to do this.
My guess is that if the old file was the first...
January 11, 2011 at 4:05 am
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Dec 16 08:52:28 2010
This combination of startup parameters is used during the install...
January 10, 2011 at 4:17 am
If you are installing SQL Server 2008 then FineBuild can do the SQL cluster install for you.
If you are new to clustering, then you will face a steep learning curve....
January 4, 2011 at 5:50 am
The initial install of SQL Server 2005 will always put about 570 MB on the system drive.
Most of this goes into the Windows global assembly cache (GAC) which...
January 4, 2011 at 5:37 am
If your Access front end is using a server-side cursor to do the table refresh, then you do need to look at reducing the number of tables in the server...
December 14, 2010 at 3:02 am
Try to think about the real-world system you are modelling. Also think about where most of the queries will be coming from and optimise the database design for this...
December 13, 2010 at 5:01 am
This can be done, but you need to be very careful about when and why you do it.
The structure and contents of msdb can change with every service pack, cumulative...
December 13, 2010 at 4:48 am
If you want to do a number of unattended installs of SQL 2005 Express, it may be worth looking at FineBuild. Version 2.1.0 supports SQL 2005 Express installs on...
December 13, 2010 at 4:33 am
The warning is because SQL Server 2005 does not recognize W2K8.
The situation is the other way round. W2008 is throwing this message out because SQL 2005 RTM is known...
December 8, 2010 at 3:21 am
Even if you can upgrade from a CTP to the RTM version, I would not do this on a production box.
Our experience is that CTP versions create objects on the...
December 6, 2010 at 8:25 am
The stored procedure 'encryption' process is just obfuscation. It uses a standard algorithm and is relatively easy to reverse. If you Google 'sql server stored procedure decrypt' the...
December 6, 2010 at 6:41 am
You need to find the SQL Server installation log and look for the error message associated with your problem.
There are very many possible causes, so without you saying what the...
November 1, 2010 at 4:22 am
Do you have a BUILTIN/ADMINISTRATORS login? If so, then you are able to login using the local admin group.
You can safely remove the BUILTIN/ADMINISTRATORS login provided that you are...
October 26, 2010 at 6:36 am
We successfully use Full-Text under SQL Server 2005 and SQL Server 2008 R2 with Named Pipes disabled
Interesting. Maybe the Microsoft documentation is wrong. See http://msdn.microsoft.com/en-us/library/ms345189.aspx for the...
September 27, 2010 at 3:21 am
Viewing 15 posts - 946 through 960 (of 2,496 total)