if I am understanding your requirement properly then :-

select SUBSTRING(vdoc,1,1), * from #track where SUBSTRING(vdoc,1,1) not in ('v','i','c')

**SUBSTRING(vdoc,1,1), this value gives the first character and I am using this...

for those who are in facebook, have a look of this video......

http://www.facebook.com/video/video.php?v=185137544836637

isnt it funny.....hahahahahah.

Summary :- FACEBOOK IS A STUPID IDIOT

to make you happy 🙂

if you have ssms 2008, you can see it there.

Once you able to figure it out in 2008 then you will be able to see in 2005, if option...

This is the option you configure in SSMS -- tools--option--sqlserverobjextexplorer.

You will see 2 value there

Value for edit

Value for Select.

You can increase and decrease it.

🙂 thanks for confirmation that you too agree.

-------------------------------------------------

for the safe side, anyhow you have to take the downtime, no matter which strategy you choose.

So will suggest, to draft your...

OR

you can move unused data to different filegroup and put that filegroup in another drive. (Putting onto same drive where you already have operation mdf file, will affect performance).

You...

select * from sys.dm_tran_locks

Are you sure you providing the correct servername?

Are you able to connect the sql server from SSMS using the mentioned usedid and password?

i think this is your third basic question.

ITs better to have a read of these articles on msdn

http://msdn.microsoft.com/library/ms123401

It will clear your basic concept.

You are always welcome to discuss...

as addressed :-

http://www.sqlservercentral.com/Forums/Topic1045738-357-1.aspx

http://msdn.microsoft.com/en-us/library/ms179401.aspx.

same approach for restoration.

If I have acknowledged your query properly then I assumed that you looking for result like :-

user id1having roles of ADMIN, and status is ACTIVE since 2011-01-01 00:00:00.000

I have used...

Thanks for your response.

I am not able to see any value which gives the confirmation that account is locked(except status which I am not sure what exact meaning of...

great to hear.

I have read this book quiet long back but the words are still fresh.....Learn how to say NO.