Search results for query: *

I have a query please. I have 2 databases, one SQL 2000 and one SQL 2005, When I right click on it and go to properties the is a field labelled "Space Available" and mine is 0.00 Mb. The system is working fine though. Also if I click on "Files" my "Autogrowth" column is set to By 20 Mb...

Is it possible to Restoring SQL 2005 DB into a SQL 2000 DB, and if so how do you do it as I am getting an error back every time I try? Thanks

Hi there I am a bit of a novice in this but hope you can help. I am use SQL 2005 and have a table with 4000 lines in it. One of the columns should be a number count from 1 to 4000. I would like to know how I could check with some sort of SQL script that there are no gaps within it, and if...

Hi I hope someone can help, I am not an expert with SQL so bare with me. I am using MSDE 2000 on an XP PC. I have been given a mdf file that I need to look at the data. So far I have created a database using enterprise manager of the same name as the mdf file, I then Stopped SQL and copied...

Hi I wonder if anyone can help me. I have an Access 97 database, with a date field in it. I have to come up with some code that will find the amount of "work" days (Monday to Friday) between this date and todays date and then take one off that number. I have not realy done any code on access...

Hi All I have written a macro in Excel 97 to open several XLS spreadsheets and extract the data. This works fine. We have now been moved to Citrix and the Office version is 2003. I have tried to run the same macro within Excel 2003 and it will not allow me to open the excel files. I have...

Quick Question is it possable to install 2 SCSI cards into one PC due to the different connects of SCSI 1 and SCSI 3

I have now got to code working below to send an attactment with a subject line and body. Although it will only work with a single e-mail address. if i put in the name ofa Distribution list it does not work. Can anyone give me any pointers how to sent the mail to a Distribution list. Sub...

I have a macro which will e-mail an Excel spreadsheet. I am using the line:- Application.Dialogs(xlDialogSendMail).Show I know there are arguments you can add to the end such as e-mail address, subject line. can anyone advice me on the way to do this, i need to include "E-Mail Group"...

Could someone please advice me on a bit of code to run in a macro that will check for the existance of 3 other excel spreadsheets before the macro trys to open them. thanks.

I am writing a VB macro in Excel 97, I have a column that should only hold 12 different strings E.g. A through to L. Can anyone advice me on a short peice of code that will check that there is nothing else in this column apart from what should be. (A to L) Thanks.

I am trying to copy an array into another array. I am using Excel 97 and writing a macro to do this. I have an array "NorthArray(100,19)" and I am trying to copy it to "TotalArray(100,19)". The line I used was NorthArray(100,19) = TotalArray(100,19) This did not work I have...

I am creating a macro to check if a particular worksheet exists. for example. if worksheet = "Name" then I can not find the syntax can anyone help. Thanks.

Could someone please help, How do you assign an IP address to a NIC card, using a command line if the MAC address is all that is known. Thanks.

I have just set up a backup to happern throught Enterprise Manager, I have set jobs up to backup the databases I have created. If I needed to do a full restore because of a system failure would these database be enough, or do I need to back up master, model, msdb, and tempdb. I am very new at...

I have two Cisco 1601 R Routers I am trying to connect back to back. I have connected the two serial Ports together with what I believe to be the correct cable. One half of the cable has "DCE" on it. This end of the cable has been plugged into Router1 Below is the configuration of Router one...

Hi I am currently testing some third-party software on Win XP Pro and my page file has grown to 1.75 Gig and still growing. Is there a utility that can tell me what is in the pagefile and how much space it is taking up. Thanks

I have a Windows 2000 Pro Virtual Machine, I have just installed SP4, then connected to the internet to do auto updates. It goes through until it reaches Security undate KB828741 and just sits there. When the VM is then restarted it will not run, it gets the the log on screen and keeps...

Could anyone please throw some light on a problem I have. I am not a programmer, I do not understand the code I am seeing, but I am in Tech support trying to figure out what is happening. We have a bespoke product that stores information into a Microsoft SLQ 2000 Database. We believe the...

This is not a progamming quesion, But could someone through some like on it. Our company writes its own software and the data is stored in an SQL 2000 database. I am looking at the database in Enterprise Manager and trying to delete an entry out of a table, but i keep getting an error message...