Wednesday, March 21, 2012
error 7405
I try to save the procedure I get the following error
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
set for the connection. This ensures consistent query semantics. Enable these
options and then reissue your query.
I have put SET ANSI_WARNINGS ON as the first line of the procedure with no
help.
Are there any suggestions?
Jim Capehart
The connection creating the stored procedure needs to have
the settings on. So you'd want to create the stored
procedure using something along the lines of:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE YourStoredProc...etc.
-Sue
On Fri, 17 Dec 2004 08:11:02 -0800, Jim Capehart
<JimCapehart@.discussions.microsoft.com> wrote:
>I have created a stored procedure wich queries a linked ORACLE database. When
>I try to save the procedure I get the following error
>Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be
>set for the connection. This ensures consistent query semantics. Enable these
>options and then reissue your query.
> I have put SET ANSI_WARNINGS ON as the first line of the procedure with no
>help.
>Are there any suggestions?
>Jim Capehart
|||Guys,
This doesn't necessarily work. If your not happ y with adding these
settings to the the server as a whole then try using the ISQL window to
create the procedure.
Be sure to make a copy of the oprginal (just in case) but this will
allow the SET command to intigated at the top of he procedure.
Hope this helps.
JohnT-A
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message654588.html
Monday, March 19, 2012
Error 7373 in Linked Server
I am rather new to SQLServer, so I would be happy with any help I can get.
Thanks,
DGB
Which sql server version, and which ole db provider (and what is your backend data source) are you using?
The 7373 error code may suggest some errors in the ole db provider itself.
If you are familiar with profiler, you can start the profiler and collect oledb trace events to get more insights into the problem.
Error 6522 Trying to Run Assembly from database
Hi,
I am attempting to load an assembly that has been stored in a table as a byte array. I have created a c# class called AssemblyLoader that takes in 2 parameters, the assembly name and the parameters for the assembly (just a query string).
From this it returns the assembly byte array using a simple sql statement within the class using the assembly name to select the assembly bytes to return from the database.
The returned byte array of the assembly is loaded using:
Assembly assembly = Assembly.Load(assemblyBytes);
This seems to be the line that SQL Server 2005 is erroring on. Do I need to add some extra assemblies to the database and if so which ones.
Error:
Msg 6522, Level 16, State 1, Procedure ClientInterface, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'ClientInterface':
System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.
System.IO.FileLoadException:
at System.Reflection.Assembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection)
at System.Reflection.Assembly.Load(Byte[] rawAssembly)
at Reflector.runQuery(String query, String parameter)
Thanks for your help.
Niels|||Cheers Niels
I am using Assembly.Load with the Full name of the assembly and it works fine.
Thanks|||So does this mean that you can create a Class Library project, compile it and then simply place the assembly inside SQL 2005 to get access to external objects?
Just to confirm, you are not limited to placing the output of SQL Server Project inside SQL Server 2005?
Thank you,
Lubomir|||Thats pretty much all I have done. I have created 3 seperate Class Library Projects that each extend a common interface so that they all have the method
public static string execute(string data)
and are compiled and added to the database. They are loaded depending on the query I pass in and they go off and get data from different interfaces ie, LDAP, HTTP SOAP etc... and return me a simple string.
N
|||Lubomir,
A SQL CLR Project is just a project type in VS, which makes it easier for the developer to create and deploy assemblies to SQL Server. Under the cover the SQL CLR Project is just calling CREATE ASSEMBLY ... etc, in order to deploy.
Niels
Error 6522 Trying to Run Assembly from database
Hi,
I am attempting to load an assembly that has been stored in a table as a byte array. I have created a c# class called AssemblyLoader that takes in 2 parameters, the assembly name and the parameters for the assembly (just a query string).
From this it returns the assembly byte array using a simple sql statement within the class using the assembly name to select the assembly bytes to return from the database.
The returned byte array of the assembly is loaded using:
Assembly assembly = Assembly.Load(assemblyBytes);
This seems to be the line that SQL Server 2005 is erroring on. Do I need to add some extra assemblies to the database and if so which ones.
Error:
Msg 6522, Level 16, State 1, Procedure ClientInterface, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'ClientInterface':
System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.
System.IO.FileLoadException:
at System.Reflection.Assembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection)
at System.Reflection.Assembly.Load(Byte[] rawAssembly)
at Reflector.runQuery(String query, String parameter)
Thanks for your help.
Niels
|||Cheers Niels
I am using Assembly.Load with the Full name of the assembly and it works fine.
Thanks
|||So does this mean that you can create a Class Library project, compile it and then simply place the assembly inside SQL 2005 to get access to external objects?
Just to confirm, you are not limited to placing the output of SQL Server Project inside SQL Server 2005?
Thank you,
Lubomir|||Thats pretty much all I have done. I have created 3 seperate Class Library Projects that each extend a common interface so that they all have the method
public static string execute(string data)
and are compiled and added to the database. They are loaded depending on the query I pass in and they go off and get data from different interfaces ie, LDAP, HTTP SOAP etc... and return me a simple string.
N
|||Lubomir,
A SQL CLR Project is just a project type in VS, which makes it easier for the developer to create and deploy assemblies to SQL Server. Under the cover the SQL CLR Project is just calling CREATE ASSEMBLY ... etc, in order to deploy.
Niels
Friday, March 9, 2012
Error 5020 after try to delete one of log files
OS: W2k sp2
I tried to move log files at one database from location A
to another location B. I first created new log fileB.ldf
for this database at locationB. Then shrank the original
log fileA.ldf as much as possible. Next I tried to
delete fileA from SQL Server EM -> properties ->
transaction log-> highligt fileA.ldf -> delete. But I got
error 5020: The primary data or log file cannot be removed
from a database.
How can I drop or move log files from database?
Thanks.Maggie,
First, detach the database using sp_detach_db after making sure that users
are not accessing it.Once done, the database is thus offline.Now copy the
.ldf file to location B.Attach the database using sp_attach_db, mentioning
the new location for .ldf.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Maggie" <seamorning@.yahoo.com> wrote in message
news:5d4901c35781$4df49c60$a001280a@.phx.gbl...
> Platform: SQL Server 2k with sp2
> OS: W2k sp2
> I tried to move log files at one database from location A
> to another location B. I first created new log fileB.ldf
> for this database at locationB. Then shrank the original
> log fileA.ldf as much as possible. Next I tried to
> delete fileA from SQL Server EM -> properties ->
> transaction log-> highligt fileA.ldf -> delete. But I got
> error 5020: The primary data or log file cannot be removed
> from a database.
> How can I drop or move log files from database?
> Thanks.|||Go to EM, right click the database, then Transaction Log tab, select the 2nd
log file, press Delete button.
You can't delete first log file, but other log files you can delete.
"Maggie" <seamorning@.yahoo.com> wrote in message
news:5e5d01c3578e$5cd34cb0$a001280a@.phx.gbl...
> How can just delete the extra log files from one
> location? I only want to keep one?
> >--Original Message--
> >Maggie,
> >
> >First, detach the database using sp_detach_db after
> making sure that users
> >are not accessing it.Once done, the database is thus
> offline.Now copy the
> >..ldf file to location B.Attach the database using
> sp_attach_db, mentioning
> >the new location for .ldf.
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Maggie" <seamorning@.yahoo.com> wrote in message
> >news:5d4901c35781$4df49c60$a001280a@.phx.gbl...
> >> Platform: SQL Server 2k with sp2
> >> OS: W2k sp2
> >> I tried to move log files at one database from location
> A
> >> to another location B. I first created new log
> fileB.ldf
> >> for this database at locationB. Then shrank the
> original
> >> log fileA.ldf as much as possible. Next I tried to
> >> delete fileA from SQL Server EM -> properties ->
> >> transaction log-> highligt fileA.ldf -> delete. But I
> got
> >> error 5020: The primary data or log file cannot be
> removed
> >> from a database.
> >>
> >> How can I drop or move log files from database?
> >>
> >> Thanks.
> >
> >
> >.
> >
error 4819
am getting :
error 4819 - Could not bulk insert. Bulk data stream was incorrectly
specified as sorted.
Anyone point me to why this might be happening? Its a severity 16, so user
caused and supposedly user fixable.
Duncan
"Duncan" <duncanl@.mcgrath.com.au> wrote in message
news:2kflhaF1ef7jU1@.uni-berlin.de...
> I have just created a snapshot manually and started the synch manualy and
I
> am getting :
> error 4819 - Could not bulk insert. Bulk data stream was incorrectly
> specified as sorted.
> Anyone point me to why this might be happening? Its a severity 16, so
user
> caused and supposedly user fixable.
> --
>
> Duncan
>
and I have checked sp_helpsort - they are both the same.
This started happening after I made some changes to the table structure, but
for no apparent reason.
|||Duncan,
sp_helpsort returns the default collation at the server level, while this is
probably a problem at the table level. I wonder did you make some changes to
the database collation? This is potentially picked up by the applied
snapshot, and it may be incompatible with the source data. Try checking that
under the article properties you are taking the table's collation, and this
will then override the default database one.
If there's still an issue, please post back listing the table collation and
the collation of the subscriber database, and stating if you are taking the
collation or not.
HTH,
Paul Ibison
Error 4305 - Log-Shipping
SQL 2000
Win 2k sp4
We have created a maintenance plan to ship one of our databases to a
secondary server. The initial snapshop shipped fine but we get error 4305
when trying to apply subsequent shipped tran logs.
The error says that the transaction log is too new.
We have another maintenance plan running on this DB that does backing
up(complete and tran logs) and it did do a tran-log backup after the
log-shipping snapshot. The log-shipping plan then made a tran log backup and
shipped it(which is too new).
I am trying to clarify if we can have two maintenance plans on the same
db(one for backup and one for log-shipping). Is this is what is causing this
error since they are overlapping.
I have not been able to find any info on this and am inclined to think they
are and I can only have oneplan that does all the backing up and the
log-shipping.
Can anyone confirm?
Thanks.
Hi
With log shipping, you can do a Full and Differential backup at any time,
but transaction logs are sacred. Only log shipping can do the logs, otherwise
you would loose transactions.
Regards
Mike
"Jez" wrote:
> Hi-
> SQL 2000
> Win 2k sp4
> We have created a maintenance plan to ship one of our databases to a
> secondary server. The initial snapshop shipped fine but we get error 4305
> when trying to apply subsequent shipped tran logs.
> The error says that the transaction log is too new.
> We have another maintenance plan running on this DB that does backing
> up(complete and tran logs) and it did do a tran-log backup after the
> log-shipping snapshot. The log-shipping plan then made a tran log backup and
> shipped it(which is too new).
> I am trying to clarify if we can have two maintenance plans on the same
> db(one for backup and one for log-shipping). Is this is what is causing this
> error since they are overlapping.
> I have not been able to find any info on this and am inclined to think they
> are and I can only have oneplan that does all the backing up and the
> log-shipping.
> Can anyone confirm?
> Thanks.
>
>
|||Thanks Mike for quick response
jez.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BD6B7EE8-97DA-4522-B201-0494A27C54F0@.microsoft.com...[vbcol=seagreen]
> Hi
> With log shipping, you can do a Full and Differential backup at any time,
> but transaction logs are sacred. Only log shipping can do the logs,
> otherwise
> you would loose transactions.
> Regards
> Mike
> "Jez" wrote:
Error 4305 - Log-Shipping
SQL 2000
Win 2k sp4
We have created a maintenance plan to ship one of our databases to a
secondary server. The initial snapshop shipped fine but we get error 4305
when trying to apply subsequent shipped tran logs.
The error says that the transaction log is too new.
We have another maintenance plan running on this DB that does backing
up(complete and tran logs) and it did do a tran-log backup after the
log-shipping snapshot. The log-shipping plan then made a tran log backup and
shipped it(which is too new).
I am trying to clarify if we can have two maintenance plans on the same
db(one for backup and one for log-shipping). Is this is what is causing this
error since they are overlapping.
I have not been able to find any info on this and am inclined to think they
are and I can only have oneplan that does all the backing up and the
log-shipping.
Can anyone confirm?
Thanks.Hi
With log shipping, you can do a Full and Differential backup at any time,
but transaction logs are sacred. Only log shipping can do the logs, otherwis
e
you would loose transactions.
Regards
Mike
"Jez" wrote:
> Hi-
> SQL 2000
> Win 2k sp4
> We have created a maintenance plan to ship one of our databases to a
> secondary server. The initial snapshop shipped fine but we get error 4305
> when trying to apply subsequent shipped tran logs.
> The error says that the transaction log is too new.
> We have another maintenance plan running on this DB that does backing
> up(complete and tran logs) and it did do a tran-log backup after the
> log-shipping snapshot. The log-shipping plan then made a tran log backup a
nd
> shipped it(which is too new).
> I am trying to clarify if we can have two maintenance plans on the same
> db(one for backup and one for log-shipping). Is this is what is causing th
is
> error since they are overlapping.
> I have not been able to find any info on this and am inclined to think the
y
> are and I can only have oneplan that does all the backing up and the
> log-shipping.
> Can anyone confirm?
> Thanks.
>
>|||Thanks Mike for quick response
jez.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BD6B7EE8-97DA-4522-B201-0494A27C54F0@.microsoft.com...[vbcol=seagreen]
> Hi
> With log shipping, you can do a Full and Differential backup at any time,
> but transaction logs are sacred. Only log shipping can do the logs,
> otherwise
> you would loose transactions.
> Regards
> Mike
> "Jez" wrote:
>
Error 4305 - Log-Shipping
SQL 2000
Win 2k sp4
We have created a maintenance plan to ship one of our databases to a
secondary server. The initial snapshop shipped fine but we get error 4305
when trying to apply subsequent shipped tran logs.
The error says that the transaction log is too new.
We have another maintenance plan running on this DB that does backing
up(complete and tran logs) and it did do a tran-log backup after the
log-shipping snapshot. The log-shipping plan then made a tran log backup and
shipped it(which is too new).
I am trying to clarify if we can have two maintenance plans on the same
db(one for backup and one for log-shipping). Is this is what is causing this
error since they are overlapping.
I have not been able to find any info on this and am inclined to think they
are and I can only have oneplan that does all the backing up and the
log-shipping.
Can anyone confirm?
Thanks.Hi
With log shipping, you can do a Full and Differential backup at any time,
but transaction logs are sacred. Only log shipping can do the logs, otherwise
you would loose transactions.
Regards
Mike
"Jez" wrote:
> Hi-
> SQL 2000
> Win 2k sp4
> We have created a maintenance plan to ship one of our databases to a
> secondary server. The initial snapshop shipped fine but we get error 4305
> when trying to apply subsequent shipped tran logs.
> The error says that the transaction log is too new.
> We have another maintenance plan running on this DB that does backing
> up(complete and tran logs) and it did do a tran-log backup after the
> log-shipping snapshot. The log-shipping plan then made a tran log backup and
> shipped it(which is too new).
> I am trying to clarify if we can have two maintenance plans on the same
> db(one for backup and one for log-shipping). Is this is what is causing this
> error since they are overlapping.
> I have not been able to find any info on this and am inclined to think they
> are and I can only have oneplan that does all the backing up and the
> log-shipping.
> Can anyone confirm?
> Thanks.
>
>|||Thanks Mike for quick response
jez.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BD6B7EE8-97DA-4522-B201-0494A27C54F0@.microsoft.com...
> Hi
> With log shipping, you can do a Full and Differential backup at any time,
> but transaction logs are sacred. Only log shipping can do the logs,
> otherwise
> you would loose transactions.
> Regards
> Mike
> "Jez" wrote:
>> Hi-
>> SQL 2000
>> Win 2k sp4
>> We have created a maintenance plan to ship one of our databases to a
>> secondary server. The initial snapshop shipped fine but we get error 4305
>> when trying to apply subsequent shipped tran logs.
>> The error says that the transaction log is too new.
>> We have another maintenance plan running on this DB that does backing
>> up(complete and tran logs) and it did do a tran-log backup after the
>> log-shipping snapshot. The log-shipping plan then made a tran log backup
>> and
>> shipped it(which is too new).
>> I am trying to clarify if we can have two maintenance plans on the same
>> db(one for backup and one for log-shipping). Is this is what is causing
>> this
>> error since they are overlapping.
>> I have not been able to find any info on this and am inclined to think
>> they
>> are and I can only have oneplan that does all the backing up and the
>> log-shipping.
>> Can anyone confirm?
>> Thanks.
>>
Wednesday, March 7, 2012
Error 40: could not open a connection to Mssql server
Hi,
I'm using sql server 2005 express edition. I have created a database using sql server management studio express edition. Now I'm trying to connect it in visual studio 2005. It show following error.
An error has occurred while establishing a connection to the server. When connections to SQL 5erver 2005, this failure may be caused by the fact under the server's default settings SQL Server does not allow remote connections, (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server)
I have enables named pipes from Sql services configuration manager.
Hi,
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
Is just a basic connectivity error meaning the client could not connect to the target SQL Server. So just follow the basic connectivity troubleshooting guidelines on our SQL Protocols blog, see:
SQL Server 2005 Connectivity Issue Troubleshoot - Part I
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
and
SQL Server 2005 Connectivity Issue Troubleshoot - Part II
http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx
This should help you debug the problem.
Sunday, February 19, 2012
error 241: Syntax error converting datetime from character string
i've created a stored procedure to make a report by calling it from a website.
I get the message error "241: Syntax error converting datetime from character string" all the time, i tryed some converting things but nothig works, probably it is me that isn't working but i hope someone can help me.
The code i use is:
CREATE proc CP_Cashbox @.mID varchar,@.startdate datetime,@.enddate datetime
as
set dateformat dmy
go
declare @.startdate as varchar
declare @.enddate as varchar
--print "query aan het uitvoeren"
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = '@.mID' and njdate between '@.startdate' and '@.enddate'
GO
Thanx in front
CyaOriginally posted by Wimmo
Hi All, can someone help me,
i've created a stored procedure to make a report by calling it from a website.
I get the message error "241: Syntax error converting datetime from character string" all the time, i tryed some converting things but nothig works, probably it is me that isn't working but i hope someone can help me.
The code i use is:
CREATE proc CP_Cashbox @.mID varchar,@.startdate datetime,@.enddate datetime
as
set dateformat dmy
go
declare @.startdate as varchar
declare @.enddate as varchar
--print "query aan het uitvoeren"
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = '@.mID' and njdate between '@.startdate' and '@.enddate'
GO
Thanx in front
Cya
Simple ... just run this command
sp_helptext cp_cashbox
and you will understand.|||Thanx, i tried what you said but it returns the sp code,
which i edited to
CREATE proc CP_Cashbox @.mID varchar,@.startdate datetime,@.enddate datetime
as
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = '@.mID' and njdate between '@.startdate' and '@.enddate'
but when i exec it now it returns with the same error as before
the exec command i use is:
exec CP_cashbox @.mID = '10001', @.startdate = '01-01-2000', @.enddate = '01-01-2004'
go
can you tell me what i do wrong?
Thanx
Regards Wim|||Originally posted by Wimmo
Thanx, i tried what you said but it returns the sp code,
which i edited to
CREATE proc CP_Cashbox @.mID varchar,@.startdate datetime,@.enddate datetime
as
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = '@.mID' and njdate between '@.startdate' and '@.enddate'
but when i exec it now it returns with the same error as before
the exec command i use is:
exec CP_cashbox @.mID = '10001', @.startdate = '01-01-2000', @.enddate = '01-01-2004'
go
can you tell me what i do wrong?
Thanx
Regards Wim
Sorry ... should have seen it first time around
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = @.mID and njdate between @.startdate and @.enddate|||thanx that solves the error,
but the strangest thing happened,
when i exec the sp wit the next code:
exec CP_cashbox @.mID = '10001',@.startdate ='01-01-2000',@.enddate = '01-01-2004'
it returns with a Null value
now when i make a query with the same values it returns the correct value. the query i use is :
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = '10001' and njdate between '01-01-2000' and '01-01-2004'
What am i doing wrong
Thanx for your precious time
Greet Wim|||try this :
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = @.mID and convert(varchar,njdate,121) between convert(varchar,@.startdate,121) and convert(varchar,@.enddate,121)|||Originally posted by Enigma
try this :
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where machineID = @.mID and convert(varchar,njdate,121) between convert(varchar,@.startdate,121) and convert(varchar,@.enddate,121)
it returns the annoying NULL value again|||Can you paste the DDL of the table ...
CREATE proc CP_Cashbox @.mID varchar(x),@.startdate datetime,@.enddate datetime
where x is the width of the machine_id column in your table|||Originally posted by Enigma
Can you paste the DDL of the table ...
CREATE proc CP_Cashbox @.mID varchar(x),@.startdate datetime,@.enddate datetime
where x is the width of the machine_id column in your table
What is DDL?
the with of the machin_id column is 10|||So .. this should work for you
CREATE proc CP_Cashbox
@.mID varchar(10),
@.startdate datetime,
@.enddate datetime
as
select sum(moneyout) / sum(moneyin)*100 as cashbox
from dbo.total
where
machineID = @.mID
and convert(varchar,njdate,121)
between convert(varchar,@.startdate,121)
and convert(varchar,@.enddate,121)|||Thanx alot man i inserted the with of the machine_id column and now it is working. Thanx to your help i really lose some stress today.
Greet Wim:) :) :cool:|||DBA's dont take stress .. they are some of the coolest persons I have seen ... i personally havent seen a dba fuming in public.|||You are completely right, and i am kinda new to this stuf so i am in the proces of becoming on of the coolest!|||Any time you need help you can rely on some of the best dba's i ve known on this site ... especially ... Brett Kaiser, blindman, rnealjr and satya
i myself rely a lot on this site in emergencies|||Originally posted by Enigma
Any time you need help you can rely on some of the best dba's i ve known on this site ... especially ... Brett Kaiser, blindman, rnealjr and satya
i myself rely a lot on this site in emergencies
Thanx for the tip, i think i gonna need some more help in the near future.
Friday, February 17, 2012
Error 22022
Server 2000, and I have created the job to perform the
backups. But, when I try to run the backup to test it, I
get the following error:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
I have checked, SQLServerAgent is running and if I stop
and start SQLServerAgent I get the same error.
What is wrong and how do I fix it?Some things to check - Are you running SQL Server in fiber
mode (lightweight pooling)? Have you ensured that SQL Agent
is truly running and not hung up in a starting status? Have
you checked your sqlagent.out file?
In addition to lightweight pooling being enabled, Agent can
also get hung up due to a bad mail profile.
-Sue
On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
>I'm attempting to create a backup schedule for my SQL
>Server 2000, and I have created the job to perform the
>backups. But, when I try to run the backup to test it, I
>get the following error:
>Error 22022: SQLServerAgent is not currently running so it
>cannot be notified of this action.
>I have checked, SQLServerAgent is running and if I stop
>and start SQLServerAgent I get the same error.
>What is wrong and how do I fix it?|||Thanks Sue for your reply. I have checked and SQL Mail is
not configured, but I have checked on an older NT systems
and its SQL Mail is not configured either and the backups
work fine. My current system is Windows 2003 server,
could this be causing the problem? Also, is there a way
to configure MSServerAgent to not bother with mail? I
would rather have it configured so no mail is sent out.
Ciao,
Rob.
>--Original Message--
>Some things to check - Are you running SQL Server in fiber
>mode (lightweight pooling)? Have you ensured that SQL
Agent
>is truly running and not hung up in a starting status?
Have
>you checked your sqlagent.out file?
>In addition to lightweight pooling being enabled, Agent
can
>also get hung up due to a bad mail profile.
>-Sue
>On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
><anonymous@.discussions.microsoft.com> wrote:
>>I'm attempting to create a backup schedule for my SQL
>>Server 2000, and I have created the job to perform the
>>backups. But, when I try to run the backup to test it,
I
>>get the following error:
>>Error 22022: SQLServerAgent is not currently running so
it
>>cannot be notified of this action.
>>I have checked, SQLServerAgent is running and if I stop
>>and start SQLServerAgent I get the same error.
>>What is wrong and how do I fix it?
>.
>|||If you don't set a mail profile for SQL Agent then it won't
do anything with mail.
In terms of SQL Agent, you still need to check if the
service is actually running (vs starting), if your server is
configured for lightweight pooling and you need to check
your sqlagent.out file for any errors or problems in
starting SQL Agent.
-Sue
On Wed, 12 May 2004 10:12:18 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
>Thanks Sue for your reply. I have checked and SQL Mail is
>not configured, but I have checked on an older NT systems
>and its SQL Mail is not configured either and the backups
>work fine. My current system is Windows 2003 server,
>could this be causing the problem? Also, is there a way
>to configure MSServerAgent to not bother with mail? I
>would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
>>--Original Message--
>>Some things to check - Are you running SQL Server in fiber
>>mode (lightweight pooling)? Have you ensured that SQL
>Agent
>>is truly running and not hung up in a starting status?
>Have
>>you checked your sqlagent.out file?
>>In addition to lightweight pooling being enabled, Agent
>can
>>also get hung up due to a bad mail profile.
>>-Sue
>>On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
>><anonymous@.discussions.microsoft.com> wrote:
>>I'm attempting to create a backup schedule for my SQL
>>Server 2000, and I have created the job to perform the
>>backups. But, when I try to run the backup to test it,
>I
>>get the following error:
>>Error 22022: SQLServerAgent is not currently running so
>it
>>cannot be notified of this action.
>>I have checked, SQLServerAgent is running and if I stop
>>and start SQLServerAgent I get the same error.
>>What is wrong and how do I fix it?
>>.|||Hello Rob,
Did you ever get this problem figured out? I'm having the exact same issue and I have verified that SQL Agent is running but still having the error.
Let me know.
Regards,
-greg
"Rob Simac" wrote:
> Thanks Sue for your reply. I have checked and SQL Mail is
> not configured, but I have checked on an older NT systems
> and its SQL Mail is not configured either and the backups
> work fine. My current system is Windows 2003 server,
> could this be causing the problem? Also, is there a way
> to configure MSServerAgent to not bother with mail? I
> would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
> >--Original Message--
> >Some things to check - Are you running SQL Server in fiber
> >mode (lightweight pooling)? Have you ensured that SQL
> Agent
> >is truly running and not hung up in a starting status?
> Have
> >you checked your sqlagent.out file?
> >In addition to lightweight pooling being enabled, Agent
> can
> >also get hung up due to a bad mail profile.
> >
> >-Sue
> >
> >On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
> ><anonymous@.discussions.microsoft.com> wrote:
> >
> >>I'm attempting to create a backup schedule for my SQL
> >>Server 2000, and I have created the job to perform the
> >>backups. But, when I try to run the backup to test it,
> I
> >>get the following error:
> >>
> >>Error 22022: SQLServerAgent is not currently running so
> it
> >>cannot be notified of this action.
> >>
> >>I have checked, SQLServerAgent is running and if I stop
> >>and start SQLServerAgent I get the same error.
> >>
> >>What is wrong and how do I fix it?
> >
> >.
> >
>
Error 22022
Server 2000, and I have created the job to perform the
backups. But, when I try to run the backup to test it, I
get the following error:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
I have checked, SQLServerAgent is running and if I stop
and start SQLServerAgent I get the same error.
What is wrong and how do I fix it?
Hi Rob,
What is the startup account for the SQLAgent ?
What is the account used to create the Job ?
Try changing the Account for Job to SA and then try.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Error 22022
Server 2000, and I have created the job to perform the
backups. But, when I try to run the backup to test it, I
get the following error:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
I have checked, SQLServerAgent is running and if I stop
and start SQLServerAgent I get the same error.
What is wrong and how do I fix it?
Some things to check - Are you running SQL Server in fiber
mode (lightweight pooling)? Have you ensured that SQL Agent
is truly running and not hung up in a starting status? Have
you checked your sqlagent.out file?
In addition to lightweight pooling being enabled, Agent can
also get hung up due to a bad mail profile.
-Sue
On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
>I'm attempting to create a backup schedule for my SQL
>Server 2000, and I have created the job to perform the
>backups. But, when I try to run the backup to test it, I
>get the following error:
>Error 22022: SQLServerAgent is not currently running so it
>cannot be notified of this action.
>I have checked, SQLServerAgent is running and if I stop
>and start SQLServerAgent I get the same error.
>What is wrong and how do I fix it?
|||Thanks Sue for your reply. I have checked and SQL Mail is
not configured, but I have checked on an older NT systems
and its SQL Mail is not configured either and the backups
work fine. My current system is Windows 2003 server,
could this be causing the problem? Also, is there a way
to configure MSServerAgent to not bother with mail? I
would rather have it configured so no mail is sent out.
Ciao,
Rob.
>--Original Message--
>Some things to check - Are you running SQL Server in fiber
>mode (lightweight pooling)? Have you ensured that SQL
Agent
>is truly running and not hung up in a starting status?
Have
>you checked your sqlagent.out file?
>In addition to lightweight pooling being enabled, Agent
can[vbcol=seagreen]
>also get hung up due to a bad mail profile.
>-Sue
>On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
><anonymous@.discussions.microsoft.com> wrote:
I[vbcol=seagreen]
it
>.
>
|||If you don't set a mail profile for SQL Agent then it won't
do anything with mail.
In terms of SQL Agent, you still need to check if the
service is actually running (vs starting), if your server is
configured for lightweight pooling and you need to check
your sqlagent.out file for any errors or problems in
starting SQL Agent.
-Sue
On Wed, 12 May 2004 10:12:18 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks Sue for your reply. I have checked and SQL Mail is
>not configured, but I have checked on an older NT systems
>and its SQL Mail is not configured either and the backups
>work fine. My current system is Windows 2003 server,
>could this be causing the problem? Also, is there a way
>to configure MSServerAgent to not bother with mail? I
>would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
>Agent
>Have
>can
>I
>it
|||Hello Rob,
Did you ever get this problem figured out? I'm having the exact same issue and I have verified that SQL Agent is running but still having the error.
Let me know.
Regards,
-greg
"Rob Simac" wrote:
> Thanks Sue for your reply. I have checked and SQL Mail is
> not configured, but I have checked on an older NT systems
> and its SQL Mail is not configured either and the backups
> work fine. My current system is Windows 2003 server,
> could this be causing the problem? Also, is there a way
> to configure MSServerAgent to not bother with mail? I
> would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
> Agent
> Have
> can
> I
> it
>
Error 22022
Server 2000, and I have created the job to perform the
backups. But, when I try to run the backup to test it, I
get the following error:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
I have checked, SQLServerAgent is running and if I stop
and start SQLServerAgent I get the same error.
What is wrong and how do I fix it?Some things to check - Are you running SQL Server in fiber
mode (lightweight pooling)? Have you ensured that SQL Agent
is truly running and not hung up in a starting status? Have
you checked your sqlagent.out file?
In addition to lightweight pooling being enabled, Agent can
also get hung up due to a bad mail profile.
-Sue
On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
>I'm attempting to create a backup schedule for my SQL
>Server 2000, and I have created the job to perform the
>backups. But, when I try to run the backup to test it, I
>get the following error:
>Error 22022: SQLServerAgent is not currently running so it
>cannot be notified of this action.
>I have checked, SQLServerAgent is running and if I stop
>and start SQLServerAgent I get the same error.
>What is wrong and how do I fix it?|||Thanks Sue for your reply. I have checked and SQL Mail is
not configured, but I have checked on an older NT systems
and its SQL Mail is not configured either and the backups
work fine. My current system is Windows 2003 server,
could this be causing the problem? Also, is there a way
to configure MSServerAgent to not bother with mail? I
would rather have it configured so no mail is sent out.
Ciao,
Rob.
>--Original Message--
>Some things to check - Are you running SQL Server in fiber
>mode (lightweight pooling)? Have you ensured that SQL
Agent
>is truly running and not hung up in a starting status?
Have
>you checked your sqlagent.out file?
>In addition to lightweight pooling being enabled, Agent
can
>also get hung up due to a bad mail profile.
>-Sue
>On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
><anonymous@.discussions.microsoft.com> wrote:
>
I[vbcol=seagreen]
it[vbcol=seagreen]
>.
>|||If you don't set a mail profile for SQL Agent then it won't
do anything with mail.
In terms of SQL Agent, you still need to check if the
service is actually running (vs starting), if your server is
configured for lightweight pooling and you need to check
your sqlagent.out file for any errors or problems in
starting SQL Agent.
-Sue
On Wed, 12 May 2004 10:12:18 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks Sue for your reply. I have checked and SQL Mail is
>not configured, but I have checked on an older NT systems
>and its SQL Mail is not configured either and the backups
>work fine. My current system is Windows 2003 server,
>could this be causing the problem? Also, is there a way
>to configure MSServerAgent to not bother with mail? I
>would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
>
>Agent
>Have
>can
>I
>it|||Hello Rob,
Did you ever get this problem figured out? I'm having the exact same issue
and I have verified that SQL Agent is running but still having the error.
Let me know.
Regards,
-greg
"Rob Simac" wrote:
> Thanks Sue for your reply. I have checked and SQL Mail is
> not configured, but I have checked on an older NT systems
> and its SQL Mail is not configured either and the backups
> work fine. My current system is Windows 2003 server,
> could this be causing the problem? Also, is there a way
> to configure MSServerAgent to not bother with mail? I
> would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
>
> Agent
> Have
> can
> I
> it
>
Wednesday, February 15, 2012
Error 208: Invaild object name msdb.dbo.MSdistpublishers
What I would like to do is delete all references to previous publications and subscribers and create them all over again. But it does not allow me to create new or delete old publishers or subscribers. I get this and other errors...
Error 208: Invaild object name 'msdb.dbo.MSdistpublishers'
There is in fact no MSdistpublishers table in msdb because it is a new db. Can anyone help me reverse out of this?
Thanks in advance.
SteveIn future make sure to have regular backups for SYSTEM databases too.
I suggest to delete the replication and recreate it freshly which will re-enable the task. Make sure to check all jobs and tasks are scheduled properly after the MSDB restore.
Refer to SQL error log for any information.