I've been coding for a few weeks now, building an ASP.NET application. ran the aspnet_regsql.exe wizard and it created my table and procedures correctly within the live SQL 2005 server being run by my host (ASPNIX.COM). I've been able to run my app just fine locally saving to my remote SQL server. However, now that I've moved my code onto my hosted server, my app stopped working. You would think this would "jus work" since I've been using the same SQL server throughout...BUT NOoooo! I've scoured the net trying to find any hint about what might be happening. The ONLY thing I've been able to find is a story in the May issue of asp.netPRO that says
"Once the scripts have been executed, grant the user account used to access the database from the Web application Execute permissions on all the new stored procedures and Selection permissions on the views that were created"
This may be my problem, but I haven't figured out how to accomplish this. Within the SQl Server Management Studio Express, I can pull up the properties of each stored procedure and place a check next to my "USER" account. However it does not appear to be saved.
My symptoms at this point are:It will not log me in under accounts I'd already created.
I created some test data in two tables. Then I went to one of the tables and right clicked then Selected Script Table asSelect ToNew Query Editor Window. I then cleared the generated data and selectedDesign Query in Editor. I then picked both tables in the 'Add Table' window and picked 'Add'. This produced two windows and I made the links I needed and clicked OK. This generated the SQL I wanted and it works great! But when I close the SQL Express and then re-open it the SQL does not work! I open SQL Express and selectFileOpenFile and pick the SQL I had just saved. Then I pick Execute I get the following message.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.FileData'
How can I save SQL that works and then not be able to use it?
I recently transfered my web app to my Windows 2003 server and am having difficulty getting the system to allow me to login.I am using MS SQL Express 2005 and the SQL Express Manager.I have a user/password setup with SQL Authentication. It appears that I am connecting okay, but I am unable to login to the site. I have tried three different accounts with no luck. I know I am using the correct passwords.What permissions do I have to grant my database user to allow me to login to my site?As I am new to SQL Express and the manager, a more specific reply would be very helpful.Thank you,Joshua Foulk
I have had my site running for several months now. My pages retrieve data from the SQL Server on the same machine. Today my users are are getting the message "SQL Server does not exist or access denied"
I have made sure that the credentials are correct. I can use those credentials to create a DSN on the server. So I don't know where to look for the problem. Help please!
I have a few reports that suddenly stopped printing.
Nothing changed on the report server, and one minute they could print, the other they couldn't
I have one report that is 4 pages in preview and six when it prints. The users press the print control on the web page and the print dialog comes up, they select a printer and the printing messagebox comes up. Then it will print a couple of pages VERY SLOWLY... and eventually will hang at the 3rd page.
IT appears it is just spooling in the printer control viewer...
Other similiar reports that use the same query but a different parameter, work just fine.
I have rebuilt and redployed the report. The problem is happening on both my live and test environments.
I have looked through this forum but not found an answer. I did delete and re-isntall the client print control.
I have turned the client logging on. But no errrors show up anywhere.
I am running ssrs 2005 on both machines. test machine has win2003 sp1 , sql 2005 sp2 AND hotfix's
We built a Cache component that take advantage of the SQL Server 2005 query notification mechanism, all went well , we tested the component in a console application , and notifications kept coming for as long time as the console application ran.
When we initiate our Cache Component in our web service global.asx application start event , the query notification works for a few minutes , but if we came after 10 minutes or so , we stoped getting notifications from sql, the SQL Server queue is empty , and all is showing that there is nothing wrong on the DB side...
Our Cache component is a Singleton class , that perform all registrations ,catch the notification events and resubscribe for notifications.
What can be the problem? is our Cache component object are being collected by GC?
Does IIS disposes the SQL Connection that the Query notification uses?
Decided to try testing SqlCacheDependency and got the following.... thoughts???After using the following code...void Application_Start(object sender, EventArgs e) { System.Data.SqlClient.SqlDependency.Start (ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString); }//-------------------------------- ... then more code SqlCommand sqlCommand = new SqlCommand("select ApplicationName from dbo.aspnet_Applications", sqlConnection); SqlCacheDependency sqlCacheDependency = new SqlCacheDependency(sqlCommand);//-------------------------------- ... then more codeMembershipUser membershipUser = Membership.CreateUser(defaultUserNameTextbox.Text, defaultUserPasswordTextbox.Text); if (membershipUser != null) {//----------------------------- ... more codethe above code no longer works giving the below exception : using a plain database generated using the following statement
I have a working set of parameters, when they are all visible. However, when I change the second parameter to hidden it stops working.Â
First Parameter - Contains static values 'MTD' & Daily Second Parameter - has available values and a default. Set up to be invalidated when the First parameter changes... like i say it works beautifully when not hidden. Third Parameter - has an expression takes the value of the 2nd parameter value, removes the first character off and then converts the remainder to a date and uses it as its default value.
It based on this webpage: URL....However, when i set the second parameter to hidden it no longer works.
I was trying to migrate an ASP application from Access to SQL Server 2005 express, and found surprisingly that some code stops working which would seem to be independent of the data source. For example:
qtext = "SELECT MainText, TextType FROM MessageText WHERE [etc. etc. -- the query is OK]" rsMain.open qtext, dbcon, , , adCmdText if not (rsMain.BOF and rsMain.EOF) then
rsMain.MoveFirst do while not rsMain.EOF
select case rsMain.fields(1).value
case 1
session("headline") = rsMain.fields(0).value case 2
introtext = rsMain.fields(0).value case 6
helptext = rsMain.fields(0).value end select rsMain.MoveNext loop end if rsMain.Close
"rsMain" is an ADO recorset which defaults to a forward-only cursor as opened above; dbcon is an ADO database connection. Nothing fancy; and it has been working for years as expected with Access. But the recordset seems to behave differently when SQL Server is the data source (even though the whole point of ADO is to provide a level of abstraction, and I expected it not to change.) In the code above, checking the value of "rsMain.Fields(1).value" causes "rsMain.Fields(0).value" to disappear or become inaccessible. As a simple debug exercise, I tried response.writing "rsMain.Fields(0).value", a block of text, prior to the select case block, and it works fine once (as long as rsMain.Fields(1).value has not been accessed), but then a second write comes up empty.
Is it reasonable to expect that ADO recordsets and cursors function differently if SQL server is the data source vs. Access? Is this documented anywhere?
I've setup a two node Cluster Server (non-shared storage) with a file sharing witness. I'm testing some of the different failover scenarios to see that everything is working properly. Everything works fine until I try testing the failure of the SQL Server service. When I stop the SQL Service on the primary server, it fails over to the secondary server as expected. I then start the service on the (now) secondary server and it comes back online as the secondary server. I then try to test that the service will fail back over when I stop the service on the new primary server.
However, when I stop the service, the secondary server now shows "resolving" and never comes back online. When I bring the service back up on the primary server, the secondary now shows as secondary instead of resolving. So to see if it's something about failing over from one server to another, I do a manual failover making the original primary server the primary again and everything is as it was originally.
I then stop the service on the primary server, but the secondary server now says resolving and the AG will not become available again until I start the service on the primary server.
It seems that when I first configured the quorum it worked fine the first failover scenario, then stopped working. I then added the file sharing witness, and failover worked the first time again, but not after that. For some reason after the initial failover it won't automatically failover again after that.
Config:
Servers: Windows Server 2012 Standard SQL : SQL Server 2012 Enterprise SP1
I have a report which has 3 tables kept inside rectangle.I have PageBreakAtBegin Set to True for the last 2 tables.Hide Property for rectangle is False.Everything is working fine.
Moment,I place condition in Hide Property,no matter it's True or False,page break stops wroking.I can see all the tables in the single Excel file or report
I am having a recurring issue that involves a stored proc using OPENROWSET to query an excel file. I used the surface area config to enable this on the server, and made sure that is still set. After an undetermined amount of time, the OPENROWSET query starts failing with this message:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
I corrected this previously by restarting the SQL server, but not before I checked permissions, the excel file itself, etc, and that was the last thing to try.
I am using SQL 2005 with SP1 installed - my primary approach to tackling this issue is to install the SP2, but I did not find this bug referenced in the fixes, and was wondering if anyone else had further insight.
Nice simple problem, trying to set the guest user with SQLCMD to have select permissions on an object: -- Code below -- Line below should read "colon"setvar MAD guest : setvar MAD guest
SELECT $(MAD)
GRANT SELECT ON OBJECT::dbo.ErrorLog TO $(MAD)
Unfortunatly I keep getting the following error being thrown:
Prior to our move to 2005...permissions were granted to developers by adding them to the following fixed database roles...db_ddladmin, db_datareader, db_datawriter, and db_securityadmin. They created their objects using 'dbo' as the owner.
After upgrading to 2005, suddently they are having difficulty accessing their objects with this same security. Do they need permissions on the dbo schema?
In my site, when a user registers, I need to create rows in additional tables besides aspnet_Users. So, I need to be able to pass the generated userId guid to subsequent SqlCommands. I'm having a terrible time with this. What's the correct way to set up a SqlParameter so that it will accept a guid? I keep getting this error: "Conversion failed when converting from a character string to uniqueidentifier." I've tried creating the parameter both with and without a SqlDbType. cmd.Parameters.AddWithValue(paramName, guid); and SqlParameter p = new SqlParameter(paramName);p.SqlDbType = SqlDbType.Guid;cmd.Parameters.Add(p); and I get the same error either way. Driving me nuts! Any help appreciated.
I'm new to this SQL thing, and I inherited a DB that has a job that runs every two hours 24/7. Normally the process takes about 5 minutes to complete, but on occasion it just doesn't finish. In those cases, it cannot run at the next two hour cycle. If this happens on a Friday evening, it doesn't get noticed until Monday morning. That is a Bad Thing (tm).
Someone told me to create a second job that would run 45 minutes behind the first and automatically stop the first job if it hadn't terminated on it's own. My problem is I cannot find anywhere how to do this. I have found how to start other jobs, but not stop them.
I have created a stored procedure in SQL Server. I found it very slow, so i putted "select getDate(), 'testposition 1'" at different places, so I could see what part of the code that takes time.
The problem is: Depending on where I put the select statements, the execution of the stored procedure seems to just stop. And depending on where i put the select statements, it stops at different places.
This is how I do (example): 1. I re-create the stored procedure with some "select getDate()"-statements 2. I run the stored procedure 15:00:00 3. I cancel the stored procedure after 20 seconds and look at the resultsets. All getDate-functions show a time between 15:00:00 and 15:00:02 4. I run the stored procedure 15:01:00 5. I cancel the stored procedure after 5 seconds and look at the resultsets. The same amount of resultsets are showed, so I can make the conclusion that the execution stopped at the same place as last time. All getDate-functions show a time between 15:01:00 and 15:01:02 this time too. 6. I re-create the stored procedure with some new "select getDate()"-statements 7. Now the execution stops at an other position. Somtimes even between two "select getDate()"-statements!
I pasted the whole stored procedure here:
drop PROCEDURE spUpdateASW go
create PROCEDURE spUpdateASW AS
DECLARE @DataBatchID int DECLARE @DataHeaderID int DECLARE @ASWTableID int DECLARE @ASWTableName varchar(25) DECLARE @ASWFieldName varchar(25) DECLARE @AllowASWUpdate tinyint DECLARE @IsPrimaryKey tinyint DECLARE @DataTypeIsNumeric tinyint DECLARE @Data varchar(100)
DECLARE @SQL_Where as varchar(400) DECLARE @SQL_Insert as varchar(1000) DECLARE @SQL_InsertValues as varchar(400) DECLARE @SQL_Update as varchar(1000) DECLARE @updateCounter int DECLARE @whereCounter int DECLARE @SQL_CheckIfAlreadyExist as varchar(1000)
DECLARE @ErrorMessage varchar(500)
DECLARE @RuleWhen as varchar(50) DECLARE @RuleWhenToExec as varchar(500) DECLARE @tempStr as varchar(700)
DECLARE @server varchar(50) DECLARE @shortServer varchar(50) SET @server = 'GIBSON_A3MFGF_T1.S44E5797.A3MFGFT1' SET @shortServer = 'GIBSON_A3MFGF_T1' DECLARE @SQL varchar(5000)
select getdate(), 'testposition 1'
CREATE Table #tmptblUpdateASW( ASWRowAlreadyExists int, RuleWhenIsValid int ) INSERT INTO #tmptblUpdateASW(ASWRowAlreadyExists, RuleWhenIsValid) Values(-1, -1)
DECLARE Batch_Cursor CURSOR LOCAL FOR SELECT DataBatchID from tblDataBatch where DateConverted is not null and ASWUpdateStarted = 0 and DataBatchID not IN( select fkDataBatchID from tblDataHeader where DataHeaderID IN( select fkDataHeaderID from tblASWData where ConversionErrorMessage is not null ) ) OPEN Batch_Cursor
FETCH NEXT FROM Batch_Cursor INTO @DataBatchID WHILE @@FETCH_STATUS = 0 BEGIN Update tblDataBatch set ASWUpdateStarted = 1 where DataBatchID = @DataBatchID
DECLARE Header_Cursor CURSOR LOCAL FOR SELECT DataHeaderID from tblDataHeader inner join tblAgileFieldType on tblDataHeader.fkAgileFieldTypeID = tblAgileFieldType.AgileFieldTypeID where fkDataBatchID = @DataBatchID and isSentToASW = 0 order by tblAgileFieldType.InsertOrder OPEN Header_Cursor FETCH NEXT FROM Header_Cursor INTO @DataHeaderID WHILE @@FETCH_STATUS = 0 BEGIN DECLARE ASWTable_Cursor CURSOR LOCAL FOR SELECT ASWTableID, ASWTableName, RuleWhen from tblASWTable inner join tblASWField on tblASWTable.ASWTableID = tblASWField.fkASWTableID inner join tblASWData on tblASWField.ASWFieldID = tblASWData.fkASWFieldID where fkDataHeaderID = @DataHeaderID group by ASWTableID, ASWTableName, RuleWhen, InsertOrder order by InsertOrder OPEN ASWTable_Cursor FETCH NEXT FROM ASWTable_Cursor INTO @ASWTableID, @ASWTableName, @RuleWhen WHILE @@FETCH_STATUS = 0 BEGIN exec spBuildRuleString @DataHeaderID, @RuleWhen, @RuleWhenToExec output, 0
SET @tempStr = 'IF ' + @RuleWhenToExec + ' UPDATE #tmptblUpdateASW SET RuleWhenIsValid=1 ELSE UPDATE #tmptblUpdateASW SET RuleWhenIsValid=0' EXEC (@tempStr) IF (SELECT RuleWhenIsValid FROM #tmptblUpdateASW) = 1 BEGIN
set @ErrorMessage = null exec spASWDataCheck_hardCoded @DataHeaderID, @ErrorMessage output
SET @SQL_Insert = 'INSERT INTO ' + @server + '.' + @ASWTableName + '(' SET @SQL_InsertValues = 'VALUES(' SET @SQL_Update = 'UPDATE ' + @server + '.' + @ASWTableName + ' set ' SET @updateCounter = 0 SET @SQL_Where = ' WHERE ' SET @whereCounter = 0
DECLARE ASWField_Cursor CURSOR LOCAL FOR SELECT ASWFieldName, AllowASWUpdate, IsPrimaryKey, DataTypeIsNumeric, Data from tblASWField inner join tblASWData on tblASWField.ASWFieldID = tblASWData.fkASWFieldID where fkASWTableID = @ASWTableID and fkDataHeaderID = @DataHeaderID OPEN ASWField_Cursor FETCH NEXT FROM ASWField_Cursor INTO @ASWFieldName, @AllowASWUpdate, @IsPrimaryKey, @DataTypeIsNumeric, @Data select getdate(), 'testposition 2' WHILE @@FETCH_STATUS = 0 BEGIN select getdate(), @ASWFieldName, 'testposition 3' set @Data = replace(@Data, char(39), char(39) + char(39)) if @DataTypeIsNumeric = 0 set @Data = char(39) + @Data + char(39)
set @SQL_Insert = @SQL_Insert + @ASWFieldName + ', ' set @SQL_InsertValues = @SQL_InsertValues + @Data + ', ' IF @AllowASWUpdate = 1 BEGIN set @SQL_Update = @SQL_Update + @ASWFieldName + ' = ' + @Data + ', ' set @updateCounter = @updateCounter + 1 END IF @IsPrimaryKey = 1 BEGIN set @SQL_Where = @SQL_Where + @ASWFieldName + ' = ' + @Data + ' and ' SET @whereCounter = @whereCounter + 1 END
FETCH NEXT FROM ASWField_Cursor INTO @ASWFieldName, @AllowASWUpdate, @IsPrimaryKey, @DataTypeIsNumeric, @Data END select getdate(), 'testposition 4' CLOSE ASWField_Cursor DEALLOCATE ASWField_Cursor
IF @whereCounter = 0 begin insert into tblASWUpdateLog(LogTime, fkDataHeaderID, fkASWTableID, ASWAction, ErrorMessage) values(getDate(), @DataHeaderID, @ASWTableID, '(allvarligt fel. Inget skickades till ASW)', 'Fel! Inga primary keys var valda för denna tabellen!') end ELSE IF (select ASWRowAlreadyExists from #tmptblUpdateASW) > 1 begin insert into tblASWUpdateLog(LogTime, fkDataHeaderID, fkASWTableID, ASWAction, ErrorMessage) values(getDate(), @DataHeaderID, @ASWTableID, '(allvarligt fel. Inget skickades till ASW)', 'Fel! Kombinationen av primary keys genererade följande where-sats: ' + @SQL_Where) end ELSE IF (select ASWRowAlreadyExists from #tmptblUpdateASW) = 1 and @updateCounter > 0 begin EXEC(@SQL_Update) insert into tblASWUpdateLog(LogTime, fkDataHeaderID, fkASWTableID, ASWAction, ErrorMessage) values(getDate(), @DataHeaderID, @ASWTableID, @SQL_Update, @ErrorMessage) update tblDataHeader set isSentToASW = 1 where DataHeaderID = @DataHeaderID end ELSE IF (select ASWRowAlreadyExists from #tmptblUpdateASW) = 0 begin EXEC(@SQL_Insert) insert into tblASWUpdateLog(LogTime, fkDataHeaderID, fkASWTableID, ASWAction, ErrorMessage) values(getDate(), @DataHeaderID, @ASWTableID, @SQL_Insert, @ErrorMessage) update tblDataHeader set isSentToASW = 1 where DataHeaderID = @DataHeaderID end
END
FETCH NEXT FROM ASWTable_Cursor INTO @ASWTableID, @ASWTableName, @RuleWhen END CLOSE ASWTable_Cursor DEALLOCATE ASWTable_Cursor
FETCH NEXT FROM Header_Cursor INTO @DataHeaderID END CLOSE Header_Cursor DEALLOCATE Header_Cursor
UPDATE tblDataBatch set DateToASW = getDate() where DataBatchID = @DataBatchID
FETCH NEXT FROM Batch_Cursor INTO @DataBatchID END CLOSE Batch_Cursor DEALLOCATE Batch_Cursor
Hi there!!! We got problem on sql server 2k, Sql server stops unknowingly, and all user database has marked as Suspect/Offline, and later on, after sql server stops, all user database has been detached. what is going on????
Dear Group,I am tring to use a command that calls the server to fill an adapter, itnever seems to get to the adapter, command and the server either times outor does not respond. The timeout is set at 10 hours. I am using VisualStudio to acces MS SQL - Server.I think I have all the rights and permissions set correctly. Also, I haveused this command to fill other adapters and tables.Does anyone have a suggestion.Jeff Magouirk
I have a very weird issue in my latest package. I run it and it just randomly stops. When I watch it in debug mode or not in debugging a command prompt window will flash for an instant (too fast to read) and then the package will stop. It stops inside of a for each loop and the "on completion" is never fired for the loop. I never receive any errors - its just like someone hit the stop button. Sometimes it will process hundreds of files before stopping, other times only a few. (And its not stopping on the same file each time.. it doesn't appear to be related to the file at all)
Any ideas what could be going on? How to troubleshoot?
Have a task that has 120 tables (components) that I am running in debug mode. Just over half of the components run which takes btrieve db and converts into a sybase db. When it stops running there are a few components that are yellow, the components which completed are green and the rest are still white because they have ran yet. The problem is there is not a message to indicate as to why it stopped. I've broken up the task into two tasks and also tried making two projects. The same situation happens at the same point. Our dbas have checked the database to ensure that's fine and it is. Is there some sort of limitation in how many components can be run in debug mode?
Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.
Hi i have a page in which stock can be allocated, there are two boxes which have a product serial number start range and a product serial number end range, when these boxes are filled the "allocate" button is then clicked and the product will then be allocated the serial numbers. What i want to happen is that when the start and end ranges have been entered into the text boxes it will fail if any number within the range has already been allocated previously. E.g
Start Range
End Range
So lets say in the start range text box 15 is entered and in the end range 25 is entered, however 18 has already been allocated previously, this will then bring up a message saying please select another range; I have done the following so far;private void ValidateRange() { //String strSql;SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConnectionString"]); String strSql = "SELECT SqlCommand dbCommand4 = new SqlCommand(strSql, conn); dbCommand4.Parameters.Add("@Start_RangeID", txt_Start_Range.Text);dbCommand4.Parameters.Add("@End_RangeID", txt_End_Range.Text); dbCommand4.Connection = conn; conn.Open();SqlDataReader myDataReader = dbCommand4.ExecuteReader(); myDataReader.Read();if (txt_Start_Range.Text == Convert.ToString(myDataReader["Serial_No"])) {lblRange.Text = "Please enter a different range a portion of the selected values have already been allocated"; //Response.Redirect("Selectedfilm.aspx"); } else {Allocate(true); }
conn.Close();
}
My problem is constructing the select statement, thanks.
We are currently trying to install SQL Server 7 Enterprise edition using MS SELECT CDs. The install wizard stops at the beginning telling us that the used CD can only be used to install SQL Server clients with this computer although we used exactly this CD-ROM to install all other SQL Servers, too.
Did anybody have the same problem and knows what the reason for the abortion is?
I have a stored procedure that is calling a cursor to populate some variables it then uses those variable to get more information and then inserts that info into a final table. The estimated number of records that it should insert is around 2 million. The procedure stops after about 6000 records inserted. It still apears to be running but in fact is not. Can anyone help? I have also attached the code.
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO
and (som.sotype not in ( select value from table1_param where name = 'sotype') or som.sotype is null)
and (som.sostat not in ( select value from table1_param where name = 'somstat') or som.sostat is null) and arc.arckey = som.arckey
and (arc.code not in ( select value from table1_param where name = 'code') or arc.code is null) and (arc.slsvol not in ( select value from table1_param where name = 'slsvol') or arc.slsvol is null)
and arc.foreign_ = 0 and sot.somkey = som.somkey
and (sot.sostat not in ( select value from table1_param where name = 'sotstat') or sot.sostat is null) and sot.item > '0100' and sub.subkey =* sot.subkey order by arc.arckey,som.ctckey,sot.invkey,sub.subkey,sot.rq date desc
-- BEGIN PROCESSING THE CURSOR DATA HERE
OPEN v_mast
--pull all somast records where custno isn't 121449 or 1364166 --and sotype filtered and sostat isnot filtered
set @v_loop = 0 fetch next from v_mast into @v_arckey, @v_invkey, @v_item, @v_price, @v_qtyord, @v_qtyshp, @v_ctckey, @v_somkey, @v_ordate, @v_arcphone, @v_arcfaxno, @v_salesmn2, @v_country, @v_arcsource, @v_slsvol, @v_type, @v_specialty, @v_numdrs, @v_bedsize, @v_numlives, @v_code, @v_arcdorenew, @v_company, @v_address1, @v_address2, @v_city, @v_state, @v_zip, @v_eupdate, @v_doupdate, @v_subkey, @v_subtype, @v_startdate, @v_term, @v_status, @v_statdate, @v_xrenewed, @v_sbsdorenew, @v_shpamt, @v_somsource, @v_pmeth, @v_ctckey_sbsubs, @v_updonly, @v_disc, @v_arcdofax, @v_ponum, @v_arcdomail, @v_arcdophone while @@fetch_status = 0--for v_rec in v_mast loop Begin set @v_loop = @v_loop + 1 set @v_expdate = dateadd(month,@v_term,@v_startdate) - 1 set @v_keycode = ''
--select company, address1, address2, city, state, zip --from cmcship --where ctckey = @v_ctckey
--if (@@rowcount = 0) --set @v_tmp = null --else --begin begin tran t1 set @v_company = (select top 1 company from cmcship where ctckey = @v_ctckey) set @v_address1 = (select top 1 address1 from cmcship where ctckey = @v_ctckey) set @v_address2 = (select top 1 address2 from cmcship where ctckey = @v_ctckey) set @v_city = (select top 1 city from cmcship where ctckey = @v_ctckey) set @v_state = (select top 1 state from cmcship where ctckey = @v_ctckey) set @v_zip = (select top 1 zip from cmcship where ctckey = @v_ctckey) commit tran t1 --end
--select company, address1, address2, city, state, zip --from cmcadd --where ctckey = @v_ctckey
--if (@@rowcount = 0) --set @v_tmp = null --else --begin begin tran t2 set @v_company = (select top 1 company from cmcadd where ctckey = @v_ctckey) set @v_address1 = (select top 1 address1 from cmcadd where ctckey = @v_ctckey) set @v_address2 = (select top 1 address2 from cmcadd where ctckey = @v_ctckey) set @v_city = (select top 1 city from cmcadd where ctckey = @v_ctckey) set @v_state = (select top 1 state from cmcadd where ctckey = @v_ctckey) set @v_zip = (select top 1 zip from cmcadd where ctckey = @v_ctckey) commit tran t2 --end
--if (@@rowcount = 0) --RAISERROR ('cmc not found', 16, 1) --else --Begin begin tran t3 set @v_fname = (select top 1 fname from cmctac where ctckey = @v_ctckey) set @v_contact = (select top 1 contact from cmctac where ctckey = @v_ctckey) set @v_title = (select top 1 title from cmctac where ctckey = @v_ctckey) set @v_salut = (select top 1 salut from cmctac where ctckey = @v_ctckey) set @v_degree = (select top 1 degree from cmctac where ctckey = @v_ctckey) set @v_cmcphone = (select top 1 phone from cmctac where ctckey = @v_ctckey) set @v_cmcfaxno = (select top 1 faxno from cmctac where ctckey = @v_ctckey) set @v_ttl_code = (select top 1 ttl_code from cmctac where ctckey = @v_ctckey) set @v_cmcdorenew = (select top 1 dorenew from cmctac where ctckey = @v_ctckey) set @v_ctype = (select top 1 ctype from cmctac where ctckey = @v_ctckey) set @v_email = (select top 1 email from cmctac where ctckey = @v_ctckey) set @v_cmcdofax = (select top 1 dofax from cmctac where ctckey = @v_ctckey) set @v_cmcdomail = (select top 1 domail from cmctac where ctckey = @v_ctckey) set @v_email_info = (select top 1 email_info from cmctac where ctckey = @v_ctckey) set @v_emailpromo = (select top 1 emailpromo from cmctac where ctckey = @v_ctckey) set @v_cmcdophone = (select top 1 docall from cmctac where ctckey = @v_ctckey) commit tran t3 --end
--select acronym, brand from invhead --where invkey = @v_invkey
--if (@@cursor_rows = 0) --set @v_tmp = null --else --begin begin tran t4 set @v_acronym = (select top 1 acronym from invhead where invkey = @v_invkey) set @v_brand = (select top 1 brand from invhead where invkey = @v_invkey) commit tran t4 --end
set @v_amt = ((@v_qtyshp+@v_qtyord)*@v_price *(100-@v_disc))*.01
if @v_amt < 0 set @v_extprice = round(@v_amt,2) else set @v_extprice = round(@v_amt,2)
if (@v_arcdomail = 0 or @v_cmcdomail = 0) set @v_domail = 0 else set @v_domail = 1
if (@v_arcdofax = 0 or @v_cmcdofax = 0) set @v_dofax = 0 else set @v_dofax = 1
if (@v_arcdophone = 0 or @v_cmcdophone = 0) set @v_dophone = 0 else set @v_dophone = 1
if ((@v_arcdorenew = 0 or @v_cmcdorenew = 0) or @v_sbsdorenew = 0) set @v_dorenew = 0 else set @v_dorenew = 1
Hello, I have 2 servers with the same software (win2k, sql 2000 sp3) and the same data on them. The older server is working fine, but the new one that I am trying to use will run fine for a various amount of time and then stop responding. I am confused because when it does this I can pull up the task manager and see that there is plenty of memory and cpu left, and there are no error messages up on the screen. The only way that I can get the server to respond again is to restart the system. The problem never happens at the same time of day and it doesn't matter how long it has been since the last reboot, could be 5 minutes, could be 5 hours. If anyone has any ideas on what could be causing this, any replies are appreciated. The new system is a dell 2600, 2G Ram, Xeon processor, win2k.
I am trying to move SQLMail from a standard SQL 6.5 server to a virtual clustered SQL Server. The exchange profile has been set up and the services are running on a domain login. Exchange is also running as a clustered service which is being used successfully from the standalone SQL Server with SQL Mail.
However, when the SQL Mail service is started on the Clustered SQL Server, the service starts for about 5 seconds and then stops. The logs report that SQL Mail started but no messages are recorded to state that why the service has stopped again.
I've got a couple of jobs who have a odbc connection to a AS400 machine. But when these jobs run they won't stop anymore. I've got to stop these jobs manually so that the next day the jobs can start again as scheduled. The jobs did run all the packages succesfully. Does somebody know how this is possible? It did work fine but since a couple of weeks they just won't stop anymore. I hope you can help me! :S
I have Oracle 9i. Oracle listener is aborting by itself after every few minutes giving TNSLSNR.exe failed. While listener is running I can do all the activity on the database.