Viewing 15 posts - 646 through 660 (of 1,098 total)
Under what account are you starting the SQL Server Agent Service? You should check, that the login has access to the directory that the DTS package access.
April 15, 2003 at 1:23 pm
Well...that coud be a problem then, I read once, that it is not right to have both on the same server. I will try to find an article, if anyone...
April 15, 2003 at 10:34 am
You can disconnect the users with the kill command. To kill all the users connected you can check this topic posted before
April 15, 2003 at 10:00 am
Did you try sending an email with xp_sendmail? And if so, Did you get the same errors? Is the Exchange server in the same domain that in wich SQL Server...
April 15, 2003 at 8:24 am
did you loggin in with the windows account that starts the services and create a mail profile for that user?
April 15, 2003 at 7:08 am
I seems that the distributor can't read the snapshot file. You should check that in that path you have all the snapshots files needed to start the syncronization. If the...
April 15, 2003 at 6:58 am
You can use Windows Performance Monitor to check for example, the transactions/Sec. Add a counter, chosee the SQL Server:Databases performance object and then chosse transactions/sec.
April 15, 2003 at 6:48 am
You don't need to use the option. No user can access the database been restored. Once you finish restoring all your backups, or restore the database with the recovery option,...
April 15, 2003 at 6:42 am
Well zipping the snapshot's file after modifying them worked just fine for me, so I will used this method. Thanks anyway.
April 11, 2003 at 2:02 pm
What error are you receiving? Check that the concatenation returns the result you expect. Use print to see if the body is right.
April 11, 2003 at 11:00 am
Check that the user account you use to start the agent has permissions into the files.
April 11, 2003 at 10:50 am
But Why do you want the replication monitor to show up if you won't use replication in your servers.
Are you planning to set the server as a distributor to start...
April 11, 2003 at 10:38 am
Thanks, I will give it a try.
Anyway I have generate the snapshot without the compress option. Modify the .bcp files and zip the files with rar.exe.
And manage to transfer the...
April 11, 2003 at 10:12 am
Viewing 15 posts - 646 through 660 (of 1,098 total)