View Complete Post
Erlier I posted a questions Which I got Answer form Alberto Morillo & Siva...
in fact my question suppose to be "SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment"
Please some body guide rollBack process for given Rollout.
Pre-SQL Server SP3 Installation Steps.
1. Prior to Installing the SP3,Take the Full Backup of All Database (System Databases, User Databases), Databases backup is required for roll back process, If installation causes any Database Damages
2. Disconnect the all Application connects.
3. Announce the Down time for 60 minutes
SQL Server SP3 Installation Rollout Steps.
1. Log into the server as an account that has privileges to install the service pack. On a failover
Cluster, this must be the cluster service account or a domain account that has ad-ministra
I want to roll back SP3 on 2005 server which i have applied on a test machine recently. So i have overwritten the old resource database files that i have taken the backup before
the installation of SP3.
Now the resource database build version is showing as 9.00.3042 in the errorlogs but the
i would like to ask what the difference between sql server 2000 and 2005
I am using google transliteration to display the text in Hindi/Tamiletc.I tried to store the text appear as Hindi from textarea in an nvarcharfield of database (SQL Server 2005) , the text saved as "???????".After retireving text from the same it display the text as "???????".Can anyone help me how to store and retrieve the actual data from SQLServer 2005?I am using ASP.net,VB.Net and SQL Server 2005
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks
Hi All,i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!
Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?
How do i handle the process? i thing, i see the forest based on all the trees not more...
Can anyone help me? how to do?
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
MSDN Magazine February 2007
Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.
MSDN Magazine October 2006
The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.
MSDN Magazine August 2006
Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
MSDN Magazine July 2006
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.
MSDN Magazine May 2006
SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.
MSDN Magazine September 2005
Get a peek at the new security features in SQL Server 2005 from a developer's point of view. While there are lots of admin enhancements, there are also plenty of dev-specific security improvements you can take advantage of, such as endpoint authentication and support for the security context of managed code that executes on the server. Here Don Kiely elucidates.
MSDN Magazine June 2005
By now, you're certainly collecting a variety of data from your Web site. But once you collect it, what do you do with it. For it to be meaningful, this data must be categorized and analyzed. The SQL Server 2005 data mining functionalities can help you get the most out of those reams of data you collect, as Peter Pyungchul Kim explains.
Peter Pyungchul Kim