|
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 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.
|
|
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.
|
Ask your Facebook Friends
|
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.
|
|
I'm trying to translate the following from AT&T assembly to Intel assembly:
pushl 2000
Now this compiles down to:
ff 35 d0 07 00 00 pushl 0x7d0
But no matter what I try, I cannot get the same in Intel synax, I've tried:
intel asm disassembly after compiling...
Started by Sverre Rabbelier on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
However - if that's really what you want then the instruction is:
push dword ptr ds:[2000....
Is:
003AFCFC FF 35 D0 07 00 00 push dword ptr ds:[7D0h]
Which is equal to pushing:
*((DWORD*)2000)
NOT pushing the value 2000 onto the stack.
|
