Answer / ram suresh.l

While u create a user login in enterprise manager,u will be
given an option of creating the user with windows
authentication/SQL server authhentication mode.
You can choose the appropriate one

Answer / madan

sp_grantlogin'Domainname\loginname'

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

---

What are the requirements on sql server network connections?

0 Answers  

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

How you trouble shoot when any job fails

0 Answers  

---

Explain the relational database management system (rdbms)?

0 Answers  

---

Explain in brief how sql server enhances scalability of the database system?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

How to connect to a sql server using odbc_connect()?

0 Answers  

---

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---