Search results for query: *

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

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

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

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

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

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

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

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

I have a cursor that scrolls through records using a group by statement and for each individual group it exports to a csv file all the records for that group and then emails it to a sales manager to check and then email onto a customer. Since it is for customer use - I really need the csv file...

I am exporting a query to a csv file using bcp. I would like to be able to also export the field names into the csv - which it is not doing... any ideas how you do this?? i.e. is there any syntax in the command string that lets you specify this which I don't know about?? They seem to give you...

i need to write text output query write more text to a file from SQL server 7 I am using bcp, is it possible in anyway for bcp to append to a file rather than just overwrite it? or is there any way where I can 'add' 2 files together using xp_cmdshell?? Any help appreciated Thanks

This may be a silly question but is there any way I can control which records I can return i.e. I need to be able to return the first n rows and then n+1 to 2n, 2n+1 to 3n etc is there any nice trick to return the groups in this sort of format or do I have to scroll though each record using a...

is it possible to access sql server on a remote machine from a dial up connection (using vb6) without sql server being installed on the local computer? - and how do you go about this - is RAS, RDO, TCP/IP etc the way to go? Thanks in advance :O)

Has anyone ever had an E_Fail status? Any ideas on what causes this and how you rectify it? This has happened on a test table of mine - and for future reference I would like to know how to prevent this or fix it if it occurs again on a live table. Thanks in advance

I not really sure where this problem is coming from. I have looked in numerous Microsoft articles and not really found anything applicable. I have a SQL Server DTS package that *should* be run every day on Windows NT 4.0 machine. Whenever I schedule it, it doesn't though. (Other DTS packages...

There may be no solution to this - but I thought it was worth an ask anyway When I am sending out mail using @query I can get it to return an SQL statement as a text file. The thing is, fussy person that I am - I don't like the way it returns it. I have messed about with @width and it solves...

I have a list of tariffs to apply to a phonenumber. The tariffs are dependent on the prefix of the phonenumber - which can be variable in length. So I have a table containing the phone number and a table containing the prefix .... how do I do a join on this? So I have 012160909808, field2...

I have an internal variable in a stored procedure holding the number of seconds between one number and another DECLARE @Variable int SET @variable = DATEDIFF(second, @date1, @date2) INSERT test(value)VALUES(@variable) gives me 0, while INSERT test(value)VALUES(DATEDIFF(second, @date1...