Viewing 15 posts - 91 through 105 (of 325 total)
of couse not ... MSDE is free .. but in SQL Server 2000 Developer you pay many to get licence (per seat [cheap] or per server)
June 23, 2004 at 8:05 am
here is wat you want:
How can I completely uninstall SQL Server?
If the standard un-install utility doesn't do the trick for some reason :-
Remove the...
June 23, 2004 at 3:27 am
you can install (client tools) which include EM from any SQL Server CD .. by moving in installation as you make a server .. but choose (client tools)
I hope this help...
June 23, 2004 at 2:55 am
why you get tables names from msysobjects ?
there is another solution .. to put names of your tables into a new table and query this table ...
June 23, 2004 at 2:23 am
this problem happens to me before because I install MSDE .. then remove it then install SQL Server 2000 Developer edition.
I think the problem happened because of comparing OLE DB...
June 22, 2004 at 6:58 am
yes you have to make full bakup daily .. and bakup log every 1 hour .. so your transaction log does not grow by large amount.
June 22, 2004 at 6:32 am
I want to ask Kevin about his idea of File DSN ... does it support a lot of user connected to it (above 30 users) without crashing?
also is it faster than...
June 22, 2004 at 6:28 am
I think the minimum amout of memory is 512 MB RAM..
Also SQL Server is Monister in dealing with Memory .. because it takes almost all the memory you give to...
June 22, 2004 at 6:04 am
does your SQL server has its SP3a ?
also install Mdac 2.7 SP1 on it
I hope this solve the problem
June 22, 2004 at 5:53 am
try to install SQL Server SP3a ..
then install MDAC 2.7 SP1
I hope this solve the problem
June 22, 2004 at 5:41 am
of course install SP3a for SQL Server 2000 or SP4 for SQL Server 7 ..
SP solved many problems.
June 17, 2004 at 6:54 am
I think you have to use "Performance" tool in Windows and add counters of network ..
also check that yout TCP/IP and named piped are enabled in both Client Network utility...
June 17, 2004 at 1:36 am
you have to attach your user DB again (it is found as it is in your HDD) ..
June 15, 2004 at 5:17 am
also, in EM .. if you see the properties of your server .. under (server settings) there is the default language for user .. which will be the default language...
June 15, 2004 at 3:04 am
Note : you have to install MDAC on all the clients and SQL Server machines
and I think MDAC 2.7 SP1 refresh version is a very good one.
June 14, 2004 at 12:48 am
Viewing 15 posts - 91 through 105 (of 325 total)