Search results for query: *

I have an older model MESH ATX Tower and recently it would not turn on - i pressed the power switch on front of case and absolutely nothing happened. I bought a new power supply and still nothing. By process of elimination i think it must be the power button / lead on front of PC, as i can short...

Hi, i have an Excel 2000 Workbook that connects to a SQL Server 2000 database and also runs quite a bit of Excel VBA behind the scenes to call Stored Procedures and run SQL against the database. The problem i have is that when 3 or 4 Users open the Workbook at the same time it seems to be...

Recently i have had the problem of having no mouse when booting Win2K SP04. It only happens occasionally but the only fix seems to be a reboot and then it appears. When it's gone, the "Hardware" tab in Mouse properties in Control Panel shows nothing (i.e. loses it's entry), but after a reboot...

Hi , i have been given an Excel 2000 application to support and all our new office PC's are running Excel 2002 / 2003. The application uses quite a lot of VBA behind the scenes, and when i try to load the app on the new PC's, i get "RunTime Error 438" (and also "RunTime Error 57121" after i...

Can anyone tell me if there is a maximum DTS Package Log File Size, and if so what is it and can you change it ?. Also are there any consequences of running the Package if the Log File is already the maximum size - presumably the Package fails, or atleast does not log ? Thanks for your help...

I have a Worksheet in a Workbook containing Hyperlinks to other Worksheets in the same Workbook. I want to prevent the Users using the arrow keys on the keyboard to move into the Cells containing Hyperlinks, and then typing over the Hyperlink Text. I have tried different combinations of...

Does anyone have any C#.net code to use the SQLDMO Library to obtain Job History for SQL Server Scheduled Jobs ? Thanks. mark.davies@npower.com

Apologies if this is something that I should know, but I was wondering if someone could explain to me why some Strings in SQL Server are preceeded with N'. For Example, in Books Online under "sp_addlinkedserver", the example says :- EXEC sp_addlinkedserver 'SEATTLESales', N'SQL Server' and...

I am wanting to make a copy of our VSS database available on a completely different Server, so that if our live Server goes down, we can still access up-to-date documents on the standby Server. I realise that I could just copy the main top-level folder and all it's sub-folders to the other...

I am getting the following error when trying to build a cube. All the Dimensions appear to build OK, but when it comes to do the final big SELECT to join the Dimensions to the Fact Table, it falls over. Does anybody have any ideas that I could try ?. Thanks for your help. :- Timeout occurred...

I am trying to write a DTS Package to import a text file. The file will always be Tab(or Comma)-delimited but the number of Fields may vary. What is the best way to create the package in order to make sure I get all the data, and also know what Fields i`ve pulled in ?. Should I just pull the...

I am trying to create an .exe in VB 6 and keep getting the following error :- "the dynamic link library mtxlnfr1.dll could not be found in the specified path C:\OS\System32\....." Any Ideas ? Thanks, Mark. itsmarkdavies@hotmail.com

I keep getting an error message when running a DTS Package. Only 1 Step out of 8 fails, and the failing Step does nothing apart from create an index on a table using T-SQL. Has anyone had similar problems, or can anyone tell me what is going wrong ?. The index builds quite happily if I grab the...

Can anyone tell me if there is a limit to the number of (or string length of) the @Recipients parameter to xp_sendmail ? I know you can put the Recipients into a varchar string and then pass this, but I would like to know if there is a limit to the number of Recipients you can string together...

Can anyone tell me what either of these Error Messages mean. They have cropped up in the History of a Job that I run on a nightly basis. They only occur very occasionally but I wondered how I can cater for them in any way ?. Thanks. Process Exit Code -1073741819 Process Exit Code 128 The full...

Can anyone tell me how to send an SMS to a mobile phone in the event of a failure of an SQL Server Job ?. Thanks for your time. itsmarkdavies@hotmail.com

Can anyone tell me the code I need to execute the Stored Procedure "sp_startjob" from within a SQL Server 2000 ActiveX script please ?. Thanks for your time. itsmarkdavies@hotmail.com

I have added stages to my Stored Procedure which call another Stored Procedure at various points to say whether the particular stage has been successful. The Stored Procedure that does the logging just writes TimeStamped text into an Audit Table, e.g. after a major insert in my main Stored...

Can anyone tell me if running the Microsoft Search Service impacts upon general Server performance, even if we are not using Full Text Search indexing on any of our Tables ?. Thanks. itsmarkdavies@hotmail.com

I am running an VBScript ActiveX script from a SQL Server 2000 Job Step. The Job runs fine and reports success, but the file I am trying to move does NOT move. Can anyone spot a flaw in my Script ?. Any ideas much appreciated. Script is as follows :- Function STAMP STAMP =...