We have been using, as per business specs, SQL 7.0 & xp_sendmail to lotus notes client 5.0.8 for sql mail into notes. Upon upgrading to SQL 2000 this does not work as before. Have tried other options and am aware that the other options may work better, but for now must stick with business ...more >>

Hi Does any body know a sql statement that would retrieve the table names within a database. Kindly note that I just want to retrieve the list of the tables within a database... Thanks Jamie Waters.. ...more >>

Hi, I guess this is the right group to ask this question. I have a problem with response time inside SQL server enterprise manager. I have installed SQL Server 2000 Developer edition. I reinstalled it several times and nothing changed. For example clicking '+' to 'Databases' (to expand it an...more >>

Hi, I am posting to this group because I have a problem. There is a system that is build to provide a database access across the internet and uses C to deal with queries on the Microsoft SQL server. The problem is that the database does not work on windows 2000, whereas on every other windows ...more >>

My plan is to run SQL Server Enterprise on the same computer as my development environment (PowerBuilder). Since I am not connecting to the database from PB, it looks like I have not installed SQL Server correctly. I selected the option to install "client and server" and not "client tool...more >>

The type library has the following constant values: SQLDMOObj_UserDefinedDatatype = 1 SQLDMOObj_UserDefinedFunction = 4096 However on returning, for example, child dependencies for a table through a call to EnumDependencies, functions are being returned with a type of 1. However, if I ...more >>

I have linked a server called OSERV in enterprise manager. The following works fine in Query Analyzer Select * From OSERV..OSERV.EAME_PRODUCTS_COSTS As A Where A.PRODUCT_CODE = 20001 However this will not select * from openquery(OSERV, 'select * from EAME_PRODUCTS_COSTS') What is the ...more >>

Client is MS Access 2000. Server is SQL Server 2000. Is there any way of knowing which users are connected to SQL Server at any one time i.e. Machine name, User Name etc If this is not an existing feature of SQL Server 2000, can anyone provide the method/s that can be used to access this...more >>

Hi, After i loaded informatica power center on my machine. i am not able to open ms sql server\ Enterprise Manager, getting the following msg. --------------------------- Microsoft Management Console --------------------------- Snap-in failed to initialize. Name:Microsof...more >>

Ok, I just set up Microsoft SQL Server 2000 Standard Edition. I have it on a server running Windows 2000 Server. I then put it on one computer running Windows 2000 Pro. When I open an Access database and I try to run the upsize wizzard to convert the database into SQL I click tools -> d...more >>

Hi there, Just wondering is there anyway to secure a MSDE mdf file, so if it got stolen, no other MSDE will be able to attach and open databases in it. Can it be password protected? I tried to stop the MSDE on a desktop machine and copy a mdf file to another machine, and I was able to atta...more >>

Hi I have very little understanding of SQLserver issues. I have been trying to write a program that reads data from one SQLserver and shows the results on a webpage. To accomplish this task I have "compt1" which has the SQLserver 2000 on it and "compt2" were my IIS and webpage is located with...more >>