Thanks a ton...

first make sure that the domains have trust relation between them. the remote desktop session might have been disabled in the the sql server, check it and use (fully qualified...

yes sure,

before that i would like you to ask yourself few questions

1. what are the options by which you can make your server available 99.9999% up in an year?

2. what...

its for scalability and high availability that we use replication and mirroring together.

i hope you can read the contents of a folder using extended stored procedures in sql server.

master..xp_cmdshell 'dir 'path to the folder''

hey,

why do you want sql server to access the file server folder? could i know the reason.

and one more thing, you have a wrong understanding on linked server.

linked server...

yes,

you can run logshipping without installing iis.

yes,

you can script the mail configuration. you can read the bol for detailed information.

hi iis is not required for sql server database engine to work smoothly, but if at all you want reporting services to be run on the same server, then...

i have done the same process and then only i have told you while i have tried to connect ssms with different user than that mentioned in the linked list...

when you have created a linked server in the local system

there will be an option security in the wizard select the tab

in the tab you should add the local user...

do you same login for both the servers?

if you have same login defined in both the servers then does the user has database access in both the servers?

you need to assign the user to a role.

or else

grant what are all the permissions you want to give the user using the grant (t-sql)

hi lianv,

you can use this query to load the data into same table again and again instead of creating a new table.

insert INTO table_name FROM ::fn_trace_gettable('c:\filename.trc', default)

but the thing is...

hi,

i think you can go for powershell for monitoring all the servers, this is one of the best options i found.