|
from SQL Enterprise Manager select the database right click
1. select "All tasks"
2. select "restore database"
3. From the "General" tab ...
4. select "FromDevice" option
5. click on "SelectDevices..." to borwse and select the backup
6. go to "Options tab"
7. if the path under "Moive to Physical file name" is pointing to another folder than the actual folder change the same (other wise thros err stating "Move ... Physical file ...." some thing like this"
8. also you can select "Force restore over existing database"
Regards
KP
|
|
|
|
|
hi KP
thank you very much
it works
regads
chandru
|
|
|
|
|
Hi KP
Thank you very much
it worked
regards
chandru
|
|
|
|
|
From Enterprise Manager
do backUp Database
and restore but with another name and in option tab do the right location.
Take ofline and Bring on line is not such great idea.
backup and restore is option for such task
|
|
|
|
|
hi all,
How to use Rollback in sql server. can anyone help me in it.
Tech_spidy
|
|
|
|
|
|
how can i write a connection string in c# .net to work with a dsn in a remote/local system for msAccess db. Waiting eagerly
sabindas@gmail.com
|
|
|
|
|
Configure the connection from :
Administrative Tools->Data Sources(ODBC)
and make the connection string like in this link:
http://www.connectionstrings.com/?carrier=dsn[^]
What do you mean by remote system ?
do you want to access Access database on a server from clients? Or to place it on a shared folder?
|
|
|
|
|
how can i write a connection string in c# .net to work with a dsn in a remote/local system for msAccess db. Waiting eagerly
sabindas@gmail.com
|
|
|
|
|
connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=bran.mdb;Jet OLEDB:Database Password=n123";
System.Data.OleDb.OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = connStr;
Regards
KP
|
|
|
|
|
Hi All,
I am now to sql server 2000 ,pls clarify my doubt,
I have transaction within another if it fails to execute the entire transcation also rollback or not, if the problem in main transaction then what's happend pls give some information about transcation concept,
Thanks N Advance
|
|
|
|
|
You can check this article[^]
you can execute it's code in query analyzer too.
|
|
|
|
|
Hi All
IAm just started learning sql server 2000.
I have on stored procedure sp_getdepdetails
I Am writng another stored procedure sp_getempdetails in that calling with exec sp_getdepdetails.
but error in sp_getdepdetails. my doubt is sp_getemodetails is executed or not
Thanks N advance
|
|
|
|
|
shld get executed!!!
by the way what is the error in your main sp??
Gautham
|
|
|
|
|
hi all
i am using odbc connection to query the data from excel ...
i am able to ... the query i use is
select empid from [sheet1$]... (empid is the column header in the first row)
the problem is i want to access the data by ponting the index of the column .. something like
select column1 from [sheet1$]
can anyone suggest the query for that ???
Annns
|
|
|
|
|
SELECT * FROM [Sheet1$A1:A1000]
|
|
|
|
|
thanx for the reply  ..
hope it will help me...
but still one more doubt ... then how will we get the
value from result set?? like rs.getString("?"); ???
Thnks
Annns
|
|
|
|
|
use adapter to fill data .and use them like
myDataTable.Rows[row_num][column_no]
|
|
|
|
|
thanx so much .. let me try it out !!
|
|
|
|
|
how many versions we have in sql which one is latest version...
|
|
|
|
|
The last version of MS SQL Server is 9.0 (2005)
or do you mean SQL ANSI standards ?
|
|
|
|
|
how to use rollback . give me syntax please
|
|
|
|
|
you can get the from online help
however i'm pasting only syntax part from the same
ROLLBACK [ TRAN [ SACTION ]
[ transaction_name | @tran_name_variable
| savepoint_name | @savepoint_variable ] ]
Arguments:
transaction_name
Is the name assigned to the transaction on BEGIN TRANSACTION. transaction_name must conform to the rules for identifiers, but only the first 32 characters of the transaction name are used. When nesting transactions, transaction_name must be the name from the outermost BEGIN TRANSACTION statement.
@tran_name_variable
Is the name of a user-defined variable containing a valid transaction name. The variable must be declared with a char, varchar, nchar, or nvarchar data type.
savepoint_name
Is savepoint_name from a SAVE TRANSACTION statement. savepoint_name must conform to the rules for identifiers. Use savepoint_name when a conditional rollback should affect only part of the transaction.
@savepoint_variable
Is name of a user-defined variable containing a valid savepoint name. The variable must be declared with a char, varchar, nchar, or nvarchar data type.
Regards
KP
|
|
|
|
|
how to generate automatic id like c001.c002;
|
|
|
|
|
In SQL Server generates serial numbers automatically if the column is 'Identity column'. however this is possible only for numeric data type.
in your case
SELECT max(cast(substring(id, 2, 3) as bigint)) + 1 FROM tableA
here ....
1. using substring extracting last three digits
2. converting the digits to numeric
3. getting max()
4. then incrementing by one.
Regards
KP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
