Viewing 13 posts - 31 through 44 (of 44 total)
Ok, Shaun, i just checked and my SQL 2K5 has 80 compatibility like you said, but it works in 2k, so the suggested answer isn't correct across platforms.
so what...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 31, 2008 at 9:12 am
I disagree! it works perfectly in both 2K and 2K5. i have both versions and i tried it out just to be double sure.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 31, 2008 at 8:30 am
SQL ORACLE (3/19/2008)
You may add some PRINT commands at the points you suspect, and see if you can get expected results.May the above help.
Unfortunately, that is a challenge,...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 19, 2008 at 11:41 am
SQL ORACLE (3/18/2008)
Right:
If your virtual server does not have enough resource, your jobs may not be processed in time. As a result, you may...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 19, 2008 at 6:36 am
I agree with Brandie and Bob (as with so many others who have posted replies on this thread).
I'm very new to SQL Server, i have a Oracle Applications Developer/10g DBA...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 7:48 am
thanks all,
after i executed the block of code (Phillip's) and refreshed my connection, i could open the properties of SQLSERVERAGENT, which prior to now had been greyed out(disabled).
As i went...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 7:27 am
sorry, forgot to include the message on the result pane
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Agent XPs' changed from...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 5:59 am
Hi Phillip,
this was displayed on the result pane after i ran the block of code against the master database.
Remote connections are enabled and i have tried to start SQLSERVERAGENT to...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 5:55 am
thanks's Phillip,
what database should i run this against? msdb?
sp_configure 'show advanced options','1'
RECONFIGURE
go
sp_configure 'Agent XPs','1'
RECONFIGURE
go
This will enable Agent XP's and SQL Server Agent should start.
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 4:29 am
here is the content of SQLAgent.out
2008-03-07 10:23:33 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]
2008-03-07 10:23:33 -...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 4:11 am
these lines are from the records that read Error Log in the EventClass Column
2007-07-19 13:03:24.54 spid51 Configuration option 'show advanced options' changed from 0 to...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
March 7, 2008 at 3:26 am
thanks, i didn't know that. i'll correct it at once.
Cheers
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
February 12, 2008 at 1:00 pm
thanks for responding.
the backupfile is not appended to, it creates a new file each day, that is then zipped and moved to another physical location. so E:\Backups_Loc is empty...
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
February 12, 2008 at 7:50 am
Viewing 13 posts - 31 through 44 (of 44 total)