Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ben1234zz

    VARCHAR(MAX) limited to 1000 Chars?

    Hi Thank you for your post. I have fallen foul of writing a trigger for a single row update and having it fail on multiple rows. Its a good one to be cautious of! Fortunately this trigger is good for multiple record transactions. Thank you again. B
  2. ben1234zz

    VARCHAR(MAX) limited to 1000 Chars?

    Thanks for your post. When you said 'somewhere else' it prompted me to think triggers! I stupidly created a VARCHAR(1000) variable in the trigger! Thank you so much. B
  3. ben1234zz

    VARCHAR(MAX) limited to 1000 Chars?

    Hi We have a VARCHAR(MAX) variable updating data in a VARCHAR(MAX) field but it appears to truncate the data at 1000 chars with no error. The data being loaded is HTML if that makes any difference. I am stumpted, I have checked the coding over and over but cannot see any errors. Any...
  4. ben1234zz

    Optimising SQL Server Requests from VB / ASP .NET

    Hi We are trying to optimise a web page by reducing the number of sql requests. We have 4 repeaters on the page displaying: Search Results (SQL: SELECT TOP 25 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Product ASC) as RK FROM View_Products WHERE Code > 200) as a WHERE rk >= 2) Manufacturer...
  5. ben1234zz

    Reset handset problem

    Hi Thanks again for your posts: tlpeter: unfortunately not, the static IP were entered originally and this is what we are looking to change. amriddle01 & CarGoSki: thanks, we did do this before, but its always good to try again: we have done so but no luck. Thanks B
  6. ben1234zz

    Reset handset problem

    Hi Thank you for your posts: "What are you failing to tell us? At some point was your 46xxsettings.txt modified from default?" Yes it has been modified, this is our test system, unfortunately various team members have modified the file to test configs. Unfortunately I could not tell you...
  7. ben1234zz

    Reset handset problem

    Hi No it says nothing when you do this. Thanks B
  8. ben1234zz

    Reset handset problem

    Hi Thanks for your post. Yes headset is deactivated, but still no luck. Thanks B
  9. ben1234zz

    Reset handset problem

    Hi Thanks for your post Yes both Hold/Mute 25327 and Hold/Mute 73738 B
  10. ben1234zz

    Reset handset problem

    Hi We have a 4625SW IP phone which we setup on our test IP Office with static configuration on the handset. Now we want to use it in production the handset does not give us the option to change the static values (no * on boot). So we have decided to reset it, no luck there it just does not...
  11. ben1234zz

    Open form criteria between dates

    Sorry for not explaining the whole story... And thanks for your posts: They are SQL Server DATETIME fields. Its an ADP Acutally I made it work by using this code: stLinkCriteria = "([DateCreated] BETWEEN '" & Format(DateAdd("d", -7, Date), "yyyymmdd") & "' AND '" & Format(Date, "yyyymmdd")...
  12. ben1234zz

    Open form criteria between dates

    Hi Thank you both, dhookom i have amended as you say however the error still returns. PHV i get the error 'Date' is not a recognized built-in function name. This maybe because we are running an SQL Server backend. Thanks B
  13. ben1234zz

    Open form criteria between dates

    Hi We are trying to open a form showing items from the last 7 days, we have the below VBA criteria: stLinkCriteria = "([DateCreated] BETWEEN #" & Format(DateAdd("d", -7, Date), "d/m/yyyy") & _ "# AND #" & Format(Date, "d/m/yyyy") & "#) OR ([InvoiceDate] BETWEEN #" & _...
  14. ben1234zz

    Requery Updating Dirty Record

    Hi, Thank you for your post. Because the SP has updated the data shown in the original form. Thanks B
  15. ben1234zz

    Requery Updating Dirty Record

    Hi We have a form that opens another form. The other form runs a stored procedure against the back-end SQL Server then closes, when it closes it requeries the original form. The SP amends the record open in the main form. Unforunately during the requery appears to write the dirty data in the...
  16. ben1234zz

    Connect to Different Server

    Hi We have a remote webserver running SQL Server 2005 that we need to connect to using TSQL and execute 2 SP's from our office SQL Server 2005. We access the webserver using an IP address & different port number i.e. xxx.xxx.xxx.xx,1192 (the web server is not on our domain) Is there any way...
  17. ben1234zz

    Diag extension removed / plugged in

    Hi We have one extension installed today on a remote site (5610SW IP) and are receiving regular alerts from the system that it has been removed then plugged in (every 2 minutes). Here is the spec: Main Site: IP Office SOE Router: Draytek 3300v ..... Lan to Lan VPN ..... Remote Site...
  18. ben1234zz

    Create Primary Key on View (for full-text index)

    Hi We need to create a primary key / unique column on a view so that we can create a full-text index. I am struggling to do so, any advice would be much appreciated. Thanks B PS: SQL Server Standard 2005
  19. ben1234zz

    Add SATA to PE2900 with SAS

    Hi We have a PE2900 running 6 SAS drives attached to a PERC 5/i. We are looking to add some cheap storage to the server and would like to add two 1TB SATA drives as RAID 1 to keep costs down. Am I right in saying that the SAS drives are 2.5" and SATA is 3.5"? If so is there any way of doing...
  20. ben1234zz

    Line Break in text box on report not showing

    Yes to both, its taller than required and can grow is true.

Part and Inventory Search

Back
Top