Hi all. A while back I had to come up with a way to clean up all indexes and user-created statistics from some tables in a SQL Server 2005 database. After a few attempts it worked, but now I gotta have it working in SQL Server 2000 databases as well. For SQL Server 2005, I used
SELECT Name FROM sys.stats
WHERE object_id = object_id(@tableName)…
I butter-fingered a query in SQL Server 2000 and added a period in the middle of the table name:
SELECT t.est.* FROM test
Instead of:
SELECT test.* FROM test
And the query still executed perfectly. Even SELECT t.e.st.* FROM test executes without issue.
I've tried the same query in SQL Server 2008 where the query fails (error: the column…
I'm trying to install MSSQL 2000 on a virtual Windows 2003 instance. However, every time I run the install program, it fails to start the service. This is the error log:
21:46:50 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 131408 -U…
I'm configuring Transactional Replication using the Push model. The scenario is:
The SQL Servers:
SQL01 (publisher) and SQL02 (subscriber) - both running SQL 2000 SP4.
Both servers are standalone (i.e. not domain members)
Both servers have their FQDN and NETBIOS names in their HOSTS files
I've managed to configure SQL01 to publish…
For a company that I have been helping troubleshoot their database.
In SQL Server 2000, database is about 120 gig.
Something caused the transaction log to grow MUCH larger than normal to over 100 gig, some hung transaction that didn't commit or roll back for a few days. That has been resolved and it now stays around 1% full or less, due…
I have a HP ProLiant DL380 G3 running Windows Server 2000 that has been crashing everyday between 6-730am. This started when I changed out a failing hard drive 6 days ago. I have looked at the scheduled tasks which does not have anything pertaining to this issue. Below are the only things I see in the system log and some of the dump…
I am using HP 2000 notebook which initially came with Windows 7 64bit. It has 4gb ram, AMD APU E1-1200 (1.4ghz) with Radeon 7310. With Windows it worked ok, so I decided to switch to Ubuntu. I installed 13.04 64bit at first, but responsiveness wasn't that good (opening windows, menus, Firefox, dash search) even if it was way better…
With still a month left until Windows 8 is made commercially available, I was surprised to hear yesterday that there are already 16 million devices running Windows 8 (via @TommyLee). I was also surprised to see that in Canada, there are already over 2000 apps available in the Windows Store. This might not sound like…
I just found a list of about 2000 car manufacturers which I want to put into a drop-down list... but 2000 is probably a bit too many, so I want to filter it down to maybe the top 100 most popular cars. I figure I can just use Google search popularity to give me a rough estimate of how popular the car is... but I can't find a…
I am unable to get anything to display on my second monitor, or even get the system to recognize that there is a second screen.
I am running Ubuntu 12.04 on a Gigabyte GA-H61M-S2PV, revision 2.0 box. The integrated chipset is an Intel 2000/3000, and there are both a D-Dub and a DVI-D display ports on the MB. This is the…
I got have two Lifecam VX-2000's and they don't work in cheese anymore.
I don't know if it's a problem with a missing package, or a package I installed.
Here is the output.
(cheese:11122): Clutter-WARNING **: No listener with the specified listener id 29
(cheese:11122): Clutter-WARNING **: No listener with the specified…
Hi I have been trying Ubuntu to detect and connect using the buit in mobile broadband capability in my HP 110 netbook but until now nothing seems to work
Output of lspci command:
00:1e.0 PCI bridge: Intel Corporation 82801 Mobile PCI Bridge (rev e2)
00:1f.0 ISA bridge: Intel Corporation 82801GBM (ICH7-M) LPC Interface…
First, is this possible?
Second, how can I install Grub2? Would it be possible to use an Ubuntu Live CD?
Third, what Grub2 settings would be needed to achieve this?
One of my clients is still running Win2K server with a host of Win2K workstations. And no net admin, due to the downturn of the economy over the years. I'm sort of helping out. Out of my depth, but I am a loyal foot soldier.
A problem I encounter rather too often is a user double-clicks on a file in Explorer and then…
One of my clients is still running Win2K server with a host of Win2K workstations. And no net admin, due to the downturn of the economy over the years. I'm sort of helping out. Out of my depth, but I am a loyal foot soldier.
A problem I encounter rather too often is a user double-clicks on a file in Explorer and then…
While I know a bit about networking, I am more of a programmer, and I have never set up a DHCP server. I have always allowed a router to assign IP addresses. However, my boss has asked me to switch out our old Win2k Domain Controller and DHCP server to a new server. The catch is that he wants to just use our router to…
I have a production database i.e. where there are constant updates and I've configured this to be published to another server using Transactional Replication.
When I configure transactional replication I've been doing the following:
disable access to the source database
backup source DB then restore to subscription…
I have written an app that we want to distribute to a large number of customers to be used as the shell program when they log onto their server with a particular admin account.
I have figured out how to change the starting program by going to Administrative Tools->Computer Management->System Tools->Local…
Believe it or not, our corporate network still uses ISA Server 2000 (in a Windows Server 2003 machine) to enable / control Internet access to / from it.
I was asked recently to configure that ISA Server to create a site-to-site VPN for a new branch in a office about 25 km. away from it. The idea is basically to…
Hi there
I'm looking for the benefits of upgrading from SQL Server 2000 to 2008.
I was wondering:
What database features can we leverage with 2008 that we can't now?
What new TSQL features can we look forward to using?
What performance benefits can we expect to see?
What else will make management go for…
What issues have people encountered with older OS's (2000, XP) and olders versions of Microsoft Office (2000, XP, 2003) with the 'Microsoft Office Compatibility Pack'?
I have a couple of Windows 2000 client PC's encountering different errors when attempting to open .docx or .xlsx documents, some with Office…
What issues have people encountered with older OS's (2000, XP) and olders versions of Microsoft Office (2000, XP, 2003) with the 'Microsoft Office Compitibility Pack'?
I have a couple of Windows 2000 client PC's encountering different errors when attempting to open .docx or .xlsx documents, some with Office…
Hi,
I need to create a disk image from a Windows 2000, NTFS formatted, hard drive. This image has to be used to create backup hard drives to replace the original disk in case an emergency situation arises. This is a medical equipment, so I cannot physically disconnect the disk because I would violate the…