Search results for query: *

Hiya I am trying to execute a COM objects method from T-SQL. I am using sp_OAcreate to create an instance - which is not producing an error. The Method expects 3 variables, int, string, string. and returns a 1 or 0. I am referencing it as below.. EXEC @hr = sp_OAMethod @object, 'OLogon'...

Hi I have an asp script that I need to execute as part of a SQL stored procedure, passing paramaters in between. Is this possible? Thank you kindly for any help. Regards, Brett

Hi I have previously been using cdonts and cdosys to send asp based mail - basically looping through a recordset of emails adresses and generating the body of the each email with the results of a query to the db using that email address. Hence each email is dynamically sent and generated. This...

Hi We are running a intranet fired up by IIS 5.0 (windows 2k)and have encountered a bizarre problem with one of my users. This user only has access to a certain part of the intranet but every time he brings up the appropriate URL - he is prompted for a password BUT his account locks out...

Hi I want to use a trigger to insert a row into a new table if one particular column (within that row) has been updated. How do I code the SQL SYNTAX for Insert 'Updated Row into new table' within the body of the trigger? Thank you kindly for your help. Brett

Hi I want to create a GPO for certain users and restrict them from accessing the internet. I have looked through the polocies and can only locate restricting levels of access and IE options but I want to restrict any internet access for this GPO. Can I deny access to the DNS servers maybe...

Hi I want to create one form that has an text entry for each record, the user to enter a value for each record in a seperate text box and have one submit button to process an db update for each record. I am very comfortable doing this for one record but unsure how to do it for many records...

Hi Can I export a SQL-Driven recordset directly to a excel spreadsheet, without use of a export wizard - i.e. through ASP code? Thanks in advance for your help, Regards, Brett

Hi, Im looking for an application that will automatically send emails as a result of SQL queries to a database. Ie, what I want to do is write a script that will generate email addresses every few hours through a query and pass those as paramaters to an email application that will email...

Hi, Im a dba and have not as yet indulged in the use of activex controls. I am now faced with building an front end to query the database and I would like to use the ActiveX calendar control to query over a date range. I have played around a little but do not really understand how I can...

Hi, Many thanks for your previous help. I have now come across a string of student names and surnames but I want to cut that to only be names. For example: name = john doe I want to run an update to let name = John How can I do this - look for whitespace and then include everything in the...

Hi, I have a list of names and I want to run a script that will update the first character to be upper case, I have tried this but get an error: update students set substring(name,1,1) = UPPER(substring(name,1,1)) How else can I do this? Many thanks for your help

Hi Yesterday afternoon my query analyser crashed and I have since restarted my computer a number of times, re-installed the application and the exe will still not run. Funny enough, the other SQL tools are running fine - it seems that the processes are firing but the exe is not running the...

Hi, I have a table that stores entries for counts every 10 minutes for each day. The day format is datetime and includes the time at 10 minute intervals, I want to group them by date and then sum the counts per date. Ive been trying to do this but cant find a suitable data type to convert...

Hi, Im trying to run a dts package within job but keep on getting the error message 'Non Sys Admins have been denied permission to run cmdexe jobs' However, Im running them from a Sys admin account! Where can I find the cmdexe settings? Many thanks. Brett

Hi, I have set up various DTS packages and want to give various other staff members access to run them on demand. I have tried to run them as a job but get the following error 'Non_sysadmins have been denied permission to run cmdexe job steps. The step failed' Eventhough I am running from my...

Hi, I wrote a SQL script that imports a list of names into a new table then loops through that list and updates their relevant columns based on a series of select and update statements. It works perfectly when I run it from SQL Query Analyser. I have tried to now run it as a stored procedure...