Hi All Think you have to install sql server server pack to all the SQL Server in a Server. and Attended installation takes much time and human interferance, here is a simple idea solution for it .Install SQL Server Latest Service Packs from Command Prompt. its the easiest method to implement. Before proceding please take […]
SQL Server Upgradation is done in 2 ways Attended Installation/Upgrade Un Attended Installation/Upgrade (Silent Installation) Attended Installation/Upgrade is a basic method of installation . in which we interact with the GUI Screens in SQL Server Un Attended Installation/Upgrade (Silent Installation) is which sql server is upgraded from the command Prompt.
In my old blog i wrote how to import data from xml files. In this blog i am going to import data from xml files using SSIS(SQL Server Integration Services) Step 1 Open SQL Server Bussiness intelligence studio and create a new SSIS Package Step 2 Click on new ssis package insert dataflow task as […]
Migrating the users is the main time consuming task basically this can be acheived the 3 ways 1) Generate the user scripts 2) sp_revlogin 3) Using SSIS to migrate the users Generate the user scripts this is the basic method to migrating the user and it is very simple to implement,to implement this when you […]
SQL Server 2005 Enterprise edition introduced audit feature from SQL Server 2005 and later on all versions of SQL Server(2008,2008 R2,2012).
Once the database mirroring is configured it is very important to monitor the performance of SQL Server and ldf size of the mirroring configured databases.network utilization of the Principle and Mirrored Server,you might get a question how many databases can be configured for log shipping, as per my experience 10 is the max value . […]
Once or a while many of the people really get confused with the edition of SQL Server,A very good example is as Below Answer is very simple run xp_msver in the SSMS .check the output below xp_msver gives the complete information about the SQL Server . Option 2 run this query SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), […]
SQL Server Database Log File has grows am over a period of time and now causing DISK space issue? Step 1- Check the Recovery mode of the database by using select name,recovery_model_desc from sys.databases STEP 1 – Get logical / physical name of your database log file use <[your dbname]> exec sp_helpfile —–gives the database […]
SQL Server Version List is as below SQL Server 2012 will available in Market After 23 March 2012 SQL Server 2012 Denali CTP(Community technology preview) 11.00.1103.9 CTP3 11.00.1440.19 CTP 11.00.1750.30 SQL Server 2008 R2 RTM 10.5.1600.1 SP1 10.50.2500.1 SQL Server 2008Katmai/Akadia RTM 10.0.1600.22 SP1 10.0.2531.00 SP2 10.0.4000.00 SP3 10.0.5500.00 SQL Server 2005Yukon RTM 9.0.1399 SP1 9.0.2047 […]