ASP.NET SQL Server Registration Tool – Aspnet_regsql.exe

This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your

» Read more

Migrating Logins from One SQL Server to Another

As I need to migrate the databases from one server to another server. I have to deal with migrate not only the data, but the SQL Server logins that access that data as well. There may be different ways to migrate SQL Server logins like you can manually re-enter the entire existing login on the new server. You can use DTS to transfer logins. But here sharing one of other way of migration of SQL Server logins, by using the

» Read more

Access SQL Server Instance from the network

Whenever we create any SQL instance and after that if we want to access from our network. We need to setup some setting on Client Machine also! This is  only point that people missed Now we need to install the Client Network Utility on Client Machine and following setting needs to be done. Open Client Network Utility Go to “Alias” Tab Click on “Add…” Button Just type the Server alias (see eg. ABC-1111) “ABC-1” is server name and “111” instance

» Read more

SQL Backup Plan with Dynamic file Name

DECLARE @day VARCHAR(5) DECLARE @month VARCHAR(15) DECLARE @year VARCHAR(5) DECLARE @hour VARCHAR(5) DECLARE @filename VARCHAR(500) SET @day = DATENAME(DAY, GETDATE()) SET @month = DATENAME(MONTH, GETDATE()) SET @year = DATENAME(YEAR, GETDATE()) SET @hour = DATENAME(HOUR, GETDATE()) SET @filename = ‘D:DATABASE Backupdb_name_’ + @day + @month + @year + @hour + ‘.bak’ Backup DATABASE db_name TO Disk = @filename WITH format BACKUP log db_name TO disk = @filename WITH format

» Read more

Move SQL Server Databases Using Detach and Attach

–How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server –Prerequisites –Note You can determine the name and the current location of all files that a database uses by using the sp_helpfile stored procedure use go sp_helpfile go –Detach the database as follows: use master go sp_detach_db ‘mydb’ go –Next, copy the data files and the log files from the current location (D:Mssql7Data) to the new location (E:Sqldata). –Re-attach the database.

» Read more
1 6 7 8