Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it. Why does the new 'TOP' command in SQL 7 not work? I get a syntax error. Also ALTER TABLE and other SQL 7 only commands.

The answer depend on what GRBackPro version you have installed. Version 5.x run on both Windows Workstation and Windows Server. Version 6.x has two different licenses: A Single User license for installation on Windows Workstation and a Server license for installation on a Windows Server. If you backup from a Windows Server edition then a Server license should be used for 4-5 users. If your server handle more users you need a Site license. This license has been created to handle companies.

Live Communications Server 2005 Enterprise Edition uses a separate physical SQL 2000 server as its presence registrar, a core component of its presence and IM architecture. A separate physical SQL 2000 Server and license is required before attempting to install Live Communications Server 2005 Enterprise Edition. See the Live Communications Server planning and quick start guides on the Live Communications Server Deployment Center for more information.

I went windows 2003 enterprise server several years ago when I set my system up. Just recently I realised that was the right choice when I had to go from 4 gigs of ram to 18 gigs. Make sure you can install more then 4 gigs of ram on whatever software you use because SQL can and will take advantage of the extra ram. HUGE performance boost since I added more ram. In addition, ideally when you go sql, you do not want to put exchange etc onto the same server.

I'm getting an error message - "Cannot Load DLL 'SDI' Reason 126 ( The specified Module Cannot be found)" when doing a stored-procedure debug on SQL Server. Or breakpoints just don't fire.

There is a bug in Office 2007 that must be fixed in order to be able to run Macros. Click on this link to install the Bug Fix. Firefox and Netscape - click on the link, save the file to your Desktop, click on the file on your Desktop

No, the licensing policy for SQLyog is client-based, not server-based. That means that you require one license for each PC that will have ...

No, you can do a clean install on the upgrade edition if you own the previous Windows Operating System (95 or 3.X), you will be asked to insert a number of your old disks or a CD for proof of purchase.

You can download a 30-day evaluation license by registering here or purchase a commercial license from Mainsoft sales.

Double click on the downloaded EXE file. You should be prompted to browse to the location of the database instance (Default location: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE). Once you have chosen the location the installer should automatically upgrade the service pack for SQL Server 2000. If the installer does not automatically upgrade the service pack or generates an error during the installation process, then you will need to do the following in order to complete the upgrade.

We provide a MS SQL login and password for your SQL database. Connect to the online SQL server using the Enterprise manager or our online SQL Manager to create tables. Install MS SQL 2000 on your local Windows NT machine and register the online SQL Server by.... And then this server would appear on your enterprise manager...Right click and CONNECT and then create your SQL tables.

If you need to process a large number of bookings or support more than 10 concurrent users you should licence another edition of SQL Server. If you already use SQL Server in your organisation then you should approach your IT Department and see if they would prefer you to use SQL Server. If neither of the above apply, then the Express edition will be an ideal starting point and you can always upgrade to SQL Server at a later stage.

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, redistributable version of SQL Server (and it is shipped with Timetabler 6). MSDE contains a workload governor designed to limit performance if the database engine receives more work than is typical of a small number of users. Installation of MSDE or SQLServer depends on your anticipated use of Timetabler.

No. At this time, Fast PDF is only offered as a service - we do not sell source code licenses. However, your needs can probably be satisfied by integrating Fast PDF as a sub-service into the software that is currently running on your server. This isn't terribly difficult; contact us for details.

The Plan Change Tool does not support this type of migration. Do not attempt to process this change as it will result in downtime and technical problems to the site. If you have any questions or concerns, contact Prestwood Support.

Unfortunately, the official specifications are not freely available (ANSI makes them available for purchase). However, there are books - such as SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer - which give a comprehensive overview of the standard, including coverage of stored procedures.

There are many different databases available (e.g. Access, SQL Server) and the reliability and scalability of them varies considerably. Booking Pro has been designed to be a very reliability solution and as such needed a reliable database. SQL Server offers high degrees of reliability and hence are natural choices for storing your valuable data. The Express edition is a scaled down version of SQL Server and only supports a small number of concurrent users.

Internet Connection Sharing (ICS), Metadirectory Services Support (MSS), Windows Media Services and the Internet Connection Firewall.