ASP.NET

19-Jul-08 1:38

I have solved this problem.

cheers,
Abhijit

sql query

ptvce18-Jul-08 23:20

ptvce

18-Jul-08 23:20

i have 2 table in sqlserver. i want do this command
insert into dabirestan (amuzeshgah) values (select amuzeshgah from dabirestan1)

i want fill the record of table dabirestan1 to table dabirestan

i want write a query. how is my query cammand. do any body know?

Re: sql query

Abhijit Jana18-Jul-08 23:29

How to automatically backup my sql server 2000 database on another server??

18-Jul-08 23:29

Post it into SQL Forum .you will get better answer. this is asp.net forum

cheers,
Abhijit

Nada Adel18-Jul-08 21:17

Re: How to automatically backup my sql server 2000 database on another server??

18-Jul-08 21:17

Are there any free tools to use to backup the database on my server and put the backup copy on another computer on the same network??
Does sql server 2000 have these kinda programs or plugins??

I also have a problem when I try to access sql server 2000 from the server. I need assign a username and password on the enterprise manager and query analyzer so that no one can open them from the server..how can I do that??

N a v a n e e t h18-Jul-08 21:20

Re: How to automatically backup my sql server 2000 database on another server??

18-Jul-08 21:20

Nada Adel wrote:
and put the backup copy on another computer on the same network

You can use DTS to transfer data from one server to another. You can do this via enterprise manager.

Nada Adel wrote:
I need assign a username and password on the enterprise manager and query analyzer so that no one can open them from the server..how can I do that??

You want to assign user name and password for database ? You can create users and permissions from the enterprise manager.

BTW, this has nothing to do with ASP.NET. Please don't cross post. This post should be in SQL forum.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Nada Adel18-Jul-08 21:22

Re: How to automatically backup my sql server 2000 database on another server??

18-Jul-08 21:22

I know how to create a username and passwords on the databases. what I meant was how to set username and passwords on the programs themselves like when I user opens the enterprise manager he is prompted to enter username and password..

N a v a n e e t h18-Jul-08 21:28

Re: How to automatically backup my sql server 2000 database on another server??

18-Jul-08 21:28

AFAIK, when a server instance is expanded from the left tree in the enterprise manager, it asks for user credentials if it is set.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Nada Adel18-Jul-08 21:30

Re: How to automatically backup my sql server 2000 database on another server??

18-Jul-08 21:30

Yes, but I don't know how to set them?
Can u please tell me in details??

N a v a n e e t h18-Jul-08 21:32

Re: How to automatically backup my sql server 2000 database on another server??

18-Jul-08 21:32

Sorry, I don't have SQL server 2000 installed Frown | :(

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Nada Adel18-Jul-08 21:39

Cannot copy DBFile: It is being used by another person or program??

18-Jul-08 21:39

thanks anyway...glad you helped Smile | :)

Nada Adel18-Jul-08 21:14

Re: Cannot copy DBFile: It is being used by another person or program??

18-Jul-08 21:14

How can I get rid of this message when I try to copy a database file that runs on sql server 2000??
I searched and I found that if I used ctrl alt delete and ended the sql server processes, I should copy the file but the problem is that I need to copy these files from a server so I'm afraid if I ended these processes, users of the wesite site including the database might lose data..How can I solve this?

N a v a n e e t h18-Jul-08 21:17

Re: Cannot copy DBFile: It is being used by another person or program??

18-Jul-08 21:17

Yeah, if you stop SQL service instance, users accessing it will get error. Why don't you take a backup of the database ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Nada Adel18-Jul-08 21:18

Re: Cannot copy DBFile: It is being used by another person or program??

18-Jul-08 21:18

yes, I need to know how can I take a backup of the database and save it on another computer and then access it from another computer??

pradeep kumarappagari20-Jul-08 19:33

pradeep kumarappagari

20-Jul-08 19:33

stop sqlserver first and then u copy dbfile in some other place. with out stoping sqlserver u can not copy .mdf and .ldf files.

Pradeep Reddy

Store Hindi Data in MS Sql Server using ASP.NET with c#

vishalrastogi1118-Jul-08 21:05

vishalrastogi11

18-Jul-08 21:05

How to insert Hindi in MS Sql Server using ASP.NET with c#.Can any one help me
Thanks

Vishal Rastogi

Re: Store Hindi Data in MS Sql Server using ASP.NET with c#

N a v a n e e t h18-Jul-08 21:11

Re: Store Hindi Data in MS Sql Server using ASP.NET with c#

18-Jul-08 21:11

Local languages has to be stored as unicode. So use "NVarchar" type for the column.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

vishalrastogi1118-Jul-08 21:25

vishalrastogi11

18-Jul-08 21:25

Thank for Reply.Can u send me a demo code in which i from a TextBox Control Hindi data is store in MS Sql Server at button Click .

Vishal Rastogi

Re: Store Hindi Data in MS Sql Server using ASP.NET with c#

N a v a n e e t h18-Jul-08 21:29

Re: Store Hindi Data in MS Sql Server using ASP.NET with c#

18-Jul-08 21:29

It's trivial. Just make your columns as "NVarchar". Do usual coding elsewhere. When showing the result, make sure you selected UTF-8 encoding in your browser.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

vishalrastogi1118-Jul-08 21:46

vishalrastogi11

18-Jul-08 21:46

I have try but it is not working.Data is store in ???? format.This is Text that i Paste in TextBox "इज़राइली अर्थव्यवस्था का मूल "

Vishal Rastogi

Right click Disabled

Abhijit Jana18-Jul-08 21:04

18-Jul-08 21:04

i have used some java script to disable right click to our web application. this is wrriten in master page. so its effects to all pages. but i need it enabled in a particular page.

can any body has some idea ?

please help.

cheers,
Abhijit

Re: Right click Disabled

N a v a n e e t h18-Jul-08 21:09

18-Jul-08 21:09

Create a separate master page which don't have this restriction and use that in all pages where you don't need restriction.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Right click Disabled

Abhijit Jana18-Jul-08 21:28

18-Jul-08 21:28

cheers,
Abhijit

Re: Right click Disabled

N a v a n e e t h18-Jul-08 21:33

18-Jul-08 21:33

Abhijit Jana wrote:
[D'Oh!] [D'Oh!] [OMG] [WTF] [Frown] [Frown]

Means ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Clsoe all popup windows

Abhijit Jana18-Jul-08 21:01

Re: Clsoe all popup windows

18-Jul-08 21:01

How can i close all popup window on a linkbutton click ?

i want , if session expire in Popup windows when user click on please login again , user should redirect to main login page . currently my login page comes inside the popup .

please any idea !!!

Thaks in advance.

cheers,
Abhijit

N a v a n e e t h18-Jul-08 21:08