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!

Register Log in
  • Congratulations derfloh 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. elmo29

    Error Handling

    suppose I have the follwoing error raiserror 50000 'Error Message' This is in a sproc. I use this sproc within others to essentially return the same data each time, i.e. web site, view stats, now invoice In the web site and stats I need this error to be raised, however in the invoice I would...
  2. elmo29

    Webbrowser - Security Problem

    Can anyone help I have NT security on a web site, each user needs to log in separately to the site, however it saves the user name and password from the previous user under the web browser (if you shut IE down it prompts again). Is there anyway I can get the webbrowser to prompt for user name...
  3. elmo29

    SQL -> HTTP

    Some companies have information requests via url sites where you pass in parameters and get information out. My company does a similar thing, where we have to interface with out clients via http. Say with something like coldfusion you need to pass parameters in via the url i.e...
  4. elmo29

    SQL -> HTTP

    Is it at all possible to send a http req through SQL server?? ie. I send parameters from SQL server to the http server via a url address?? Any ideas would be appreciated :O) Lynsey
  5. elmo29

    Temp Tables & UDFs - SQL Server 2000

    WOuld these work in a similar way to temp tables - i.e. private to the connection only??
  6. elmo29

    Temp Tables & UDFs - SQL Server 2000

    I have a question. You cannot use Temp tables in a UDF. What are the implications of this?? I wanted to created a UDF which needed to return a table based of several tables created on the fly. I made them temp tables as each connection has different data created on the fly - and obviously I...
  7. elmo29

    Password Protect A Table

    Most of my code goes through stored procedures. But how do I stop them going to the raw data and not using the stored procedures when they are actually using the computer the database is stored on?
  8. elmo29

    Password Protect A Table

    Is there any way in which I can hide/password protect a table in SQL Server 7.0 or 2000? I have some information in there which I don't want people messing with, but some bright sparks are going directly into the table on the computer in which the table is on and altering the values to suit...
  9. elmo29

    right string function

    right(rtrim(phonenumber),5) works!!! hadnt realised there were spaces thank you!!
  10. elmo29

    right string function

    All phonenumbers are 11 characters. I get for example: 00000,11,01212100000 01, 11, 01212100001 02, 11, 01212100002 010, 11, 01212100010 if I do a left(phonenumber,5) I always get 5 digits eg '012121' it seems very bizarre...... if I do len(right(phonenumber,5)) I dont get 5 back Any help??
  11. elmo29

    right string function

    I have a phonenumber field and I want to get the last five digits, so I am using the following right(phonenumber,5) This works on most of my tables except one, where I get the following 00000 01 02 03 04 0100 etc Anyone know what this is all about and why I am getting this instead of 5...
  12. elmo29

    Stopping a Stored Procedure From Running

    I am really looking for a server setting (SQL Server 7), something that will monitor the sproc and disconnect if it is running for longer than a minute. Within the sproc I am running a program from a cmdshell. This is part of the sproc that takes the longest and this is the action I want to...
  13. elmo29

    Stopping a Stored Procedure From Running

    Is there any way in which you can stop a stored procedure from running. i.e. If any stored procedure has been running for over 1 min, timeout the stored procedure?????
  14. elmo29

    Timing out a Sproc

    Does anyone know if it is possible to stop a stored procedure from running after a certain period of time? I have a exec and I want to run it from another - it is accessing a web page and I want to be able to stop the access if it hasn't got the information within a certain time. I know you...
  15. elmo29

    HOW DO I DEFAULT DATETIME FIELD TO '12:00AM'

    I have in the past used declare @date datetime set @date = convert(nvarchar,getdate(),102) to get the current date excluding time.
  16. elmo29

    Connection to MS SQL using DAO

    ADO tends to be the one most people use to connect to SQL Server.
  17. elmo29

    SQL Statement (Easy one!)

    Whats the error? + is usally put in to make things more readable. if you try adding print @sql before you excute it, you will be able to see what sql statement you are running ... sometimes it can be something daft like your string is not large enough and has been truncated .... since your...
  18. elmo29

    Check If A Connection Is Active

    What I am really talking about is if the connection goes down between the linked servers - like when you reboot the machine etc, it would be good it I could determine that the link has been lost and redirect the information elsewhere. it seems to me the code you have just checks that there...
  19. elmo29

    Check If A Connection Is Active

    Is there any way to check if a connection between 2 SQL Servers exists. For instance I don't want a sproc to be run unless a connection exists (i.e it could be broken by resetting the computer etc). Is there any way I can do this within code so I can deal with this type of scenario??
  20. elmo29

    SQL Mail Exchange Server

    Hi, I don't know if anyone can shed light on this problem I have discovered. I have a lan of 5 computers all running SQL Server databases. All these computers interact with the data on the others. One of these computers has exchange server installed which sends out all the emails via an...

Part and Inventory Search

Back
Top