Transform Data task properties not opening.
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.
Answer Question
| March 10, 2009 6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.
Answer Question
| March 10, 2009 6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
Trouble with SQL Server 2005 Upgrade Advisor when trying to detect an instance
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 5, 2008 6:34 PM
SAN, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, SQL Server Upgrade Advisor, Windows Cluster
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 5, 2008 6:34 PM
SAN, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, SQL Server Upgrade Advisor, Windows Cluster
Best encryption method for SQL Server 2000
What is a good encryption method to use in SQL Server 2000 if your database is accessed by two different languages, PHP and ASP?
Answer Question
| December 8, 2008 6:02 PM
ASP, PHP, SQL Server 2000, SQL Server encryption
What is a good encryption method to use in SQL Server 2000 if your database is accessed by two different languages, PHP and ASP?
Answer Question
| December 8, 2008 6:02 PM
ASP, PHP, SQL Server 2000, SQL Server encryption
SQL Server 2005 Upgrade Advisor in a cluster/SAN environment
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 4, 2008 3:22 PM
Cluster, DTS packages, SAN, SAN/CLuster Environment, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, Windows Cluster
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 4, 2008 3:22 PM
Cluster, DTS packages, SAN, SAN/CLuster Environment, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, Windows Cluster
Password Policy for SQL Server 2000
Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?
Answer Question
| December 4, 2008 4:40 AM
SQL Server 2000, SQL Server 2000 security, SQL Server administration, SQL Server security
Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?
Answer Question
| December 4, 2008 4:40 AM
SQL Server 2000, SQL Server 2000 security, SQL Server administration, SQL Server security
SQL Server 2000 Drive selection
I have a software package (Pinnacle Studio 10) that installed a SQL Server 2000 database. When I first loaded the SQL software on the C drive it created a database on the D drive. I now need to create a database (or move the database) to a new H drive. How can I do this? [...]
Answer Question
| December 4, 2008 8:33 PM
Drive designations, SQL Server 2000, SQL Server 2000 Drive Designation, SQL Server Drive Designation, Windows XP
I have a software package (Pinnacle Studio 10) that installed a SQL Server 2000 database. When I first loaded the SQL software on the C drive it created a database on the D drive. I now need to create a database (or move the database) to a new H drive. How can I do this? [...]
Answer Question
| December 4, 2008 8:33 PM
Drive designations, SQL Server 2000, SQL Server 2000 Drive Designation, SQL Server Drive Designation, Windows XP
Need help…My Sql server 2000 has error
My Sql server 2000 has error when created a new database or create a new table in my database. There is the error : “[Microsoft SQL-DMO(ADBC SQLState : 42000)] – Cannot use empty object or column names. Use a single space if necessary” I think my SQL server 2000 was created a no name database, [...]
Answer Question
| December 4, 2008 4:41 PM
SQL Server 2000, SQL Server database, SQL Server errors
My Sql server 2000 has error when created a new database or create a new table in my database. There is the error : “[Microsoft SQL-DMO(ADBC SQLState : 42000)] – Cannot use empty object or column names. Use a single space if necessary” I think my SQL server 2000 was created a no name database, [...]
Answer Question
| December 4, 2008 4:41 PM
SQL Server 2000, SQL Server database, SQL Server errors
Moving a database from SQL Server 2000 to SQL Server 2005 and back again
I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I’d like to move it back. When I open SQL Server Management Studio 2005 and check my database’s properties, its compatibility is “SQL Server 2000(8.0)”. Can I move my database back to SQL Server 2000, and if so, how?
Answer Question
| December 3, 2008 3:17 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, SQL Server databases, SQL Server Management Studio, SQL Server Management Studio 2005
I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I’d like to move it back. When I open SQL Server Management Studio 2005 and check my database’s properties, its compatibility is “SQL Server 2000(8.0)”. Can I move my database back to SQL Server 2000, and if so, how?
Answer Question
| December 3, 2008 3:17 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, SQL Server databases, SQL Server Management Studio, SQL Server Management Studio 2005
Backing up and upgrading a SQL Server 2000 database
We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?
Answer Question
| December 2, 2008 2:51 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server database, SQL Server upgrades
We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?
Answer Question
| December 2, 2008 2:51 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server database, SQL Server upgrades
SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi
Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says “SQL Server 2000 DTS Designer components are required to edit DTS packages” and In how to resolve this we were [...]
Answer Question
| December 2, 2008 2:24 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server Upgrade
Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says “SQL Server 2000 DTS Designer components are required to edit DTS packages” and In how to resolve this we were [...]
Answer Question
| December 2, 2008 2:24 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server Upgrade
Executing DTSX from VB.NET 2003
We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we [...]
Answer Question
| December 16, 2008 8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003
We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we [...]
Answer Question
| December 16, 2008 8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003
Configuring a password message prompt on SQL Server 2000
On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?
Answer Question
| November 21, 2008 7:09 PM
Enterprise Manager, SQL Server 2000, SQL Server permissions
On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?
Answer Question
| November 21, 2008 7:09 PM
Enterprise Manager, SQL Server 2000, SQL Server permissions
Installing SQL Server 2000 Enterprise Edition on Windows XP
When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?
Answer Question
| November 19, 2008 3:00 PM
SQL Server 2000, SQL Server installation, Windows XP Professional
When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?
Answer Question
| November 19, 2008 3:00 PM
SQL Server 2000, SQL Server installation, Windows XP Professional
Email notifications in SQL Server 2000 Enterprise Edition
In regards to email notifications in SQL Server 2000 Enterprise Edition, what level of authority does the SQL Server Agent account need in order to email me that a critical job has died?
Answer Question
| November 20, 2008 2:51 PM
Email notification, SQL Server 2000, SQL Server Agent
In regards to email notifications in SQL Server 2000 Enterprise Edition, what level of authority does the SQL Server Agent account need in order to email me that a critical job has died?
Answer Question
| November 20, 2008 2:51 PM
Email notification, SQL Server 2000, SQL Server Agent
Acquiring remote access for SQL Server 2000 from a private server to a public server
How do I acquire remote access for SQL Server 2000 from a private server to a public server?
Answer Question
| November 19, 2008 2:47 PM
Remote access, SQL Server 2000
How do I acquire remote access for SQL Server 2000 from a private server to a public server?
Answer Question
| November 19, 2008 2:47 PM
Remote access, SQL Server 2000
Install SQL Server Client Components on Windows XP
I use my SQL Server 2000 Developer Edition disk to install client components on my Windows XP. I insert the CD into the drive. I click SQL Server 2000 Components on the first screen. I click Install Database Server on the next screen. An InstallShield icon appears for a few seconds and then nothing. I [...]
Answer Question
| November 14, 2008 8:59 PM
Installation, SQL Server 2000, SQL Server 2000 Developer Edition, SQL Server Developer Edition, SQL Server installation
I use my SQL Server 2000 Developer Edition disk to install client components on my Windows XP. I insert the CD into the drive. I click SQL Server 2000 Components on the first screen. I click Install Database Server on the next screen. An InstallShield icon appears for a few seconds and then nothing. I [...]
Answer Question
| November 14, 2008 8:59 PM
Installation, SQL Server 2000, SQL Server 2000 Developer Edition, SQL Server Developer Edition, SQL Server installation
Memory could not be written
I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe – Application Error : The instruction at “0x4173d22a” referenced memory at “0x02241e90″. The memory could not be “written”. Please help !!! Thanks.
Answer Question
| November 14, 2008 5:34 PM
DTS packages, SQL Server 2000, SQL Server errors, Windows XP
I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe – Application Error : The instruction at “0x4173d22a” referenced memory at “0x02241e90″. The memory could not be “written”. Please help !!! Thanks.
Answer Question
| November 14, 2008 5:34 PM
DTS packages, SQL Server 2000, SQL Server errors, Windows XP
Updating the database using information_schema
I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000
Answer Question
| November 14, 2008 9:55 AM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server INFORMATION_SCHEMA views, SQL Server synchronization
I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000
Answer Question
| November 14, 2008 9:55 AM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server INFORMATION_SCHEMA views, SQL Server synchronization
SQL Server 2000
How do I connect my AS/400 to a SQL Server 2000
Answer Question
| November 13, 2008 2:35 PM
AS/400 to SQL Server 2000 connectivity, SQL Server 2000
How do I connect my AS/400 to a SQL Server 2000
Answer Question
| November 13, 2008 2:35 PM
AS/400 to SQL Server 2000 connectivity, SQL Server 2000
Log shipping after upgrading to SQL Server 2005
I’ve upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?
Answer Question
| November 11, 2008 7:06 PM
Log Shipping, SQL Server 2000, SQL Server 2000 Log Shipping, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades
I’ve upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?
Answer Question
| November 11, 2008 7:06 PM
Log Shipping, SQL Server 2000, SQL Server 2000 Log Shipping, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades
