Jwalin Khatri

Posts Tagged ‘SQL Server 2005

how to develop the DTS package in SQL Server 2005

Posted by: jwalin on: December 8, 2008

http://dotnet.sys-con.com/node/45541

Restore Database by SQL Scripting

Posted by: jwalin on: July 9, 2008

 
 
RESTORE

DATABASE [xxxxxxx] 
 

 
FROM DISK = N‘C:\backup\BackupDatabase.bak’ WITH FILE = 1,
 

 
MOVE N‘xxxxxxx_Data’ TO N‘C:\DATA\xxxxxxx_Data.MDF’,
 

 
MOVE N‘xxxxxxx_Log’ TO N‘C:\DATA\xxxxxxx_Log.LDF’,
 

 
NOUNLOAD, REPLACE, STATS =10GO

Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database
http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspx


Blog Stats

  • 15,774 hits

  • Bob: Doesn't work with IIS7 (default config on Windows 7 and 2008) because no ADSI anymore.
  • jwalin: Follow the following steps 1]. open you Page in NOTEPAD. 2]. find the tag 3]. Replace the "body" like body oncontextmenu=”return false;" 4]. Sav
  • cytocine: Halu , how to put that , i mean where to put the part ?? i really dont know i hope you can help me out thanks..