Topic profile page for SQL Server 2000.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SQL Server 2000.
Topic "Sql server 2000" was discussed 4,656 times on 337 sites in last 3 months
Started 3 days, 12 hours ago (2009-12-04 21:44:00)
by KPendleton
Looks like there are orphaned replication transactions. The publisher has 32 publication/subscription combinations. We've started experiencing problems with the remote distributor a year and a half ago with an anonymous subscription publication. Now, I'm uncovering what I suspect to be orphaned replication commands from a year ago. The MSrepl_transactions has data for publisher_db_id 25, but...
Started 3 days, 17 hours ago (2009-12-04 16:35:00)
by Tom
Does anyone know what's the name of the system view, where the execute privileges for stored procedures and functions are stored in SQL Server 2000? In other words: The privileges for tables and views are stored in system view INFORMATION_SCHEMA.TABLE_PRIVILEGES, but how can I determine the execute privileges for stored procedures and functions? Many thanks in advance for your help!
Started 3 days, 17 hours ago (2009-12-04 16:24:00)
by TomAustria
Does anyone know what's the name of the system view, where the execute privileges for stored procedures and functions are stored in SQL Server 2000? In other words: The privileges for tables and views are stored in system view INFORMATION_SCHEMA.TABLE_PRIVILEGES, but how can I view the execute privileges for stored procedures and functions? Many thanks in advance for your help!
I implemented transactional replication SQL Server 2000 - pull subscription. I've got the distributor and subscriber on same server. Concurrent snapsot sized about 3GB. Snashot completed but caused blocking on publisher. Transactions were successfully delivered to the distributor but the never gets to the subscriber as distribution agent reports 'timeout expired' error after several retries...
Started 4 days, 5 hours ago (2009-12-04 04:21:00)
by manduz_griffus
I need to use a smalldatetime data type as a record identifier. Everyday should be unique, no duplicate date with different time should be present. It's easy to enforce in front-end code but I want to enforce it in the database level. How can I prevent users from entering duplicate dates with different time values in the table?
Started 4 days, 23 hours ago (2009-12-03 10:15:00)
by aaqqqa
I've seen documentation/information of installing SQL Server 2005 as a named instance on a box that has SQL Server 2000 already installed, but can't find any for the reverse -- I've looked on MSDN, searched SQL Server user forums, Googled, etc. We are consolidating servers, and have a SQL Server 2000 Standard edition with a enterprise-wide database that hasn’t been tested/approved for SQL ...
Started 5 days ago (2009-12-03 09:56:00)
by Jason Huang
Hi, In my SQL Server 2000, we don't have any Log Shipping now. However, we still have two records in the Log Shipping Monitor, and it seems to bother other backup job. How do we fix this problem? Thanks for help. Jason
Started 5 days, 7 hours ago (2009-12-03 02:31:00)
by Jason Huang
Hi, In my SQL Server 2000, we don't have any Log Shipping now. However, we still have two records in the Log Shipping Monitor, and it seems to bother other backup job. How do we fix this problem? Thanks for help. Jason .
Started 5 days, 17 hours ago (2009-12-02 16:23:00)
by Techno
I am trying to create a SPROC which will execute sp_executesql. Basically this is what I want to do: I am dynamically generating a SQL Query in the SPROC. Bad practice I know however this is what needs to be done given the way the current database/client is. I also need to do some paging and know how to do it but I need to return back a totalRecords value populated in an output ...
Started 1 week, 1 day ago (2009-11-29 13:33:00)
by duro
hello im running sql server 2000 and im trying to run a query to return each distinct category, and then a product from that category here is the query i am using: SELECT DISTINCT left(productID,2) as category, MAX(productID) as example_product FROM products where inventory_count > 0 and active_product=1 GROUP BY left(field1,2) it works perfect, but im trying to add in ...
Started 1 week, 1 day ago (2009-11-30 04:53:00)
by Jason Huang
Hi, In our SQL Server 2000's Maintenance Plan, we have set up a plan on Tape \\.\Tape0 which is a dds4 20Gb tape. We have 40 databases to backup, only 4 databases are bigger, and 30 database are quite small, the size of all databases is about 600Mb only. In the SQL Server Log, we found lots of load tape and unload tape happened. Before a tape backup secceeded, there're usually 4 load/unload ...
Started 5 days, 23 hours ago (2009-12-02 10:50:00)
by AA2e72E
Given a table like this Station Status_date A 01/01/2009 A 02/01/2009 -- more records for A B 31/01/2008 -- only record for C C 01/01/2009 -- more records for C How can I pick the 30 most recent records for each station? Thanks
Started 6 days ago (2009-12-02 09:32:00)
by RJGiskard
Good morning, One of our old SQL 2000 servers is on its last legs, and I'm in the process of creating a virtual replacement for it and another low utilized server. The services were running with domain admin rights, and I want to follow better practice in the rebuild and limit the services' permissions to just those necessary to do the job. The virtual server is running Windows 2003 R2 ...
Started 1 week, 1 day ago (2009-11-29 21:31:00)
by Jason Huang
Hi, In our SQL Server 2000's Maintenance Plan, we have set up a plan on Tape \\.\Tape0 which is a dds4 20Gb tape. We have 40 databases to backup, only 4 databases are bigger, and 30 database are quite small, the size of all databases is about 600Mb only. In the SQL Server Log, we found lots of load tape and unload tape ...
Started 6 days, 16 hours ago (2009-12-01 17:51:00)
by khanlala
we have SQL server 2000 on windows 2003 server plannning to upgrade to SQL server 2008 and windows server 2008 but the application is not compatibile with SQL server 2008 and Windows server 2008. would it be a problem if we would go for SQL server 2005 (which is compatibile with application) and windows server 2008 since my application is install on its own application server while SQL Server ...
Started 1 week ago (2009-12-01 09:40:00)
by John Guilbert
Hi, Can anyone answer the above question? When I tried it failed to connect to SQL Server with dll error. I had to uninstall 2010 and revert back to 2008 with reinstall of SP1. Thanks. John.
Started 5 days, 21 hours ago (2009-12-02 12:52:00)
by pokiri1212
Hello All, I have configured replication between two sql server 2000 server databases. In the replication monitor it is showing that the replication is working fine and all the commands are deliverd to the destintion. But the application team is complaining tht the data is not replicated properly. Please let me know how to ensure that the data is properly replicated or not.
Started 5 days, 17 hours ago (2009-12-02 17:03:00)
by JJKusch
Morning ALL ... I have a linked server from a SQL 2000 (8.00.760) server running Win 2003 R2 Enterprise SP2 to a SQL 2005 (9.00.4035) MSDTC is running on both servers. MSDTC component (under security tab) has been configured as follows: CHECKED ... "Network DTS Access", "Allow Remote Clients", Allow Remote Admin", "Allow Inbound", "Allow Outbound", "No Auth Req", Enable TIP Transactions",...
Started 6 days, 9 hours ago (2009-12-02 00:25:00)
by unrealweapon
Dear SQL Server experts. i have an SQL server 2000 which will occasionally crash during the night time when running some jobs. Is there anyway to know what might cause that crash ? Log files maybe and where can i find ? Strange enough, on the same machine, i have other instances SQL server 2000 which seems unaffected.
