Hey folks,

what is this???let me remind you one thing!!!!this is not the place for your silly fightings.....stay away 😎

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

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

Security--> logins --> properties --> usermapping

In that you can map the user to particular databases.also provide db_owner permission too

I think the user is not mapped correctly for particular dB

1. If I run the command using Judy's suggested syntax, do I put the file name in there where she has "logical filename"? For example, do I type DBCC...

Take transaction log backup,apply checkpoint,shrink the log file.

DBCC SHRINKFILE (, )

sp_who2..........

Usage: 3604 is to redirect the output onto the screen/file. default is to

direct the output of the dbcc's that come after 3604 is errorlog. and is

session based.

impact: depending on what...

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

In the properties of newly created login goto usermapping.There you can map databses to users and give them appropriate privileges

if a request came, "provide access to the database ABC of the server XYZ" what should i do...will i have to create a new user or a new login and...

A SQL Server login allows a user to connect to a server, whereas a

database user is associated with a login to allow specific permissions

on that database. A login...

😀

Backup transaction log and shrink db

For what??????????????????:w00t: