If we restore the user databases after the system databases how will we know which database the user is mapped and what role he has.

Did you check the effected object.

DBCC TRACESTATUS(-1) check all trace status

DBCC TRACEOFF(1807, 3604) off trace 1807 and 3604

Abhay

Will all logins , users, roles will be restored.

Should be restore the user database before master , model and msdb if a server crash occurs and you are creating an...

Is this possible in express edition.

You will not loose any data.

Its just that your data file is of 200GB and there is no free space available.So no matter how much you shrink the files it...

San (6/28/2009)

---

Dear All,

One person asked me the following questions in an interview. Pls help.

1. Suppose I have 2 servers. Firt one is with 2GB RAM and the second one...

If have to keep both the table data in the same database its better to create table1_New.

to query both table1 and table1_new use join table with where clause.

You cannot add...

_ (underscore) : def : Any single character.

example:

WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean, Sean, and so on).

use

Not like 'sp[_]%'

If you have primary key then you will have unique key constraint .

So check the data that you are import to the column having PK constraint has no values that...

I want to fetch one row at a time and then satisfy the conditions following while @@row_count 0 and while @@fetch_status = 0 .

Will using SELECT statement that assigns...

are both same.

can you give me some example.

I know he is slow and...

.

How to avoid clustered and non-clustered index Scan's and also table scans.

Which is better if i do not need to update cursor result set:

DECLARE c1 CURSOR

or

DECLARE c1 CURSOR READ_ONLY

or

DECLARE c1...

Hi jeff,

The story is i have non-clustered PK .

I want to make this non-clustered PK to clustered PK in sql server 2000 because it will improve performance i guess.

When i...