Viewing 15 posts - 856 through 870 (of 1,335 total)
Are you able to connect your SQL server from the remote machine using sqlcmd or SSMS. Check for them and let us know.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 10:55 pm
If you have the same version before and after rebuilding then there is no need to apply any service packs or hotfixes to your server. Then resource database will be...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 10:50 pm
What Jeff says can be done but it will take yup some of your time but sure that you will learn stuff with using excel and maipulating data using excel.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 7:21 am
You mean to say that you don't get the executing thing in the sql agent process. Looks weird but you have you not upgraded to SP4. Do that and check...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 7:06 am
HKLM\system\currentcontrolset\services and check for MSSQLServer and SQLServerAgent paths and you will find the details within those keys.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 7:02 am
Can you post the error message that you get when the user tries to access the server through EM.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:45 am
Can you post the error message that you get when the user tries to access the server through EM.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:45 am
Apart from that have a look at the backup tables to know which file to restore from.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:38 am
Are there any other steps in the job than the backup job if so check also try to log the job so that you can trace where the job writes...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:36 am
OS error 5 corrsponds to permissions issue on the file and folder paths. Check for the privileges whenever you get such an error.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:30 am
It should be available in tools->options menu.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:23 am
You can even use the no_log option in that case.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 6:07 am
Does anyother process or job go in parallel with this job. Particulary check for the backup database job.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 5:51 am
http://www.go4expert.com/forums/showthread.php?t=329
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 5:20 am
There are few differences let me list out what comes to my mind.
A stored procedure need not take a value and return a value where as a function needs to...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 2, 2007 at 5:19 am
Viewing 15 posts - 856 through 870 (of 1,335 total)