|
I have a Windows 2000 Server Standard Edition server (that's right, standard) on a home network with three systems doing basic file/print sharing (and a few other services). Until recently the systems were running XP Home, but I now have them updated ...
Started by Joel Coel on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Windows 200....
There is no advantage to running Windows 2000 Server Advanced unless you have a lot of cpus / cores or a lot of ram.
Are you talking about Windows 2000.
Windows 2000 Professional is the desktop edition, not server.
|
|
I am about to drop $2000 for a new/used 7 string guitar. I already have several 7's but am in the market for something new. I am coming to you guys to get the best info on the best options out there right now. I need your input. What is the best new/used...
Started by blessedadversary777 on
, 19 posts
by 7 people.
Answer Snippets (Read the full thread at sevenstring):
A EBMM JP, a very nice Carvin, Ibanez Prestiges, ESP's a look at An RGD or a Used J.Custom... .
Considered any of the JP's? ESP NT7? I am about to drop $2000 for a new/used 7 string guitar string for around $2000? $2000 gets you alot...
|
|
I have the same question to ask, but I'm using both SQL 2000 Server .
When the table1 in SQL Server 2000 gets updated/inserted/deleted, I have to update another table in SQL Server 2000. How is it possible to achieve that ?
Thanks in advance
Started by Samiul on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
See SP 4.
I would recommend downloading/install the SQL 2000 SP4.
You should be able to create a SQL Triggers.
Check out: SQL 2000 Triggers .
Linked servers are also supported in MSSQL 2000.
Of MSSQL.
|
Ask your Facebook Friends
|
How can I transform database from sql server 2005 to 2000
Started by saurabh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Some vendor tools exist.
First make sure that you aren't using the schema out using SSMS, and export the data using BCP or SSIS to SQL 2000.
Use SSIS to export the database directly to SQL Server 2000.
|
|
I've got a newish Windows 2003 DC and a very old Windows 2000 DC running together in Windows 2000 Native mode. I've got to pull the 2000 Server to repair it, so I want to add in a temporary 2000 Server to keep 2 DCs running. When I run DCPROMO on the ...
Started by TonyUser on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
You only need to use adprep on the 2000 Server.
Windows is usually good about notifying you as such.
|
|
How do I view previous queries in SQL Server 2000 database
Started by Brad on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Didn't get a chance to try this myself though..
2000 will get the transaction log information.
|
|
How to put row number for sql query in sql 2000 where rownumber() is not supporting?
Started by SmartestVEGA on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
In case you wanted to use Row_Number for paging, here are some ideas on how to perform efficient paging in Sql 2000:....
Thread/13daeb85-da43-4166-b188-595a4a5d5282
You can't use Row_Number() in Sql Server 2000 - it was introduced in 2005.
|
|
I want to insert say 50,000 records into sql server database 2000 at a time. How to accomplish this?
Started by Daud on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Select top 2000 * from sourcetable where id_sourcetable not in (select top (@n) id_sourcetable from sourcetable order by id_sourcetable) order by id_sourcetable select @n=@n+2000 end end
Could you @rows >0
begin insert mytable (field....
|
|
Hi
Knowledge Base article #281293 says:
The SQL Mail feature of SQL Server 2000 does not work if Microsoft Outlook 2000 is not installed on the server that functions as the mail client.
We don't have a copy of Outlook 2000 laying around, but we do have...
Started by magnifico on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Per Microsoft
http://support.microsoft.com/kb/897349
In Microsoft SQL Server 2000, you can.
|
|
I know that you can do this in SQL Server 2005, but I'm at a loss for 2000.
Started by Kris Felscher on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I am able to use the created date in SQL Server 2000.
2000 simply does not store this information, and I've never seen any solution for retrieving because of the drop/create statement.
|
