Recent content by elmo29

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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