Search results for query: *

brilliant ! thanks

...should always stay the same) restore filelistonly from disk='\\liveservername\E$\crm_backups\crmlive\crmlive_db_200512190200.BAK' /* SQL RestoreCRM_Live_to_Train.sql Author * Date Written 19 December 2005 Amendments */ use master go restore filelistonly from...

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...

...ON tblCustomer_ISB_1.custID = vwCustomers.CUSTOMERID AND tblCustomer_ISB_1.Sdate <> vwCustomers.SDATE this is the error -----------------------------*/ Server: Msg 107, Level 16, State 3, Line 2 The column prefix 'vwCustomers' does not match with a table name or alias name used in the query.

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...

thank you both.............

hi i have written an insert statement which then reults the id using Set MyRS = Server.CreateObject("ADODB.Recordset") MyRS.Open SQLstmt, dbconnSQL SQLstmt = "SELECT @@Identity FROM dbo.user_request" Set myRS = dbconnSQL.Execute(SQLstmt) varNewID = myRS(0) how can i put the value in an...

the email now goes ok , although it still says Error process request : ??? thanks rich function SendMyMail() Dim Mail Set Mail = Server.CreateObject("Persits.MailSender") Mail.Host = Application("ASPEMailServer") Mail.From = Application("EmailFromAddress") ' From address...

...of the mail server and port 25 nothing happens when i run my asp page ! any help appreciated rich <script runat=server language=vbscript> '************************************************** 'VERSION = 1 '************************************************** Function...

sorted it thanks using Response.Write "<script language=javascript>" & vbLf Response.Write "var arrTargets1 = new Array();" & vbLf while not rsWebLink.eof if CLng(rsWebLink("ServiceID")) > 1 then Response.Write "arrTargets1[" & rsWebLink("ServiceID") & "]='" & rsWebLink("WebLink") &...