Search results for query: *

Without going into to much detail I am wondering if anybody has come across any issues running Stored Procedures compiled in SQL Server 7 via another PC which has SQL Server 2000 tools. The database being used is a SQL Server 7 database by the way. I have a problem that when running a procedure...

Operating System: Windows XP SP1 Modem: SpeedTouch 570 Problem: The wireless PC card I have purchased for my laptop will not register with my router (Speedtouch 570). I have removed all software, drivers and hardware and have re-installed. I have even formatted my hard disk but still cannot...

We have installed a VB application on separate machine and registered the associated dll's and ocx's but for some reason when running an export from within the app we get this 'ActiveX component can't create object error no 429'. There are a number of posts but nothing has worked so far. 1) I...

In my application I have a Data Entry grid which consists of 4 checkboxes, when tabbing through these checkboxes it automatically checks these. I don't want this to happen, I only want these to be checked if they are left-clicked on by the mouse. I have been trying to capture for this but am...

I have a job setup on SQL Server which basically runs a very big stored procedure. This normally takes 2-3 mins to complete but over a certain period it was taking 20 minutes. I have two backups of data (one when the procedure was only taking 2-3 mins, the other where it was taking 20 mins). I...

I have come across something very strange and is not helping with my investigation of an issue. I have a stored procedure and when I run it via an exec statement from Query Analyzer it takes 18 mins to complete. I restored the database to how it was before this procedure was run but this time...

We have an issue where one of the jobs running is now taking a considerably longer time to complete. All this job does is run a stored procedure via an exec statement. To query this procedure I have run a trace against it and am now examining the results (output to a table). Now calculating...

I am pretty new in regards to using Trace in SQL Profiler. Lookin at my results in the table the EventClass comes back as a number. Can this be linked to a system table to find out what event class this was, as in the text ? Also when looking at the associated TextData field a number of them...

I am running this basic select statement to get the output in XML format.. SELECT client_code, description FROM client FOR XML auto There should be 23 rows worth of data in the script but it seems to cut off after a specific amount of characters, hence not displaying all the data as a result...

CREATE PROCEDURE sp_rpt_data @xrefid integer, @order1 integer, @order2 integer, @order3 integer AS select sid.number, sid.date_of_call, sid.time_of_call from data sid where sid.station_xref_id = convert(varchar(6),@xrefid) order by @order1, @order2, @order3 I cannot create the above...

I'm having difficulty writing an UPDATE statement as I keep getting the error message "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." I can see the problem but I'm stuck on how I can...

I have a ctlDataEntry on my form and for the first row I have checked the option 'Force Combo List' on the Validation tab. This works fine if I attempt to enter any data that isn't in the combo list. But it does not pick up on blank entries i.e. nulls, blanks. Is there any property setting for...

Basically I have 4 tabs in my TabStrip. Is there any easy way to swap the order of two of them ? When I state order I mean to actually move it so for example what was the 3rd tab is now displayed as the 2nd tab ? Looking at the properties it doesn't look like you can do this easily. Unless...

I initially did a search on the exisiting forums and there is a few topics on this but they all relate to strings (varchar, char, etc.) I have an integer column where I would like to remove the leading zero (if there is one). I can find out what rows do have this but am getting puzzled in...

The Enterprise Manager I am using was configured by someone else and in the registration properties of the connection to the Server the login is sa. So I can login as sa, once I am logged in as sa is there anyway I can find out the password ?

There are a number of posts when it comes to date format but these all seem to be in regards to when writing SQL syntax. In Query Analyzer when I open any table that has a datetime column the format is "1999-04-01 00:00:00.000". How can I amend this so that it just reads DD-MM-YYYY i.e...

I need to incorporate a grant statement in my stored procedure because it is using dynamic SQL. The syntax I am entering is, grant select on tablename to "Admin Role" When running this on it's own it works fine. But when attempting to put in my stored procedure I get the error message...

I am trying to use the sp_change_users_login to see if it fixes an issue but I just can't get the syntax correct ? I get the following error when typing, EXEC sp_change_users_login 'Update_One', 'Developers', 'Developers' Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login...

I am getting a very strange issue occurring when granting and revoking permissions on Roles in my database. As part of the testing that I'm doing in a Role I revoked the EXEC permission on a stored procedure and when attempting to run the function in my VB app which referenced this procedure I...

I have picked up a problem where when my report is run the first row of data returns as blank. I have parameters setup to get data between two dates but the same problems happens each time regardless of what data i.e. dataset I use ?? Even running the stored procedure in SQL returns all the...