Click here to Skip to main content
15,888,351 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionProblem forming .msi file in Visual Studio 2005 Pin
Anujit14-Jul-09 1:20
Anujit14-Jul-09 1:20 
AnswerRe: Problem forming .msi file in Visual Studio 2005 Pin
Vimalsoft(Pty) Ltd14-Jul-09 2:00
professionalVimalsoft(Pty) Ltd14-Jul-09 2:00 
AnswerRe: Problem forming .msi file in Visual Studio 2005 Pin
Abhijit Jana14-Jul-09 2:25
professionalAbhijit Jana14-Jul-09 2:25 
Questionback up sql data programmetically Pin
billcodes14-Jul-09 0:44
billcodes14-Jul-09 0:44 
AnswerRe: back up sql data programmetically Pin
Manas Bhardwaj14-Jul-09 0:48
professionalManas Bhardwaj14-Jul-09 0:48 
AnswerRe: back up sql data programmetically Pin
r a m e s h14-Jul-09 0:51
r a m e s h14-Jul-09 0:51 
AnswerRe: back up sql data programmetically Pin
Sabari MD14-Jul-09 0:52
Sabari MD14-Jul-09 0:52 
AnswerRe: back up sql data programmetically Pin
Vimalsoft(Pty) Ltd14-Jul-09 2:28
professionalVimalsoft(Pty) Ltd14-Jul-09 2:28 
That is Simple
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- backup a database
ALTER PROCEDURE [dbo].[sp_BackupDatabase]

	@databasename varchar(32),
	@path varchar(256),
	@filename varchar(64)

AS

set nocount on

declare @sql varchar(4000)

select @sql = 		'BACKUP DATABASE ' + ltrim(rtrim( @databasename ))
select @sql = @sql + 	'   TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' '
select @sql = @sql + 	'   WITH INIT'
--print @sql
execute ( @sql )

select 'Database successfully backed up!' [Result]



Welcome Smile | :)

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

QuestionDynamically radiobuttons? Pin
Priya Prk14-Jul-09 0:18
Priya Prk14-Jul-09 0:18 
AnswerRe: Dynamically radiobuttons? Pin
s.crosby14-Jul-09 0:35
s.crosby14-Jul-09 0:35 
AnswerRe: Dynamically radiobuttons? Pin
Muhammad Mazhar14-Jul-09 0:41
Muhammad Mazhar14-Jul-09 0:41 
AnswerRe: Dynamically radiobuttons? Pin
Sabari MD14-Jul-09 0:51
Sabari MD14-Jul-09 0:51 
Questionadd custom function to built-in function list in InfoPath Pin
JimmyRopes14-Jul-09 0:12
professionalJimmyRopes14-Jul-09 0:12 
QuestionReload Frames Pin
yesu prakash14-Jul-09 0:02
yesu prakash14-Jul-09 0:02 
AnswerRe: Reload Frames Pin
Baran M14-Jul-09 1:20
Baran M14-Jul-09 1:20 
Questionplz send an article on grid view updating value Pin
haleemasher13-Jul-09 23:25
haleemasher13-Jul-09 23:25 
AnswerRe: plz send an article on grid view updating value Pin
Baran M14-Jul-09 1:31
Baran M14-Jul-09 1:31 
AnswerRe: plz send an article on grid view updating value Pin
Christian Graus14-Jul-09 2:32
protectorChristian Graus14-Jul-09 2:32 
AnswerRe: plz send an article on grid view updating value Pin
Vimalsoft(Pty) Ltd14-Jul-09 2:32
professionalVimalsoft(Pty) Ltd14-Jul-09 2:32 
QuestionCrystal Pin
Chris Maunderr13-Jul-09 22:56
Chris Maunderr13-Jul-09 22:56 
AnswerRe: Crystal Pin
Manas Bhardwaj13-Jul-09 22:59
professionalManas Bhardwaj13-Jul-09 22:59 
GeneralRe: Crystal Pin
Chris Maunderr13-Jul-09 23:19
Chris Maunderr13-Jul-09 23:19 
AnswerRe: Crystal Pin
Manas Bhardwaj13-Jul-09 23:26
professionalManas Bhardwaj13-Jul-09 23:26 
GeneralRe: Crystal Pin
Abhijit Jana13-Jul-09 23:47
professionalAbhijit Jana13-Jul-09 23:47 
GeneralRe: Crystal Pin
Chris Maunderr14-Jul-09 0:30
Chris Maunderr14-Jul-09 0:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.