you can store the output of the jobs as nad when run to a text file. then use the @attachments parameter so attach the file in your mail msg.

great that u had a heavy-weight in your corner to support you. mostly end-users don't accept whats said in the security document. and its hard to convince them. the g8...

Villeta, yes of course login with a windows account with sysadmin privilege and change the password for 'sa'. my last post also said the same.

"login with a windows account...

this mite be because u dint update te target server properly. if u r not able to delte the job using sp_delete_job the other option is to remove the entry...

Microsoft suggests to have the data and indexex in different file groups to enhance performance. but if you just need to insert data of huge time only once in a...

grant execute privilege on sp_helptext. i hope this should work. please give us what the error that the user is getting

i hope specifying only the IP address will take you to the sql server installed as default instance. if you have installed 2005 as named instance specify ip\instance name.

if thats the case the best option that i can say is that use either row or column level replication or if this is not possible then the following will...

my advice is don't give any privilege to GUEST user. Remove or revoke all the privileges given to the user if there is any

try using sp_pkeys or sp_fkeys to get the primary and foreign key relationships.

yes as mentioned by the last user, use database mirroring or log shipping or replication. before first read out the full requirements of why do you want to do this....

login with a windows account that has sysadmin privilege and change the password for the user sa and then use the new password that u have given. this should work.

best way that i would suggest is to use DTS to transfer your logins tothe destination servers.

yes change your authentication mechanism to mixed mode. Please do the below to change that.

1. Open enterprise manager

2. browse to the server and right click properties

3. move to security tab...

The difference is the local system account is a user only pertaining to that machine. I can access resources only in that machine. But a network user can even access...