I have a table (Tickdata; Contract,Price,Timecreated) which stores
Timecreated as datetime. I need to request the maximum price where the
Timecreated is greater than some value, in this case 9/13/2004 3:09:29 PM.
How exactly do I get data from a specified time?
Thanks
Hi,
while my db is executing a store procedure i try to view the current activity in the managent but it returns to me 'Lock request time out period exceded'. It happens until the store procedure is finished. After that everything is ok. However i can see the activity executing sp_who and the db seems to work ok, maybe a little slow.
what does it means????
Sorry for my english.
Thanks. Eduardo
Hi
I am getting occasional errors in the event log of our production database where we have some service broker receiving queues running.
The first error is
Lock request time out period exceeded
This is then immediately followed by
An error occurred in dialog transmission: Error: 1222, State: 51.
There are no further errors and everything seems to carry on OK after this error.
Does anybody know what the problem may be?
Anthony
Hi ,
i am getting error Lock request time-out period exceeded frequently
Could any one explain how can i track the Locking transactions
SP_who,SP_lock helps me partially but i need clear solution
We're running a SQL-Server 2012 and for a while now my accessing records from bigger tables became tricky.There is a Tomcat-8 running which sometimes can't access these tables at all or only after a long delay. As this happened first I went to the Server-Room and opened the Database with the Management Studio to see if there were any issues. open the Database but expanding the directories for "Tables" or "Views" failed after 10 Seconds with the Error 1222.
I turned the Tomcat-8 off to find out whether some unclosed connections are open. Same result, no changes even after one hour.Another 3rd-Party program which we are using seems to connect via other mechanisms to the SQL-Server (Is there a way to list current connections and their types in the Management-Studio, I'm under the impression this program does a lot of caching, it's much faster than the Management-Studio itself.The question is now how can I find out why these time-outs happen? I'm not an expert in SQL-Servers so.
What is this? How do I fix it? I get a ton of these and it slows down the server for 5 minutes.
An error occurred in Service Broker internal activation while trying to scan the user queue 'msdb.dbo.ExternalMailQueue' for its status. Error: 1222, State: 51. Lock request time out period exceeded. This is an informational message only. No user action is required.
I get this error message when I try to connect to Reporting Services via the Management Studio.
I can see my machine listed in the Server Name > Browse For More > Local Servers dialogue. But no luck,
Ive tried:
Servername: localhost
Servername: DED1774 (the machine name)
Servername: localhost/reportserver
Servername: DED1774/reportserver
Servername: http://ded1774/reportserver (from the rsreportserver.config file
<UrlRoot>http://ded1774/reportserver</UrlRoot>)
I've Googled the error message and found postings for solutions, but none of these helped. Can anyone suggest some simple steps I can take to try to find the issue and get the connection working?
Thanks
Hi there. This is only my second post ever- so please bear with me.
First, I am using SQL Server 2000.
I have built a DTS package using an Oracle ODBC and the following query;
select pv.segment1 vendor_nbr, pv.vendor_name,pv.attribute4
, pv.creation_date
from po.po_vendors pv
, po.po_vendor_sites_all pvs
where pv.vendor_id = pvs.vendor_id(+)
operating unit
AND trunc(pv.creation_date) = trunc(sysdate)
This DTS package is not always run on the same day the records are created. So......
What I want to do is have the dts package ask the user for the date they are looking for-
I know I need to probably use a parameter, but I have been unable to figure out how to do this in a DTS pkg. I have several reSQL reference books and I don't even know what to search for in Books online. Could anyone help??
Thanks
Heather Vizina
I am trying to load data into a SQL Server table through a web page. I am getting error like this:
Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
I am doing the same for other tables in the same db its working fine. but its working for one table alone. The table name is like this (DTD_PUMA_DeliveryPerformance)
Is it cos of table name???
I tried with import/export wizard also its working fine but still its not working for web page.
I don t think its cos of network or OS!! Its with table or some connection property.Pls help me in solving this.
I created a .net console application within which I connect to a sql server (not local) as follows,
string conn_str = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=QuantEquitySql;Data Source=server name";
SqlConnection conn = new SqlConnection(conn_str);
conn.Open();
.
Everything works fine when I run it from my computer. When I try to run it from a network share I get the following error,
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I am using Visual Studio 2005 and .Net framwork v2.0.50727.
Does anybody know a fix to this problem?
Thanks
Hello,
I am trying to complete the BOL sample "Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http://sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below.
Sub sync()
Dim repl As New SqlCeReplication()
repl.InternetUrl = "http://sqlce.domain.com/SQLMobile/sqlcesa30.dll"
repl.Publisher = "MY-LAPTOPDBSERVER"
repl.PublisherDatabase = "SQLMobile"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "SQLMobile"
repl.Subscriber = "SQLMobile"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"
Try
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
Catch err As SqlCeException
MessageBox.Show(err.ToString)
End Try
End Sub
http://sqlce.domain.com/sqlmobile/sqlcesa30.dll?diag
SQL Server Mobile Server Agent Diagnostics
2006/04/04 15:28:51
General Information
Item
Value
Server Name
sqlce.domain.com
URL
/SQLMobile/sqlcesa30.dll
Authentication Type
Anonymous
Server Port
80
HTTPS
off
Server Software
Microsoft-IIS/5.1
Replication
Allowed
RDA
Allowed
Logging Level
1
Impersonation and Access Tests
Action
Status
ErrorCode
Impersonate User
SUCCESS
0x0
ReadWriteDeleteMessageFile
SUCCESS
0x0
SQL Server Mobile Modules Test
Module
Status
ErrorCode
Version
SQLCERP30.DLL
SUCCESS
0x0
3.0.5207.0
SQLCESA30.DLL
SUCCESS
0x0
3.0.5207.0
Reconciler Test
Reconciler
Status
ErrorCode
9.0 Database Reconciler
SUCCESS
0x0
8.0 Database Reconciler
SUCCESS
0x0
SQL Server Module Versions
Module
Version
sqloledb.dll
2000.85.1117.0
9.0 replrec.dll
2005.90.1399.0
9.0 replprov.dll
2005.90.1399.0
9.0 msgprox.dll
2005.90.1399.0
8.0 replrec.dll
2000.80.2039.0
8.0 replprov.dll
2000.80.2039.0
8.0 msgprox.dll
2000.80.2039.0
We have developed a Winmobile 5.0 application using VS2005 and Sql 2005 CE. We have successfuly installed the Server Agent on the web server and using the url 'http://websitename/rdatest/sqlcesa30.dll' have received an acknowledgement from the server agent. When we set up the Web Syncronization Wizard we kept things simple and opted for anonymous access. However, our Sql 2005 is based on a separate dedicated server which can be accessed by the web server. Our website, also written in VS2005, uses the following connection string to access the Sql 2005 database for our website.
"server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
When using the following code in our PDA application we have tried the above string as well as another interpretation with the same resulting error 'A request to send data to the computer running IIS has failed, for more information please see HResult'. The code we are using is..
Using rda As New SqlCeRemoteDataAccess()
Dim sCon As String = "Provider=SQLOLEDB;Data Source=172.18.22.222; Initial Catalog=Audit ; UserID=steve; Password=letmein"
Dim sCon As String = "server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
rda.InternetUrl = "http://websitename/rdatest/sqlcesa30.dll"
rda.LocalConnectionString = "Data Source=Program FilesTestSysTestdata.sdf"
Try
rda.Pull("Detail", "SELECT Details, Actions FROM Detail", sCon, RdaTrackOption.TrackingOff, "DtlErrors")
Catch sqlCeEx As SqlCeException
RecError( sqlCeEx.ToString)
End Try
End Using
Having tried both connection strings we feel the error is caused by something else possibly on our dedicated Sql server. Would really appreciate any help.
Hi,
I Have an application for Pocket PC 2003 developed in Visual Studio 2003(VB.Net , Smart Device App). I Use Sql Server CE as the database which Synchronizes with Sql Server 2000, SP4. The IIS and the Sql Server 2000 are in different Machines. I Have Installed the proper Sqlserver Ce in the IIS machine and created virtual directory with Basic authentication.I connect my device through Active Sync 3.7. I could browse the sscesa20.dll from Pocket IE and get the ' SQL Server CE Server Agent ' message. The PC to which my pocket PC is connected is under a Proxy.
When I tried the RDA.Pull() , the function fails and returns the error
" Error Code: 80072EE7
A request to send data to the computer running IIS has failed. For more information see HRESULT. [,,,,,]
Minor Error : 28037
Source: Sql Server 2000 Windows CE Edition. "
The same application works in other network which is not under a proxy.
Any clues ?
Thanks,
Jibu
eSystem Software
Hi guys,
Everything seems to be fine, can browse the DB from VS, Preview data works fine in dataset, and the page works fine before adding any SQL DB code.
I draged n dropped a new DropDownList, Bind it to an object from dataset. And when I want to run the page I get this error !!!
I appreciate any help.
Thanks, Mehdi
I am new to BIZTALK 2006; Please help me get started as below>>
I have XML Request (send) and XML Response (receive) data;
What are the steps needed for this to be accomplished in BizTalk to create webservice for this?
THX
hi,
I´m trying to connect to a integration service hosted in a different machine, but I recive the following message:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) : access denied
I verified and the service that machine is running, maybe could be the user, I´m using windows authentication, I have no problems when I log in in the databse engine.
Can somebody help me??
After getting an RPC error when trying to login to my server via either consol or Terminal services, then rebooting, I can no longer connect to SSIS
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Connect to SSIS Service on machine "BG-22SQL" failed:
The service did not respond to the start or control request in a timely fashion.
.
------------------------------
Connect to SSIS Service on machine "BG-22SQL" failed:
The service did not respond to the start or control request in a timely fashion.
.
Hi guys,
View 4 Replies View RelatedHi,
My application is working under InternetUrl "http://servername/test/sqlcesa30.dll", but I am getting following error for "https://servername/test/sqlcesa30.dll"
"A request to send data to the computer running IIS has failed. For more information, see HRESULT."
We have proxy server top of the web server and certificate is installed on proxy server. There is no ceritificate installed on web server which is behind the firewall. Proxy server divert the request on different protocol based on "http" and "https" request and send to web server which is behind the firewall. I am not getting any error when i use RDA using http for above environment, but when i use RDA using https I am getting an above error for the same environment.
Can anyone help me to resolve this issue?
Thanks in advance
Batch execution is terminated because of debugger request.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Batch execution is terminated because of debugger request
any solution or cause of this exception
please let me know freindz
I have created a windows library control that accesses a local sql database
I tried the following strings for connecting
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"
I am not running the webpage in a virtual directory but in
C:Inetpubwwwrootusercontrol
and I have a simple index.html that tries to read from an sql db but throws
the error
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
etc etc
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted
I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security
I think that a windows form connecting to a sql database running in a webpage should be simple
to configure what am I missing?
Sample Table
USE [Testing]
GO
/****** Object: Table [dbo].[Testing] Script Date: 4/25/2014 11:08:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
[Code] ....
It seems to work fine with one million records.
Each primary key is unique, but the begindate is non-unique, and i guess even if i use datetime2 and add nanoseconds, from what i have read, there is a chance that i could have a duplicate datetime since the date is imported via XML from multiple sources.
I have a table called employee_punch_record that we use to store employee time clock punches.
The columns are:
employeeid,
punch_timestamp,
punch_type (In / Out),
closed (bit used as status for open or closed pay periods),
ident
Here are some examples of a record:
bkingery62015-10-06 16:59:04.000In0
bkingery72015-10-06 16:59:09.000Out0
bkingery82015-10-06 16:59:13.000In0
bkingery92015-10-06 18:22:44.000Out0
bkingery102015-10-06 18:22:46.000In0
bkingery112015-10-06 18:22:48.000Out0
bkingery122015-10-06 18:22:51.000In0
tfeller52015-10-05 17:00:05.000In0
We are using SQL Server 2008 as our database and use Access as a GUI. I am looking to create a form in Access where employees can access their time card and request changes from management. I want to use the format from the attached screen shot for the form. I pretty much know how to do it all, the only point of complication is trying to figure out the easiest way to get the transaction punch record data on employee_punch_record into a format where I can easily populate the form in the horizontal format you see in the screen shot.
I am not super strong in SQL, but figure I can do it using a formatting table of some sort. quick and easy way to move transaction records into a more horizontally oriented record?
Hi,
I have created a web part in ASP.Net. this web part is extracting data from the sql server database and displaying it on the web part page.
This web part is working fine with asp.net application, but when i deploy it with MOSS. it is reaising security exception error like.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I have made the entry under the safe control list of web.config file. but still i am getting error any suggestion wud be highly appreciable..
pls reply me on sanjiv.singh@kpitcummins.com.
thanks you so much.
Regards,
Sanjiv Singh
I have smilar kind of an issue with replication. I had sucessfully done replication with Sqlce2.0 on sql server 2000. In development machine I had VS 2003, sqlce development tools.
Now I use the same code done in VS 2003 into VS2005, it sucessfully converted the code.
In server machine (win 2003) I installed sql server 2000, sql server 2000 service pack 4, SP4 merge replication components, sql server 2005 mobile server tools and .Net framework 2.0. Created pubication sucessfuly. In this machine I configured IIS as per the web synchronization wizard. Gave anyonymous permissions. Virual direcory is created sucessfully. I tested the server agent in IE http://myservername/aliasname/sqlcesa30.dll.
SQL Server Mobile Server Agent 3.0 is shown
My application opened successfuly in windows mobile 5.0 Pocket PC emulator. When try to sync its dislays error "A request to send data to the computer running IIS is failed, see Hrresult"
No firewall in both development and server machines.
The same code works if its sqlce20 perfectly with vs2003 code. Not in this
Can anyone tell me whats wrong in this?
Regards
Arif
Hi, all experts here,
Thank you very much for your kind attention.
I encountered a very strange problem again. Why the time series displayed on the chart are so strange? The Key time column I chose for my time series algorithm is cal_month(e.g 199001...), but why the date displayed on the time series chart is like :05/06/2448? (it should be like 199001..?) What is that data? And where exactly did it come from? What is the exact cause of this?
Hope it is clear for your help.
I am really confused on this and thanks a lot for your kind advices and help and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
how I can load the CSV file data into the sql server table. I know there are ways like bulk insert and other to load the csv file data into the table. But in my case the table doesn't exist and has to be created at the run time. With simple insert in temp table we do like select * into #temp from tablename and that creates the temp table. So. I need something like that which create the temp table and load the data into it. because the CSV file would have different number of columns and names so I can not create the table structure in advance. I have to create the table at run time.Â
View 3 Replies View Related
Hi all,
I have created a report in SSRS 2005 which is being viewed by users from different Time Zones.
I have a dataset which has a field of type datetime (UTC). Now I would like to display this Date according to the User Time Zone.
For example if the date is August 07, 2007 10:00 AM UTC,
then I would like to display it as August 07, 2007 03:30 PM IST if the user Time Zone is IST.
Similarly for other Time Zones it should display the time accordingly.
Is this possible in SSRS 2005?
Any pointers will be usefull...
Thanks in advance
sudheer racha.
I need to store data in the format 99:59:59, <hh:mm:ss> but SQL Server will not let me do this because the datetime field is basically a 24 hour clock. If someone, for example, finished a race in 34 hours, 54 minutes, 10 seconds, how would I represent this in a SQL table other than storing the data as a VARCHAR datatype?
Thanks
Ben
I was wondering is it possible with sql to take datetime data and total the datetime data per date entered into the database, for example
DATE TOTAL HOURS
+10/22/2007 8
|_ 10/22/2007 Time In Time Out Hours
8:00 am 9:00am 1.0
9:01 am 10:01 am 1.0
10:01 am 11:31 am 1.5
etc. etc. etc
until the 8 hours have been reached,
This output will be displayed in a report on reportserver 2005.
I have been unable to come up with a solution for this problem and would like to see if any of the experts here might have an idea.
I currently have an application which retrieves stats from a SQL database that are updated throughout the day. My application updates every 3 seconds to retrieve these stats but I found that it's quite expensive to the server's CPU when there are several clients running my application. Are there any other methods for extracting the data that won't require so much CPU. The fact that the database is being hit so much isn't good either. I have already written a webservice hoping that this would improve things but I'm not sure it has.
View 3 Replies View RelatedI know there is a DateTime data type in SQL server 2000.
But is there a way to only stor time value (hh:mm:ss)?
Dear Colleagues,
I was wondering if anyone has tackled this problem. We have two competitors, Sybase and SQL Server, running together. Our dilemma is to have the production server, Sybase, be able to pass transaction log entries or nightly database backups over to the SQL Server, reporting server, either via a 3rd party software, SQL statement or some other gadget but the end result is to have the information concurrent on both the production server and the reporting server. Any ideas? Thanks in advance, Daimon