Search results for query: *

I had database e-mail setup and it was working for the past three years or so. Now all of a sudden it is not working. When I run the following query I see no users SELECT l.name LoginName, u.name UserName, r.name RoleName FROM master.sys.server_principals l JOIN msdb.sys.database_principals u...

I have the following sql queries. How can I write 1 query so it returns only one result set? select distinct fdShortNumber as PartNumber, count(fdShortNumber) as Quantity from tbStation5 where fdAssemblyDate = @fdAssemblyDate AND fdAssemblyShift = @fdAssemblyShift group by fdShortNumber...

I am trying to generate a script on SQL Server 2008 R2 standard edition. Why are all my options greyed out? See attached file. I want to change the SQL Server version from 2008 to 2005. Thanks...

I am trying to read the following data from 4 serial ports in VB.Net 2012 00056 00056 00056 00056 00056 Its 5 lines of data. The starting digit is a space and there are four lines of data. I have tried so many different code but none has worked. I have searched only and had no success...

This weekend we are planning on changing the drive on our SQL Server 2000 cluster. I saw in another forum that others have done this. Here is the lnk: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62093 Here is what we are planning on doing: Turn off MSSQLSERVER service Turn off...

I have a visual basic 2010 project with a solution. When I double click the solution the project opens. I cannot see the solution file. I am trying to add an existing project to my solution but I am having trouble. How do I add an existing project to an existing solution? In VB 2005 if I...

I have a combo box on few of my vb.net 2010 programs. The end users that use my program have touch screens and they have a hard time making selections on the combo box. I have an Android cell phone and when ever there is a combo box it will open another screen and making the selection is a...

I have a windows forms program that I upgraded from VB 2005 to VB2010. When the program was on VB 2005 I had set the form size to 1278 x 891. When I open the program on a windows 7 computer which had a resolution of 1024 x 768 the form would resize to the monitor resolution. But since I upgraded...

We have SQL Server 2000 with about 40 databases. All databases are set to recovery model of full. In one of our databases the transaction log is growing 0.10MB every 30 seconds. We shrinked the transaction log this morning but now it is 137.73MB. The biggest other transaction log we have is...

In one of my multi threading programs I cannot get my threads to abort. I have about 5 threads and the threads starts one at a time. By the time the fifth thread is started the program gets really slow. The program will not execute pass LoadWheelStn1. How should I resolve this problem? Private...

In one of my visual basic programs on and off the program runs slow. It used to run slow all the time. After adding some indexes it is much better. I want to further tweak the indexes and see whether there is a performance improvement. Here are some of the questions I have? 1) How often should...

We were having some performance issues on our visual basic client programs for weeks. Then yesterday we saw 3 weird locks and we cleared them. Now the clients are running much better. Is there a way of checking for others locks on our server? I ran sp_who and sp_who2 but I am not sure what to...

I get the following error because of a network issue we are having. We still haven’t figured out where the problem is. Here is the error: “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.” I always get the error in the following...

I have function in one of my vb.net 2003 called LoadUserDara. On and off my program started hanging inside the function. So I had to call this function from a different thread. Inside this function I had to check for InvokeRequied three times. Here is my code for the function: Private Sub...

If DataGrid1.InvokeRequired Then Dim mi2 As New MethodInvoker(AddressOf AddDataGridData) DataGrid1.Invoke(mi2, Nothing) Else DataGrid1.TableStyles.Add(tsGridTableStyles) End If Private Sub AddDataGridData(ByVal tsGridTableStyles As DataGridTableStyle)...

When I try to check my wireless connection I get the following error message: Windows cannot configure this wireless connection And it tells me to see article 871122 in the Microsoft knowledge Base on Microsoft.com web site. I looked at the web site. And the web site asks me to do the...

I have a growing transaction log. To change the recovery model to simple do I need exclusive access to the database? Can I change it while users are accessing the database? Environment: Windows 2003 and SQL Server 2000

I have two tables say tableA an tableB. TableA fdUserLoadId PartNumber Qty CompFlag fdHoldSerial 1 78500 A400 5 C 49 2 78500 A400 3 C 49 3 78500 A500 2 C 49 4 78500 A300 1 C 49 5 78500 A200 5 C 49 TableB fdItemId PartNumber Stn1Qty HoldFlag fdHoldSerial 12 78500 A400 1 N 49 13 78500 A400...

I have two tables say TableB and TableC. Here is what’s in the two tables TableB fdUserLoadId fdPart fdQty fdDate 1 78500 A 2 12/12/2006 2 78500 B 3 12/12/2006 3 78500 B 5 12/12/2006 4 78500 A 5 12/12/2006 5 78500 C 6 12/12/2006 6 78500 D 5 12/12/2006 7 78500 A 5...

The following stored procedure takes too long to run. How can I rewrite this procedure so it will run faster? Sometimes it times out too. CREATE PROCEDURE [spGetQtyOrderedAS400WorkOrder] @fdShortNumber varchar(15) AS Select sum(WAUORG) as TotalOrdered, sum(WASOQS) as TotalShipped From F4801...