Missing dll file: receive

Showing posts with label receive. Show all posts

Monday, March 26, 2012

model database locked

I receive the following message in the Event log when
trying to start SQLSERVER service...
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 11/06/2004
Time: 17:45:05
User: N/A
Computer: NWK-S-SQL
Description:
17052 :
Database 'model' cannot be opened. It is in the middle of
a restore.
Data:
0000: 9c 42 00 00 0a 00 00 00 œB.....
0008: 0a 00 00 00 4e 00 57 00 ...N.W.
0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
0018: 53 00 51 00 4c 00 00 00 S.Q.L...
0020: 00 00 00 00 ...
This is preventing the service from starting... any
suggestions on how to resolve this? Unfortunately I do not
know how the database got into this state
After a reboot of the server, several databases came back
listed as 'loading' (in a restore mode) for no aparent
reason... after a further reboot... this!
all suggestions greatfully recieved
cheers
KeithHi,
If the model database is in middle of restore you can start sql server in
mimimal mode or Single user mode. To over come
thisadd the trace flag "-T3608" in the startup parameters. This trace flag
will
bypass recovery of databases except master. You should be able to start SQL
Server after this. After this try to restore the model
database from a backup.
(-T3608 can be added from control panel -- Admin tools-- services -- MSSQL
Server --Stop MSSQL Service-- In the parameter give the values -T3608--
Start MSSQL Server service)
If you still have issues then; stop SQL server service and then:-
1. COpy the exising model.mdf and modellog.ldf to a safe place
2. Overwriting model.mdf and modellog.ldf with the files in SQL Server CD,
and then try to startup the service.
Thanks
Hari
MCDBA
"Keith Newton" <keith.newton@.riba-enterprises.com> wrote in message
news:1b12c01c44fe1$fa128490$a601280a@.phx
.gbl...
> I receive the following message in the Event log when
> trying to start SQLSERVER service...
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 11/06/2004
> Time: 17:45:05
> User: N/A
> Computer: NWK-S-SQL
> Description:
> 17052 :
> Database 'model' cannot be opened. It is in the middle of
> a restore.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 œB.....
> 0008: 0a 00 00 00 4e 00 57 00 ...N.W.
> 0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
> 0018: 53 00 51 00 4c 00 00 00 S.Q.L...
> 0020: 00 00 00 00 ...
> This is preventing the service from starting... any
> suggestions on how to resolve this? Unfortunately I do not
> know how the database got into this state
> After a reboot of the server, several databases came back
> listed as 'loading' (in a restore mode) for no aparent
> reason... after a further reboot... this!
> all suggestions greatfully recieved
> cheers
> Keith|||Hi,
If the model database is in middle of restore you can start sql server in
mimimal mode or Single user mode. To over come
thisadd the trace flag "-T3608" in the startup parameters. This trace flag
will
bypass recovery of databases except master. You should be able to start SQL
Server after this. After this try to restore the model
database from a backup.
(-T3608 can be added from control panel -- Admin tools-- services -- MSSQL
Server --Stop MSSQL Service-- In the parameter give the values -T3608--
Start MSSQL Server service)
If you still have issues then; stop SQL server service and then:-
1. COpy the exising model.mdf and modellog.ldf to a safe place
2. Overwriting model.mdf and modellog.ldf with the files in SQL Server CD,
and then try to startup the service.
Thanks
Hari
MCDBA
"Keith Newton" <keith.newton@.riba-enterprises.com> wrote in message
news:1b12c01c44fe1$fa128490$a601280a@.phx
.gbl...
> I receive the following message in the Event log when
> trying to start SQLSERVER service...
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 11/06/2004
> Time: 17:45:05
> User: N/A
> Computer: NWK-S-SQL
> Description:
> 17052 :
> Database 'model' cannot be opened. It is in the middle of
> a restore.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 œB.....
> 0008: 0a 00 00 00 4e 00 57 00 ...N.W.
> 0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
> 0018: 53 00 51 00 4c 00 00 00 S.Q.L...
> 0020: 00 00 00 00 ...
> This is preventing the service from starting... any
> suggestions on how to resolve this? Unfortunately I do not
> know how the database got into this state
> After a reboot of the server, several databases came back
> listed as 'loading' (in a restore mode) for no aparent
> reason... after a further reboot... this!
> all suggestions greatfully recieved
> cheers
> Keith

model database locked

Friday, March 23, 2012

MMC DataBase Properties Error

Hello.
In SQL Server 2000, when I right click on a database and then select
Properties,
I receive the following error message: "Microsoft Management Console has
encountered a problem and needs to close".
I tried a couple of databases with the same results and also rebooted but
that didn't resolve the issue.
Any suggestions will be greatly appreciated :-)
Rita
On May 18, 5:19 pm, RitaG <R...@.discussions.microsoft.com> wrote:
> Hello.
> In SQL Server 2000, when I right click on a database and then select
> Properties,
> I receive the following error message: "Microsoft Management Console has
> encountered a problem and needs to close".
> I tried a couple of databases with the same results and also rebooted but
> that didn't resolve the issue.
> Any suggestions will be greatly appreciated :-)
> Rita
You may need to uninstall and reinstall client tools if the databases
are fine. This has happened to me and I was working with client tools
on my desktop viewing a registered server instance. I never found out
the issue, but reinstalling the client tools did the trick.
Hope this helps.
Kristina
|||Thanks so much Kristina - I'm going to try that now!
"Kristina" wrote:

> On May 18, 5:19 pm, RitaG <R...@.discussions.microsoft.com> wrote:
> You may need to uninstall and reinstall client tools if the databases
> are fine. This has happened to me and I was working with client tools
> on my desktop viewing a registered server instance. I never found out
> the issue, but reinstalling the client tools did the trick.
> Hope this helps.
> Kristina
>

MMC DataBase Properties Error

Hello.
In SQL Server 2000, when I right click on a database and then select
Properties,
I receive the following error message: "Microsoft Management Console has
encountered a problem and needs to close".
I tried a couple of databases with the same results and also rebooted but
that didn't resolve the issue.
Any suggestions will be greatly appreciated :-)
RitaOn May 18, 5:19 pm, RitaG <R...@.discussions.microsoft.com> wrote:
> Hello.
> In SQL Server 2000, when I right click on a database and then select
> Properties,
> I receive the following error message: "Microsoft Management Console has
> encountered a problem and needs to close".
> I tried a couple of databases with the same results and also rebooted but
> that didn't resolve the issue.
> Any suggestions will be greatly appreciated :-)
> Rita
You may need to uninstall and reinstall client tools if the databases
are fine. This has happened to me and I was working with client tools
on my desktop viewing a registered server instance. I never found out
the issue, but reinstalling the client tools did the trick.
Hope this helps.
Kristina|||Thanks so much Kristina - I'm going to try that now!
"Kristina" wrote:
> On May 18, 5:19 pm, RitaG <R...@.discussions.microsoft.com> wrote:
> > Hello.
> >
> > In SQL Server 2000, when I right click on a database and then select
> > Properties,
> > I receive the following error message: "Microsoft Management Console has
> > encountered a problem and needs to close".
> >
> > I tried a couple of databases with the same results and also rebooted but
> > that didn't resolve the issue.
> >
> > Any suggestions will be greatly appreciated :-)
> >
> > Rita
> You may need to uninstall and reinstall client tools if the databases
> are fine. This has happened to me and I was working with client tools
> on my desktop viewing a registered server instance. I never found out
> the issue, but reinstalling the client tools did the trick.
> Hope this helps.
> Kristina
>

MMC DataBase Properties Error

Hello.
In SQL Server 2000, when I right click on a database and then select
Properties,
I receive the following error message: "Microsoft Management Console has
encountered a problem and needs to close".
I tried a couple of databases with the same results and also rebooted but
that didn't resolve the issue.
Any suggestions will be greatly appreciated :-)
RitaOn May 18, 5:19 pm, RitaG <R...@.discussions.microsoft.com> wrote:
> Hello.
> In SQL Server 2000, when I right click on a database and then select
> Properties,
> I receive the following error message: "Microsoft Management Console has
> encountered a problem and needs to close".
> I tried a couple of databases with the same results and also rebooted but
> that didn't resolve the issue.
> Any suggestions will be greatly appreciated :-)
> Rita
You may need to uninstall and reinstall client tools if the databases
are fine. This has happened to me and I was working with client tools
on my desktop viewing a registered server instance. I never found out
the issue, but reinstalling the client tools did the trick.
Hope this helps.
Kristina|||Thanks so much Kristina - I'm going to try that now!
"Kristina" wrote:

> On May 18, 5:19 pm, RitaG <R...@.discussions.microsoft.com> wrote:
> You may need to uninstall and reinstall client tools if the databases
> are fine. This has happened to me and I was working with client tools
> on my desktop viewing a registered server instance. I never found out
> the issue, but reinstalling the client tools did the trick.
> Hope this helps.
> Kristina
>sql

Friday, March 9, 2012

missing SP when I query for it's text

I have code below to extract a table name and a verb. I receive 4 rows
back. I think fine. Unfortunatly my programmer says that the SP in
question is not part of the return set.
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%PreNote_Transaction_Lookup%'
and Routine_definition like '%insert%'
I change the query to fit the same code he is looking at:
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
and I get 0 rows back.
This is from the SP itself:
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where
Prenote_Transaction_ID = @.Prenote_Trans_ID
I have even put insert into in all caps. Still no rows returned?
Any ideas?Below work fine on my machine:
USE tempdb
GO
CREATE PROC A
AS
DECLARE @.Prenote_Trans_ID int
DECLARE @.transaction_id int
DECLARE @.Count int
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID =@.Prenote_Trans_ID
END
GO
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
Is your database case sensitive? Do you have > 4000 charactes in the procedure?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"_Stephen" <srussell@.electracash.com> wrote in message
news:O%23Ee6sHRGHA.252@.TK2MSFTNGP10.phx.gbl...
>I have code below to extract a table name and a verb. I receive 4 rows back. I think fine.
>Unfortunatly my programmer says that the SP in question is not part of the return set.
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%PreNote_Transaction_Lookup%'
> and Routine_definition like '%insert%'
> I change the query to fit the same code he is looking at:
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%insert into PreNote_Transaction_Lookup%'
> and I get 0 rows back.
> This is from the SP itself:
> IF @.Prenote_Trans_ID > 0
> BEGIN
> INSERT INTO PreNote_Transaction_Lookup Values (@.Prenote_Trans_ID,null,cast(@.transaction_id as
> varchar(10)))
> Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID => @.Prenote_Trans_ID
>
> I have even put insert into in all caps. Still no rows returned?
> Any ideas?
>

missing SP when I query for it's text

I have code below to extract a table name and a verb. I receive 4 rows
back. I think fine. Unfortunatly my programmer says that the SP in
question is not part of the return set.
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%PreNote_Transaction_Lookup%'
and Routine_definition like '%insert%'
I change the query to fit the same code he is looking at:
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
and I get 0 rows back.
This is from the SP itself:
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where
Prenote_Transaction_ID = @.Prenote_Trans_ID
I have even put insert into in all caps. Still no rows returned?
Any ideas?
Below work fine on my machine:
USE tempdb
GO
CREATE PROC A
AS
DECLARE @.Prenote_Trans_ID int
DECLARE @.transaction_id int
DECLARE @.Count int
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transaction_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID =
@.Prenote_Trans_ID
END
GO
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
Is your database case sensitive? Do you have > 4000 charactes in the procedure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"_Stephen" <srussell@.electracash.com> wrote in message
news:O%23Ee6sHRGHA.252@.TK2MSFTNGP10.phx.gbl...
>I have code below to extract a table name and a verb. I receive 4 rows back. I think fine.
>Unfortunatly my programmer says that the SP in question is not part of the return set.
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%PreNote_Transaction_Lookup%'
> and Routine_definition like '%insert%'
> I change the query to fit the same code he is looking at:
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%insert into PreNote_Transaction_Lookup%'
> and I get 0 rows back.
> This is from the SP itself:
> IF @.Prenote_Trans_ID > 0
> BEGIN
> INSERT INTO PreNote_Transaction_Lookup Values (@.Prenote_Trans_ID,null,cast(@.transaction_id as
> varchar(10)))
> Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Transaction_ID =
> @.Prenote_Trans_ID
>
> I have even put insert into in all caps. Still no rows returned?
> Any ideas?
>

missing SP when I query for it's text

I have code below to extract a table name and a verb. I receive 4 rows
back. I think fine. Unfortunatly my programmer says that the SP in
question is not part of the return set.
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%PreNote_Transaction_Lookup%'
and Routine_definition like '%insert%'
I change the query to fit the same code he is looking at:
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
and I get 0 rows back.
This is from the SP itself:
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transactio
n_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where
Prenote_Transaction_ID = @.Prenote_Trans_ID
I have even put insert into in all caps. Still no rows returned?
Any ideas?Below work fine on my machine:
USE tempdb
GO
CREATE PROC A
AS
DECLARE @.Prenote_Trans_ID int
DECLARE @.transaction_id int
DECLARE @.Count int
IF @.Prenote_Trans_ID > 0
BEGIN
INSERT INTO PreNote_Transaction_Lookup Values
(@.Prenote_Trans_ID,null,cast(@.transactio
n_id as varchar(10)))
Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Trans
action_ID =
@.Prenote_Trans_ID
END
GO
Select routine_name from INFORMATION_SCHEMA.ROUTINES where
Routine_definition like '%insert into PreNote_Transaction_Lookup%'
Is your database case sensitive? Do you have > 4000 charactes in the procedu
re?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"_Stephen" <srussell@.electracash.com> wrote in message
news:O%23Ee6sHRGHA.252@.TK2MSFTNGP10.phx.gbl...
>I have code below to extract a table name and a verb. I receive 4 rows bac
k. I think fine.
>Unfortunatly my programmer says that the SP in question is not part of the
return set.
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%PreNote_Transaction_Lookup%'
> and Routine_definition like '%insert%'
> I change the query to fit the same code he is looking at:
> Select routine_name from INFORMATION_SCHEMA.ROUTINES where
> Routine_definition like '%insert into PreNote_Transaction_Lookup%'
> and I get 0 rows back.
> This is from the SP itself:
> IF @.Prenote_Trans_ID > 0
> BEGIN
> INSERT INTO PreNote_Transaction_Lookup Values (@.Prenote_Trans_ID,null,cast
(@.transaction_id as
> varchar(10)))
> Select @.Count = count(1) from PreNote_Transaction_Lookup where Prenote_Tra
nsaction_ID =
> @.Prenote_Trans_ID
>
> I have even put insert into in all caps. Still no rows returned?
> Any ideas?
>

Wednesday, March 7, 2012

Missing parameter on postback

II6.0
SQL server 2005
I have a report with toggle option, it work fine except the toggle, when
click on + I receive error rsReportParameterValueNotSet.
The URL of toggle is construct without parameter needs to produce the report.
The toggle work fine in my old server with IIS 5 and SQL Server 2000.
I don't know where search, I find nothing on forum or help.
Give me idea please.
Ã?ricViewstate mac in machine.config?
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:50693565-A718-496E-8DF3-A54924322035@.microsoft.com...
> II6.0
> SQL server 2005
> I have a report with toggle option, it work fine except the toggle, when
> click on + I receive error rsReportParameterValueNotSet.
> The URL of toggle is construct without parameter needs to produce the
> report.
> The toggle work fine in my old server with IIS 5 and SQL Server 2000.
> I don't know where search, I find nothing on forum or help.
> Give me idea please.
> Éric

Monday, March 26, 2012

model database locked

model database locked

model database locked

Friday, March 23, 2012

MMC DataBase Properties Error

MMC DataBase Properties Error

MMC DataBase Properties Error

Friday, March 9, 2012

missing SP when I query for it's text

missing SP when I query for it's text

missing SP when I query for it's text

Wednesday, March 7, 2012

Missing parameter on postback

Missing dll file

Blog Archive

About Me