Ok after reading some articles about adding linked servers this is what i did. We have a test server whose network is 10.1.1.1 inside this server is a database named...

Yeah noted 😎

AHhh ok thanks for the clarification it just happened that i saw the statement in that link that is why i included it in my script. Anyways thanks for the...

Anyways i got my answer in this link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615

SELECT UserName = name FROM sysusers

WHERE issqluser = 1 and (sid is not null and sid <> 0x0)

and suser_sname(sid) is...

Kenneth Wilhelmsson (10/9/2007)

---

There's nothing wrong to construct a query based on whatever the userinput is, then when the query is known and complete, just run it from the app.

There's no...

Ahhh ok thanks.... 😛

thanks very much Marcus!!!!!! works very fine the SQL Server Agent starts again ill take note this information

Got the link i need thanks....

www.sqlservercentral.com/articles/Administering/listofdatabaseuserswithdatabaseroles/1545/

Do you know any scripts that gets database users and their respective roles??

Ahh ok thanks for the clarification then i concluded the those database user properties are not equal to those values in the sysusers. The reason i asked this question is...

This are the scripts that i used to monitor data/log files procedure are as follows:

1. Run Create table script (create table)

2. Run usp_data_info (create procedure)

3. view_data = is used to...

If the databases are in the same instance, i recommend John Rowan's post

GilaMonster (10/1/2007)

---

Lester Policarpio (10/1/2007)[hr

What if I just want to delete orphaned users in sysusers and i enabled the "allow updates" then disabled it after deleting the orphaned user?Am I doing...

Rich (10/2/2007)

---

Hmm,

I've backed up the tlog and ran shrink options: "Compress pages & truncate free space from end of file", and, "Truncate free space from the end of file", I...

I searched the net bout the error you recieved and it gave me 1 good URL try this one it could help

http://support.microsoft.com/kb/812486