|
I have solved this problem.
cheers,
Abhijit
|
|
|
|
|
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?
|
|
|
|
|
Post it into SQL Forum .you will get better answer. this is asp.net forum
cheers,
Abhijit
|
|
|
|
|
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??
|
|
|
|
|
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.
|
|
|
|
|
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..
|
|
|
|
|
AFAIK, when a server instance is expanded from the left tree in the enterprise manager, it asks for user credentials if it is set.
|
|
|
|
|
Yes, but I don't know how to set them?
Can u please tell me in details??
|
|
|
|
|
Sorry, I don't have SQL server 2000 installed
|
|
|
|
|
thanks anyway...glad you helped
|
|
|
|
|
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?
|
|
|
|
|
Yeah, if you stop SQL service instance, users accessing it will get error. Why don't you take a backup of the database ?
|
|
|
|
|
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??
|
|
|
|
|
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
|
|
|
|
|
How to insert Hindi in MS Sql Server using ASP.NET with c#.Can any one help me
Thanks
Vishal Rastogi
|
|
|
|
|
Local languages has to be stored as unicode. So use "NVarchar" type for the column.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
I have try but it is not working.Data is store in ???? format.This is Text that i Paste in TextBox "इज़राइली अर्थव्यवस्था का मूल "
Vishal Rastogi
|
|
|
|
|
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
|
|
|
|
|
Create a separate master page which don't have this restriction and use that in all pages where you don't need restriction.
|
|
|
|
|
|
Abhijit Jana wrote: [D'Oh!] [D'Oh!] [OMG] [WTF] [Frown] [Frown]
Means ?
|
|
|
|
|
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
|
|
|
|
|
For the popup page, when session becomes empty, don't redirect to login page. Show a message indicates session expired and need to relogin with a link to relogin. When the link is pressed, handle the click event in JS and set the URL of parent window to your login page's URL and close the current page (popup).
|
|
|
|