Recent content by richey1

brilliant ! thanks

Hi I have the following stored procedure which runs overnight. runs ok................but for both lines that hardcodes a filename I'd like to be able to use a variable for the bak name - the backup runs every morning so this morning's was 200512190200, tomorrows will be 200512200200 etc etc...

thanks thats how i have set it - up - seems ok now........

Hi I have a website running through IIS, for which I've set it in its own application pool. The website is an asp front-end with a sql back-end - there will be a guaranteed 20 or so people on it all day (7/8 hours) and anything up to 30/40 people working on it sometime throughout the day. On 2...

sorry for the delay in replying. the problem was the index on column CustID was not set to unique values. thanks

ok so..... update ServerB.EnvSystem.dbo.tblCustomer_ISB set SDate=T2.SDate from ServerB.EnvSystem.dbo.tblCustomer_ISB T1 inner join vwCustomers T2 on T1.CustID=T2.CustomerID where T1.SDate <> T2.SDate works ok but (if i try a multiple set) it fails with error code ? still need it within an...

this is the update code (the select bit works ok on its own) use databaseA update ServerB.EnvSystem.dbo.tblCustomer_ISB set ServerB.EnvSystem.dbo.tblCustomer_ISB.CustID = vwCustomers.CUSTOMERID SELECT vwCustomers.CUSTOMERID, vwCustomers.SDATE FROM...

thanks i take your point about the loop. I was more wondering about fitting it together as a stored procedure. I've created a linked server between server a and b - the job will run from server a, the update will happen on server b. I know thats worked ok because I've tried a simple select...

i'd like to have a stored procedure which either performs a bulk insert, bulk update or does nothing from a table on one server (CTS_CUSTOMERS - ServerA) to another on a different server (CTS_CUSTOMERS - ServerB) firstly if the record does not exist on serverB then insert it from serverA...

I came up with the code below which is what i wanted..............my vote is a no for the yellow by the way ! thanks kim Response.Write "var arrTargets3 = new Array();" & vbLf while not rsWebLink.eof if CLng(rsWebLink("CompTypeID")) >= 0 then Response.Write "arrTargets3[" &...

Hi I have a combo box on an asp form, which reads values from a sql database using a sub and a function in an include file as below Sub getPestTypes(oRS) On Error Resume Next if Err.number=0 then set oRS = ExecQueryRS_X("CONN_Z","SELECT compTypeID, varIndicator,varCompType, varCost_Dom...

thanks for that I have trie, in my asp, using the code below - still works ok, but if if do put in the datasource name to be purposely wrong, then i get [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. -2147467259 Microsoft OLE DB Provider for SQL Server...

thanks jon that will do for me........

Hi We have an application on one server (server A), which in its global.asa file specifies a connection to another sql server using Application("Conn_Z") = "driver={SQL Server};server=Istanbul;database=Envsystem;uid=???;pwd=???" I use abit of custom code as follows ExecQuery_X...

Hi didn't know what forum to post in, but there is some kind of xml link !?! if you were applying for a job and you wanted the person to have .net knowledge (especially asp.net) and then knowledge of biztalk ,web services, biztalk alternatives etc - is there a generic term to give all those...