The same answer that has been given in this topic, it is not stored anywhere. thanks for confirming it.

Whats the salary, just out of interest.

talltop-969015 (10/22/2009)

---

Maybe just maybe I am missing something, these are supposed to be simple interview questions, out of this list of questions. I have been asked the following.

*Difference between delete...

Krasavita (10/22/2009)

---

This what it showing:

SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIOLastBatchProgramNameSPID

55 sleeping my...

Silverfox (10/22/2009)

---

Krasavita (10/22/2009)

---

I am updating 46 million records in the table and it is running for 15 hours. How can I check if it is running still, if my transaction...

Krasavita (10/22/2009)

---

I am updating 46 million records in the table and it is running for 15 hours. How can I check if it is running still, if my transaction logs...

ramuvanparti (10/22/2009)

---

select 'DROP LOGIN [ '+name+'] GO ' from master..syslogins

where name not in ('domain\raj','raju')

this Tsql will give drop login script for all user except which you will filter out.

copy it...

Press F7...

SORT_IN_TEMPDB, is an index setting/option.

as far as i know, none of the tables/catalogues/metadata show if an index was created using this option. if that is what you are trying to...

Strange interview question if it is lol

kevriley (10/22/2009)

---

Silverfox,

my local group is the Manchester SSUG, part of the UK SSUG - try their website www.sqlserverfaq.com - it's maintained mainly by Tony Rogerson. They also have meetings...

Bhaskar Basak (10/22/2009)

---

Hi,

I have a user database running in SQLEXPRESS 2005 . This database could have different collation other than the server based on the installation. So The collation of...

shanila_minnu (10/22/2009)

---

i have 6000 logins in one of the server.in this i need only 30 logins now.how can i delete it in one stretch without disturbing the needed 30 logins.please...

Not sure I understand what you mean by page size, can you give more details?

Not sure I understand the question, if you are using a windows account, then the security of that account is down to the strength of the password that you have...