I understand that SQL server will not use all the allocated memory at a particular point of time. It uses only the required amount of memory, which at this point...

You can use this system sp as well "sp_testlinkedserver"

Try executing a simple select on the linked server.

check, test the linked server on SMS, for something like , probably a wrong password.

🙂 i sure did..n got quite a few results, but mainly guidelines.. i am looking for something like a complete guide, on each and every aspect..

Thank u all for ur help.. I have been able to accomplish what I needed to 🙂

Yes I need to, but not all the users. I need to keep 5 users , and remove the rest. To drop these users, I need to first drop the...

The issue is I need to drop view belonging to users, except 3 users , say a,b and c. These users come to around 200.There are 200 views per user....

Just what I needed. Thanks a lot for Jeff... 🙂

The users can be fixed by running a procedure which runs something like a cursor, the sp sp_change_users_login on each user of the database so that the SID mismatches are...

This is not a task I need to do, it is for learning purpose. I happened to read that word docs/images can be stored in sql server using BLOB. I...

Thank You for your response. Could you please give me more inputs on how I can implement this on SQL 2005.

insert into DBSize

select db_name(), round((sum())*8,2) as [SizeMBTotal],

(select *8 from sysfiles

where filename like '%.mdf')SizeMDF,

(select *8 from sysfiles

where filename like '%.ldf')SizeLDF

from sysfiles

Please let me know if this...

I request you to please give me more details. If it is not a complex one, this would be fine. Please help me with how this can be implemented.

Would there be any other way other than not installing query analyzer?

The only access the users need to have to the db is through the application, which connects to the db thru the specified app role.This is already present. We need...