pivot information

l saw error message on log reader on replicated please suggest me
THANKS U
Another logreader agent for the subscription(s) is running.
NOTE: The step was retried the requested number of times (10) without succeeding .The step failedIs the logreader job still failing?
If so, the same logreader job is actually running on your publisher. It may be an orphaned process. If so, you will need to kill it.

--jfp|||It ok. Thank you so much

Hello everyone...
plzz help me,im getting this error whenever i want to connect my pc with another remote pc which i've designated as Server and my database is saved there so i want to connect my pc with tht remote pc and save data entered by my pc to that remote pc's database...
but i get this error....PLEASE HELP IMMEDIATELY...

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

-
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

-
Error Number: -2
Severity: 11
State: 0

-
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Can you connect to the remote server through Management Studio?|||

No my pc didnt get connected to the remote server.....i simply open my SQL server management studio and locally connect my application to the DB and it works fine but whenever i connect my pc with rmeote system with "Connect" option then it gives this error...plzzz anyone can resolve my problem then i'll b higly obliged..im totally stuck here as im very new to SQL server :(

|||What do you mean by "remote pc"? Are you trying to access the server on the same network or across the Internet? If across the Internet, you will need to open a hole in the firewall for SQL or use a VPN client.

Hello everyone...
plzz help me,im getting this error whenever i want to connect my pc with another remote pc which i've designated as Server and my database is saved there so i want to connect my pc with tht remote pc and save data entered by my pc to that remote pc's database...
but i get this error....PLEASE HELP IMMEDIATELY...

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

-
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

-
Error Number: -2
Severity: 11
State: 0

-
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Can you connect to the remote server through Management Studio?|||

No my pc didnt get connected to the remote server.....i simply open my SQL server management studio and locally connect my application to the DB and it works fine but whenever i connect my pc with rmeote system with "Connect" option then it gives this error...plzzz anyone can resolve my problem then i'll b higly obliged..im totally stuck here as im very new to SQL server :(

|||What do you mean by "remote pc"? Are you trying to access the server on the same network or across the Internet? If across the Internet, you will need to open a hole in the firewall for SQL or use a VPN client.

I just changed my dataset syntaxes from the typical
SELECT col FROM table WHERE col3 = @.value
to
="SELECT col FROM table WHERE col3 = '" & Parameters!Code.Value & "'
For some reason I'm getting the following pop-up:
--
Processing Errors
--
An error has occurred during report processing.
Cannot set the command text for data set 'ds_Legal_Entity'.
Error during processing of the CommandText expression of dataset
â'ds_Legal_Entityâ'.
--
OK
--
I am not familiar with the CommandText syntax to understand where the error
might be. My query is below, could someone tell me what the problem might be?
Thanks!
Mike
="SELECT DISTINCT dbo.t_d_legal.legal_desc
FROM dbo.t_d_legal
INNER JOIN dbo.t_pms ON dbo.t_d_legal.legal_key = dbo.t_pms.legal_key
WHERE (dbo.t_pms.mth_key = " & Parameters!mth_key.Value & ") " &
IIF(Parameters!BusKey.Value = 0,"","
AND
(dbo.t_pms.bus_key = ") & Parameters!BusKey.Value & ")" &
" ORDER BY dbo.t_d_legal.legal_desc"think you had extra single quote:
="SELECT col FROM table WHERE col3 = " & Parameters!Code.Value & " rest of
code"
otherwise if you need quotes due to your parm value being character you'll
need to double up on the quotes. read BOL.
"Bassist695" wrote:
> I just changed my dataset syntaxes from the typical
> SELECT col FROM table WHERE col3 = @.value
> to
> ="SELECT col FROM table WHERE col3 = '" & Parameters!Code.Value & "'
> For some reason I'm getting the following pop-up:
> --
> Processing Errors
> --
> An error has occurred during report processing.
> Cannot set the command text for data set 'ds_Legal_Entity'.
> Error during processing of the CommandText expression of dataset
> â'ds_Legal_Entityâ'.
> --
> OK
> --
> I am not familiar with the CommandText syntax to understand where the error
> might be. My query is below, could someone tell me what the problem might be?
> Thanks!
> Mike
> ="SELECT DISTINCT dbo.t_d_legal.legal_desc
> FROM dbo.t_d_legal
> INNER JOIN dbo.t_pms ON dbo.t_d_legal.legal_key = dbo.t_pms.legal_key
> WHERE (dbo.t_pms.mth_key = " & Parameters!mth_key.Value & ") " &
> IIF(Parameters!BusKey.Value = 0,"","
> AND
> (dbo.t_pms.bus_key = ") & Parameters!BusKey.Value & ")" &
> " ORDER BY dbo.t_d_legal.legal_desc"

Hi all,

While i am doing new substription wizad, I encounter following error: Do I miss something?

A call to SQL Server Reconciler failed. Try to resynchronize.

A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

The schema script 'C:\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\compuntername_SQLMOBILE_SQLMOBILE\20060321224198\CustomerData_2.sch' could not be propagated to the subscriber.
HRESULT 0x80070005 (0)

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)

I am using

IIS 5.1

SQL 2005 (Upgrade from SQL 2000 SP4)

Visual Studio 2005

Thank you very much

Tony

try generating a new snapshot on the server and also make sure you are not out of memory on your mobile device when performing the replication.

Darren

|||

HI ,

How can I create another snapshot agin. I am not getting the oiption to select a nre one when running the wizard. I am not able to delete the previous snap shot also.

-Please advise

sql

Hi all,

While i am doing new substription wizad, I encounter following error: Do I miss something?

A call to SQL Server Reconciler failed. Try to resynchronize.

A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

The schema script 'C:\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\compuntername_SQLMOBILE_SQLMOBILE\20060321224198\CustomerData_2.sch' could not be propagated to the subscriber.
HRESULT 0x80070005 (0)

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)

I am using

IIS 5.1

SQL 2005 (Upgrade from SQL 2000 SP4)

Visual Studio 2005

Thank you very much

Tony

try generating a new snapshot on the server and also make sure you are not out of memory on your mobile device when performing the replication.

Darren

|||

HI ,

How can I create another snapshot agin. I am not getting the oiption to select a nre one when running the wizard. I am not able to delete the previous snap shot also.

-Please advise

Please any one can help me ?I have multiuser application ( VB 6.0 ) on SQL Server 2000 running.

Last night my Sql Server was writting info on the Log file of one database when the power accidentally shut down. In fact, the server was executing one Microsoft Data Transformation Service ( DTS ) which transfers data from one table to another.

This morning when the users tried to work with this database everything went wrong... I've not been able to attach MDF AND LDF files to SQL Server 2000 Desktop Engine.

Looking for what happened I found those Info/Error LOG events:

A)Starting up database 'pcserveis'.

B)ex_raise2: Exception raised, major=34, minor=48, severity=21, attempting to create symptom dump
C) "The transaction ( Process Id 5 ) was left in "interblockade" in Lock
resources with another process and was chosen as subject of the "interblockade". Execute the transaction again." ( Sorry about wrong words , i'm using a translation tool from spanish )
D) Could not undo log record (5019077:221:133), for transaction ID (0:15254626), on page (1:1917), database 'pcserveis' (database ID 11). Page information: LSN = (5019072:426:5), type = 1. Log information: OpCode = 2, context 1.. ( Error: 3448, Severity: 21, State: 1)
E)Error while undoing logged operation in database 'pcserveis'. Error at log record ID (5019077:221:133).. (Error: 9004, Severity: 23, State: 7)

F)An error occurred while processing the log for database 'pcserveis'..

What can i do to restore my database? ThanksYou log file is toasted because of the power outage. Create a new log file and attach it to you database. But all transactions in th log file cannot be recovered. The other choice you have is to restore the database from the backup file and reprocess everything, assuming you have a good backup.|||Obviously, this morning when the users noticed me the problem , i've restored last backup and they kept on working.

My request was about if could be possible to repair the database more than a problem of losing data.

Is there any solution or the only thing to do is to restore the last backUp?|||You will only lose the uncommitted data if you rebuild the log file. That is probably you best bet for not losing the data between the time the database crushed and the last backup run in this situation.|||Thanks for your assistance.

I am running SQL 2K on Windows 2000. Apparently for no reason when I
attempted restarting Win 2K I got the error
\Winnt\System32\Config\System is missing or corrupt.
I tried repairing did not work and I did not have a emergency repair
backup disk I used Win2K got in on Console mode and restore
C:\winnt\repair\system to \winnt\System32\config\system
Now I can boot into my Win2K Server all software works except that my
SQL Server services have all gone missing in Services.
When I use service manager I get the following message "The specified
service does not exist as an service". When I attempt to start SQL
Server I get the following error:
An error 1060-(The specified service does not exist as an installed
service) occurred while performing this service operation on the
MSSQLServer service.
Please advice how I can recreate or regenerate all the SQL Server and
Analysis Services services.
Thanks
SimonHello Simon
Sounds like there was some type of catastrophic error at OS/hardware level.
This most likely resulted in some of the registry being corrupted hence
affecting SQL Server. If registry has corrupted in this manner, chances are
that some/all other applications on that machine may be affected also.
I would advise you to get the System Eventlog from the machine and try to
diagnose what happened. If the issue has been diagnosed and fixed already,
then go ahead and reinstall the OS and all other applications. If you have
a backup of the entire machine (including registry) then it may save you
time just by restoring the backup.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

I am running SQL 2K on Windows 2000. Apparently for no reason when I
attempted restarting Win 2K I got the error
\Winnt\System32\Config\System is missing or corrupt.
I tried repairing did not work and I did not have a emergency repair
backup disk I used Win2K got in on Console mode and restore
C:\winnt\repair\system to \winnt\System32\config\system
Now I can boot into my Win2K Server all software works except that my
SQL Server services have all gone missing in Services.
When I use service manager I get the following message "The specified
service does not exist as an service". When I attempt to start SQL
Server I get the following error:
An error 1060-(The specified service does not exist as an installed
service) occurred while performing this service operation on the
MSSQLServer service.
Please advice how I can recreate or regenerate all the SQL Server and
Analysis Services services.
Thanks
SimonHello Simon
Sounds like there was some type of catastrophic error at OS/hardware level.
This most likely resulted in some of the registry being corrupted hence
affecting SQL Server. If registry has corrupted in this manner, chances are
that some/all other applications on that machine may be affected also.
I would advise you to get the System Eventlog from the machine and try to
diagnose what happened. If the issue has been diagnosed and fixed already,
then go ahead and reinstall the OS and all other applications. If you have
a backup of the entire machine (including registry) then it may save you
time just by restoring the backup.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

I am running SQL 2K on Windows 2000. Apparently for no reason when I
attempted restarting Win 2K I got the error
\Winnt\System32\Config\System is missing or corrupt.
I tried repairing did not work and I did not have a emergency repair
backup disk I used Win2K got in on Console mode and restore
C:\winnt\repair\system to \winnt\System32\config\system
Now I can boot into my Win2K Server all software works except that my
SQL Server services have all gone missing in Services.
When I use service manager I get the following message "The specified
service does not exist as an service". When I attempt to start SQL
Server I get the following error:
An error 1060-(The specified service does not exist as an installed
service) occurred while performing this service operation on the
MSSQLServer service.
Please advice how I can recreate or regenerate all the SQL Server and
Analysis Services services.
Thanks
Simon
Hello Simon
Sounds like there was some type of catastrophic error at OS/hardware level.
This most likely resulted in some of the registry being corrupted hence
affecting SQL Server. If registry has corrupted in this manner, chances are
that some/all other applications on that machine may be affected also.
I would advise you to get the System Eventlog from the machine and try to
diagnose what happened. If the issue has been diagnosed and fixed already,
then go ahead and reinstall the OS and all other applications. If you have
a backup of the entire machine (including registry) then it may save you
time just by restoring the backup.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Hi,
I am trying to open Reposrt Services , I get the following error.
'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\'. The directory does not exist or is not accessible
because of security settings.]
I do not know what went wrong. Could any one please help.
Thanks Much,
--
snbatDid it work at one point? What changed? Does the directory exist?
Jeff
"snbat" <snbat@.discussions.microsoft.com> wrote in message
news:2ED1BBAD-3E0A-4CFD-9C08-ABEBB3A7A47F@.microsoft.com...
> Hi,
> I am trying to open Reposrt Services , I get the following error.
> 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\'. The directory does not exist or is not
accessible
> because of security settings.]
> I do not know what went wrong. Could any one please help.
> Thanks Much,
>
> --
> snbat

Hi,

I'm trying to script out my replication objects using
the 'Generate SQL Script...' option under Tools >
Replication in Enterprise Manager. Under 'Replication
components to script', I check 'Distributor properties'
and 'Publications in these databases:' and choose all
databases listed. I get a 512 error:

Error 512: Subquery returned more than 1 value. This is
not permitted when the subquery follows =, !=, <, <=, >,
>= or when the subquery is used as an expression.

The server is 2000 sp2, and the Ent Mgr client is 2000.
Using the same Ent Mgr client to script replication
objects in other 2000 sp2 servers, I don't receive any
errors.

I appreciate any help you can provide.

Thanks,
LB
.Try scripting individually.

I am creating a query and am getting:
"Data Type Mismatch in criteria expression" error messages!!

It's driving me crazy. It only happens when I enter certain codes. For example, if I enter "2AP" the query works. If i enter "2AK", I receive the error!

Here is the SQL although I used Design View in Access to create the query:

SELECT TradeHist.[Portfolio Code], Sum([Trade Shares]*[Trade FX Rate]*[Order Decision Price]) AS MV, Sum([Trade Shares]*[Trade FX Rate]*[Order Decision Price]*[OrderHor])/[MV] AS OHMV, Sum(IIf([OrderHor]>=0.5,1,0)*[Trade Shares]*[Trade FX Rate]*[Order Decision Price])/[MV] AS PercOverFifty
FROM OrderHorizonQuery INNER JOIN TradeHist ON OrderHorizonQuery.[Order ID Master] = TradeHist.[Order ID Master]
GROUP BY TradeHist.[Portfolio Code]
HAVING (((TradeHist.[Portfolio Code])="2AK" Or (TradeHist.[Portfolio Code])="42O" Or (TradeHist.[Portfolio Code])="4UZ"));

Any help would be appreciated!put your conditions into the WHERE clause
select TradeHist.[Portfolio Code]
, Sum([Trade Shares]*[Trade FX Rate]*[Order Decision Price]) AS MV
, Sum([Trade Shares]*[Trade FX Rate]*[Order Decision Price]*[OrderHor])/[MV] AS OHMV
, Sum(IIf([OrderHor]>=0.5 ,1 ,0)*[Trade Shares]*[Trade FX Rate]*[Order Decision Price])/[MV] AS PercOverFifty
from OrderHorizonQuery
inner
join TradeHist
on OrderHorizonQuery.[Order ID Master]
= TradeHist.[Order ID Master]
where TradeHist.[Portfolio Code] in ('2AK','42O','4UZ')
group
by TradeHist.[Portfolio Code]|||Thanks for the effort but It is still yeilding the same error. any other ideas?|||double-check the datatypes of all columns involved|||How will I identify mistakes after looking at the data types of each column involved in the query? Thanks again for your continued support!

:confused:|||(((TradeHist.[Portfolio Code]='2AK') Or (TradeHist.[Portfolio Code]='42O') Or (TradeHist.[Portfolio Code])='4UZ'));

Try this|||How will I identify mistakes after looking at the data types of each column involved in the query? Thanks again for your continued support!

:confused:Based on your posted code, [OrderHor] should be a numeric type, and [Portfolio Code] should be a text type. I'd guess that one of them is of the wrong type.

-PatP|||Thanks all. Ill be at work in a bit. Ill let you know what I find!!!|||It worked!! Thanks|||mind telling us what worked? ;)|||yeah, I'm curious too. I can't seem to engage omniscient mode at the moment, so I'd like a wee bit more feedback.

-PatP|||heh

i always say something like "my crystal ball runs on Windows ME and is down at the moment"

Can anyone help with this error message I get with vbullettin

Database error in vBulletin 2.2.9:

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 21, 1063544677, '27618960', 1, 3)

mysql error: Unknown column 'usergroupid' in 'field list'

mysql error number: 1054Hi

This is a SQL Server news group!

It seems like the useractivation table does not contain the usergroupid
column. It could be that this column does not exist, the column is spelt
differently, or the name is case dependent..

John

"spider" <spiderxo@.msn.com> wrote in message
news:dPZ8b.2998$f7.229764@.localhost...
> Can anyone help with this error message I get with vbullettin
>
> Database error in vBulletin 2.2.9:
> Invalid SQL:
> INSERT INTO useractivation
> (useractivationid, userid, dateline, activationid, type, usergroupid)
> VALUES
> (NULL, 21, 1063544677, '27618960', 1, 3)
> mysql error: Unknown column 'usergroupid' in 'field list'
> mysql error number: 1054sql

Dear all
My server received following information around 2 months from event viewer.
Error: 17883, Severity: 1, State: 0
The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context 0x00CDA950
(We have not a scheduler 3 in my sql)
After that, i disable symantec antivirus on my server, then this error do
not occur again. i dont know why?
Server :windows 2003
SQL : SQL 2000 SP3
Or better yet, exclude your MDF/NDF/LDF files in your anti-virus scans
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eFL7JtiuHHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi
> Generally speaking, it is not a good idea to have anti-virus products on a
> SQL Server.
> http://support.microsoft.com/kb/309422/en-us
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "SQL" <SQL@.discussions.microsoft.com> wrote in message
> news:98063DA6-5633-4508-9F38-7A84E18657A9@.microsoft.com...
>
|||Do you have any document ?
"bass_player [SBS-MVP]" wrote:

> Or better yet, exclude your MDF/NDF/LDF files in your anti-virus scans
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eFL7JtiuHHA.4764@.TK2MSFTNGP05.phx.gbl...
>
>

Dear all
My server received following information around 2 months from event viewer.
Error: 17883, Severity: 1, State: 0
The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context 0x00CDA950
(We have not a scheduler 3 in my sql)
After that, i disable symantec antivirus on my server, then this error do
not occur again. i dont know why?
Server :windows 2003
SQL : SQL 2000 SP3Hi
Generally speaking, it is not a good idea to have anti-virus products on a
SQL Server.
http://support.microsoft.com/kb/309422/en-us
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:98063DA6-5633-4508-9F38-7A84E18657A9@.microsoft.com...
> Dear all
> My server received following information around 2 months from event
> viewer.
> Error: 17883, Severity: 1, State: 0
> The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context 0x00CDA950
> (We have not a scheduler 3 in my sql)
> After that, i disable symantec antivirus on my server, then this error do
> not occur again. i dont know why?
> Server :windows 2003
> SQL : SQL 2000 SP3
>|||Or better yet, exclude your MDF/NDF/LDF files in your anti-virus scans
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eFL7JtiuHHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi
> Generally speaking, it is not a good idea to have anti-virus products on a
> SQL Server.
> http://support.microsoft.com/kb/309422/en-us
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "SQL" <SQL@.discussions.microsoft.com> wrote in message
> news:98063DA6-5633-4508-9F38-7A84E18657A9@.microsoft.com...
>|||Do you have any document ?
"bass_player [SBS-MVP]" wrote:

> Or better yet, exclude your MDF/NDF/LDF files in your anti-virus scans
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eFL7JtiuHHA.4764@.TK2MSFTNGP05.phx.gbl...
>
>

Dear all
My server received following information around 2 months from event viewer.
Error: 17883, Severity: 1, State: 0
The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context 0x00CDA950
(We have not a scheduler 3 in my sql)
After that, i disable symantec antivirus on my server, then this error do
not occur again. i dont know why?
Server :windows 2003
SQL : SQL 2000 SP3Hi
Generally speaking, it is not a good idea to have anti-virus products on a
SQL Server.
http://support.microsoft.com/kb/309422/en-us
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:98063DA6-5633-4508-9F38-7A84E18657A9@.microsoft.com...
> Dear all
> My server received following information around 2 months from event
> viewer.
> Error: 17883, Severity: 1, State: 0
> The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context 0x00CDA950
> (We have not a scheduler 3 in my sql)
> After that, i disable symantec antivirus on my server, then this error do
> not occur again. i dont know why?
> Server :windows 2003
> SQL : SQL 2000 SP3
>|||Or better yet, exclude your MDF/NDF/LDF files in your anti-virus scans
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eFL7JtiuHHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi
> Generally speaking, it is not a good idea to have anti-virus products on a
> SQL Server.
> http://support.microsoft.com/kb/309422/en-us
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "SQL" <SQL@.discussions.microsoft.com> wrote in message
> news:98063DA6-5633-4508-9F38-7A84E18657A9@.microsoft.com...
>> Dear all
>> My server received following information around 2 months from event
>> viewer.
>> Error: 17883, Severity: 1, State: 0
>> The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context
>> 0x00CDA950
>> (We have not a scheduler 3 in my sql)
>> After that, i disable symantec antivirus on my server, then this error do
>> not occur again. i dont know why?
>> Server :windows 2003
>> SQL : SQL 2000 SP3
>>
>|||Do you have any document ?
"bass_player [SBS-MVP]" wrote:
> Or better yet, exclude your MDF/NDF/LDF files in your anti-virus scans
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eFL7JtiuHHA.4764@.TK2MSFTNGP05.phx.gbl...
> > Hi
> >
> > Generally speaking, it is not a good idea to have anti-virus products on a
> > SQL Server.
> >
> > http://support.microsoft.com/kb/309422/en-us
> >
> >
> > --
> > VT
> > Knowledge is power, share it...
> > http://oneplace4sql.blogspot.com/
> > "SQL" <SQL@.discussions.microsoft.com> wrote in message
> > news:98063DA6-5633-4508-9F38-7A84E18657A9@.microsoft.com...
> >> Dear all
> >>
> >> My server received following information around 2 months from event
> >> viewer.
> >>
> >> Error: 17883, Severity: 1, State: 0
> >> The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context
> >> 0x00CDA950
> >>
> >> (We have not a scheduler 3 in my sql)
> >> After that, i disable symantec antivirus on my server, then this error do
> >> not occur again. i dont know why?
> >> Server :windows 2003
> >> SQL : SQL 2000 SP3
> >>
> >>
> >
> >
>
>

when I try to create this SP I get: "incorrect syntax near @.MyResult"
I have tried INT and different variable names, but get same error.

CREATE PROCEDURE sp_IsValidLogon
@.UserName varchar(16),
@.Password varchar(16) ,
@.MyResult varchar(3) OUTPUT
As
if exists(Select * From User_Table
Where UserName = @.UserName
And
Password = @.Password)
begin
@.MyResult = 1
end
else
begin
INSERT INTO FailedLogons(UserName, Password)
values(@.UserName, @.Password)

declare @.totalFails int
Select @.totalFails = Count(*) From FailedLogons
Where UserName = @.UserName
And dtFailed > GetDate()-1

if (@.totalFails > 5)
UPDATE User_Table Set Active = 0
Where UserName = @.UserName

@.MyResult = 0
endThe answer is

SET @.MyResult = ...|||Thanks George,
That's sorted it.
I seem to have two threads in this forum now tho' :o sorry guys.|||No worries - I will remove the dupe :)

I tried to replicate between SVRPOS01 and SVRPOS02.
SVRPOS01 is publisher and distributor.
Replication is Merge replication.
But, after snapshot agent ran, the following error comes out and merge agent doesn't do merge replication.
When configure replication I choose option initialize schema.., and in SVRPOS02 I just create empty DB.
Most of time this works... but not in this time..
SVRPOS02 doesn't have data replicated...
Please reply any idea of following error, and solution if you have any..
Thank you.

<Error message>
The schema script '\\SVRPOS01\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SVRPOS01_POS_POSPublicat ion\20040706003309\v_Item_Old_232.sch' could not be propagated to the subscriber.

<Error Detail>
The schema script '\\SVRPOS01\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SVRPOS01_POS_POSPublicat ion\20040706003309\v_Item_Old_232.sch' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----------------------------------
Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber.
(Source: SVRPOS02 (Agent); Error number: 0)
----------------------------------
Invalid object name 'POSLOC.dbo.BARCODE_MATCH'.
(Source: SVRPOS02 (Data source); Error number: 208)
----------------------------------You have to script the structure of the publishing database and apply to the subscriber before the snapshot agent runs for the first time.|||By any chance, does that view contain some sort of cross-database query? Then you need to make sure that database is also present on the subscriber.

I have a store Procedure modify structTable but check syntax is error !

Please help me ?
--
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME ='MODISTRCTTABLE ' AND TYPE='P')
BEGIN
DROP PROCEDURE MODISTRUCT_TABLE
END
GO

CREATE PROCEDURE MODISTRUCT_TABLE
@.TABLE_NAME VARCHAR(60),
@.COLUMN_NAME VARCHAR(60),
@.COLUMN_TYPE VARCHAR(60),
@.COLUMN_SIZE INT(10)
AS
BEGIN
IF EXISTS (SELECT @.COLUMN_NAME FROM syscolumns)
BEGIN
ALTER TABLE @.TABLE_NAME ALTER @.COLUMN_NAME + ' ' + @.COLUMN_TYPE+'('+ @.COLUMN_SIZE +')'
END
ELSE
BEGIN
ALTER TABLE @.TABLE_NAME ADD @.COLUMN_NAME + ' ' + @.COLUMN_TYPE+'('+ @.COLUMN_SIZE +')'
END
END

-

CREATE PROCEDURE ENCRYPTION getString()

AS
SELECT * FORM CUSTOMER

-

Funtion getString() return a string is " With Encryption"?

Do I call function getString() in here ?

You need to use dynamic sql for this.

Code Snippet

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME ='MODISTRCTTABLE ' AND TYPE='P')
BEGIN
DROP PROCEDURE MODISTRUCT_TABLE
END
GO

CREATE PROCEDURE MODISTRUCT_TABLE
@.TABLE_NAME VARCHAR(60),
@.COLUMN_NAME VARCHAR(60),
@.COLUMN_TYPE VARCHAR(60),
@.COLUMN_SIZE INT(10)
AS
BEGIN
IF EXISTS (SELECT @.COLUMN_NAME FROM syscolumns)
BEGIN
exec ('ALTER TABLE '+@.TABLE_NAME+' ALTER '+@.COLUMN_NAME + ' ' + @.COLUMN_TYPE+'('+ @.COLUMN_SIZE +')' )
END
ELSE
BEGIN
exec('ALTER TABLE '+@.TABLE_NAME+' ADD '+@.COLUMN_NAME + ' ' + @.COLUMN_TYPE+'('+ @.COLUMN_SIZE +')' )
END
END

The other proc is also incorrect. It should be like so.

Code Snippet

CREATE PROCEDURE getString()
with ENCRYPTION
AS
SELECT * FROM CUSTOMER

|||Thanks Oj my idea is not clearly ! I have a Store procedure :
--
Create procedure MyEnCryption With Encryption
AS
Begin
Select * from Customer
End

I want replace string " With Encryption" with calling Function GetString(); Function GetString() return a string is "With Encryption"

this store rewrite :
-
Create procedure MyEnCryption GetString()
AS
Begin
Select * from Customer
End

--

Is this store run ?|||

What you're trying to do is not possible. The syntax to create a procedure is like so:

CREATE PROC [ EDURE ] procedure_name [ ; number ]
[ { @.parameter data_type }
[ VARYING ] [ = default ] [ OUTPUT ]
] [ ,...n ]

[ WITH
{ RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ]

[ FOR REPLICATION ]

AS sql_statement [ ...n ]

|||

While creating the objects you have to use the proper syntax what is already defined..

You can achive your desired output if you create your object using dynamic SQL...

But it is not recommanded to do this.. & I didn’t understand why you need this logic..

Note:

When you encrypt the procedure/function/view/trigger you have to store your soruce code on filesystem or source safe for future reference, you never get back the soruce text from the SQL Server. So, it is really bad idea to have dynamic sql to create encrypted objects.

Code Snippet

Declare @.sql as varchar(8000)

Set @.sql = 'Create procedure MyEnCryption ' +GetString() + '

AS

Begin

Select * from Customer

End'

exec (@.sql)

|||

Thanks Admin !

Now I'am understading !

Friday, March 30, 2012

Please help me

Wednesday, March 28, 2012

Please Help Immediately...

Please Help Immediately...

Please help deciphering error message

Please help : A call to SQL Server Reconciler failed. Try to resynchronize.

Please help : A call to SQL Server Reconciler failed. Try to resynchronize.

Please help (Sql server 2000) Critical Error

Monday, March 26, 2012

Please help - SQL Server Services are missing

Please help - SQL Server Services are missing

Please help - SQL Server Services are missing

Please HELP - I am getting security errors hwen trying to open the

please help -- 512 error when generating replication script

Please Help

Please help

Friday, March 23, 2012

Please comment

Please comment

Please comment

please check this SP syntax - need more eyes!

Please check this replication error..

Please Check my store Procedure !

pivot information

Blog Archive

About Me