The company for which I work did not have a DBA until I started a few weeks ago. Whoever installed SQL2K used the wrong CD so they have been running Personal Edition on their servers. I have installed a new SQL2K standard instance and have restored everything except the jobs and DTS packages. Can the msdb from the Personal edition be restored to the standard instance?
View 3 RepliesIs it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.
View 1 Replies View RelatedI did an in-place upgrade and I was wondering if I should get rid off tables in MSDB SQL 2005 carried over from SQL 2000?
Thanks.
Does the SQL2K Developers Edition allow you to install/test/support multi instances?
View 1 Replies View RelatedDoes the SQL2K Developers Edition allow you to install/test/support multi instances?
View 1 Replies View RelatedI am getting the following warning on a Live SQL 2000 system:
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
Reading about this error I realised that, by mistake, the version installed is a personal edition instead of the standard edition.
I am thinking to backup the databases, uninstall SQL 2000 Personal edition, install Standard edition and restore the databases back.
OR, disconnect the databases, uninstall the current version, install the standard version and re-connect the databases.
I haven't found within Microsoft any advice how to upgrade the personal version to the standard edition.
Because it is a live system, I would not like to mess the system up. Can you please advice?
Many thanks
Hi,I am having a problem in moving data from execl to sql2k.
The data looks like 16.70% , 12.5% etc and when I move it it changes to 0.16700000000000001 etc..
any idea what datatype I should use so that it don't changes it's mode...
Thanks in advance
Hi,
I am new to sql 2k.
Iam been asked to install sql2k on a new box .
What all things I should keep in mind when I go for the installation of sql2k?
Any / All suggestions appreciated.
Jai
Hi,
I have to move 2 fields from sql 7 to sql 2k .
the field is text.
feild a is text
field b is text.
I have to add field a and field b and move it to another field (say field c which is also text )in sql 2k.
How to go about it?
TIA.
Jsi
I moved my DB from SQL7.0/NT to SQL2k/WIN2k.
Everything was fine from the last few months but suddenly I start getting timeout errors.
I checked and rebuild all the indexes - there are no deadlocking at all - everything looks quite normal to me - I am all lost now as what to monitor and where to see for this timeout error messages.
Anyone has any idea as what is going on what should I check to see if that's the cause.
I also ran Profiler but there too nothing too long as to timeout.
My sql box is attached to IIS box and pager is set on IIS box.
The problem is not with IIS box cuz when I shift the applications to another SQL box everything runs fine and there is no timeout messages.
Any thoughts appreciated.
I have been sent a backup file from a supplier that I have been trying to restore. I have succesfully installed it on my SQL2K5 instance, however, we need to put it on our SQL Server in our DMZ . . . Which is running SQL2K . . . Supplier was informed of this and says that you can restore to a SQL2K DB as long as you use SQL Management Studio . . . Tried that and got an error message Saying That Restore Headeronly is terminating - Too many backup devices specified. . . only 64 are allowed. . . .Supplier suggests that its a SP4 issue . . . Installed SP4 and tried again . . . Got the Same Error again (SQL Server Error :3205)
Am I out of my gourd I am sure that restoring a SQL2K5 Backup to a SQL2K instance is not possible?
I should say that I am Running SQLExpress as my 2K5 Instance and MSDE as my 2K instance . . . Before I invest more time on this and trying it on a development server running Standard edition.
Thanks All
--
Regards
Tony The DBA
Hello,
I am trying to script out a new login in SQL 2000. I can script the login, but I am trying to assign the correct permissions, (e.g. db_datawriter, db_owner) and I am have trouble scripting the permissions. Here is a snippet of what I am looking to accomplish in my script. Remeber, this is 2000 not 2005...
-- This works
exec sp_addlogin @loginame = 'LoginName'
,@passwd = 'Password'
,@defdb = 'Database'
go
-- This doesn't. I am not even sure if this is what I need...
exec sp_addrolemember @rolename = 'AdminCVB'
,@membername = 'db_owner'
go
hi,
i'm hoping somone can shed some light on why this isn't working. basically i have a webform which that passes data back to a database (SQL Server 2000) and uses Windows authentication to perform the UPDATE, INSERT, whatever.
i've defined a role within the database, specifically for the application. for my tests, i've added a global security group from my Windows domain to the logins on the SQL instance. this group has been added to the custom role in the application database.
since i'm a member of this global security group, i was under the impression that my credentials would pass through and everything would be ok, however, it's not recognizing my login - or others in the group as well.
the application web (in IIS5.0) has been set to Windows Authentication, and i've flagged the impersonate=true attribute in the app's web.config file.
lastly, my connection string for the sqlconnection object grabs my user name (or the current user for that matter) in the format of DOMAINaccount. for the sake of argument, i was able to successfully connect using a custom SQL login that was assigned to the custom role.
the error that's returned specifically states that the "Login failed for DOMAINaccount"
any thoughts on what's up here? i guess i'm not understanding SQL Server security to well. thanks in advance.
Hi,
Is there a way to prevent new users from accessing a SQL2000 db (like to put it into DBO mode) while leaving current users finish their running jobs.
I tried Alter Database and sp_dboptions and both in SQL2000 requires to close all current users. It was working in SQL7 but not in 2000.
Thanks
AAA
Does any body know if it is possible to register SQL 2000 server from SQL v7.0 enterprise manager.
Thanks
I don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!
View 1 Replies View RelatedI don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!
View 3 Replies View RelatedI am new to sql2k
previously i used to work with sql7
how do i clear the transaction logs in sql2k
pavan
I am planning to use XP_CRYPT for encrypting and decrypting cc#'s, passwords etc., at database level. Any suggestions or experiences on this. More info about this product at
http://www.activecrypt.com/faq.htm
I tried to install SQL Server 2K on a W2K server running IIS and SSL. The SQL installation failed until I deleted the certs from my system. Now, the SQL logs say "SuperSocket Info: Bind failed on TCP port 1433". I have tried everything on the MS KB, TechNet, and MSDN sites that I could find. I have also uninstalled IIS and Certificate Services from the server. Since there are no certs left, I suspect that SQL Server is getting in it's own way on startup. Does anyone know of a way to trap/log this kind of conflict?
View 14 Replies View RelatedHello,
I have scheduled a job using Job Agent in SQL2K (Management). Every once in a while i get an error when i view job history:
Executed as user: xxx. Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.
The process ID changes for every error. Sometimes its 51, 56, or 54 as well.
I have checked several times, but there is no other process that runs at that time. I even rescheduled it for a different time, but even then it fails about once every week or two.
How can i check what is the other procedure it is deadlocking with, if it is? OR what exactly is the problem, if it is not with any other process?
Any help and/or guidance is much appreciated.
Thanks,
J
Here is a strange one. Have a sql2k box that I upgraded from 6.5 back. Conversion went fine, everything was ok with the sql install. Created and scheduled maintenance jobs while logged on to the box. A few days after the conversion, Enterprise Manager cannot register the server(error message is 'Data source name not found and connection libraries do not exist'). This inablilty to register the server only occurs when working on the server itself. You can register the server while connecting from another box with EM.
So, do some checking and find that the box itself does not recognize SQLSRV32.dll (etc) as even existing on the box BUT IT DOES EXIST in the normal places, it was a working install just a few days prior. As far as the box is concerned, the network libraries do not exist. Therefore, cannot register the server locally, cannot create a Data Source using the SQLSRV32 driver, cannot start the Sql Server Agent(so no scheduled back ups, etc).
Went so far as to re install the connectivity and client tools, which did not fix the issue.
Does anyone have any ideas?
I am trying to configure a 2 node SQL cluster. MSCS is configured and is failing over correctly, however when I start the installation of SQL Server, and specify the IP address of the virtual server and hit next, the installation hangs, and stops responding. I have configured MS DTC and verified that it shows up in the cluster administrator. I am not sure what else to do, please help.
View 2 Replies View RelatedWe are running SQL2000 on Compaq 8500, want to upgrade the RAM from 4GB to 6GB. What do I need to change in SQL in order to see the more memory?
We want to leave only 1GB for the OS and the rest for SQL2K.
Thanks
Hi
I have an sql server with very high usage. The web which is connected to the sql server has approx. 1000 unique visitors every time.
The database is optimized and the site goes really fast now.
But a problem we've had since the beginning is that SQL Server constantly uses 1.8 GB of RAM. Never less, never more.
Do you have any idea on how to decrease the usage of RAM. I am sure that this high usage is necessary.
Hello,
I had a peculiar problem yesterday with SQLserver2000 database restore from one server to the other. I copied the .BAK file ( 11.2 GB) from source server to target server. Target server already had the same name database. I use SEM to do restore the database using the disk file .BAK as source to restore. The NT drive space was 13.5 GB available after copying. Restore failed with an error that not enough disk space is available to restore and it needs 23 GB of space for expansion. What does it mean? The database went into "Loading" state and it got corrupted. I tried to drop the database and cleared the DBF and LDF files on the drive and again tried to restore from .BAK file but it failed again with the same error message that not enough space is available for expansion. Now I do not have the original database or am not able to build the new database.
Finally I did attach/detach methods where I could bring back the database in running state.
What is it complaining about not enough space? Why did it ask for almost 100% more space for some expansion in restore process?
Why it did not fail when doing attach/detach methods from other server.
Any valid explanation is appreciated.
Vinnie
Hi All,
I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How do I put the Transaction logs on the RAID1 disk as at install SQL2K only asks where you would like to put the SQL data ?
Any tips appreciated.
When I access SQL2K using ODBC (linked table manager), I am not able to display any data. The columns show #Deleted as their data values. How do I display data in ACCESS from SQL2K tables?
View 18 Replies View RelatedHi, all,
I did not see this one coming, and I am not sure if I did something wrong.
How do you push data from sql05 to sql2k?
I set up a data flow task, with one sql05 connection magager and another sql2k connection manager. Then when I tried to map them, I cann't!
The message on the box said: The connection manager uses an earlier version of sql server provider. Bulk insert operations require a connection that uses a sql server 2005 provider.
I have been trying different source, destination and transformation, but seems like missing something.
Thanks!
Hi,
I tried restoring a sql2000 database into sql2005 but the import failed. Is it possible to do a import like this or do you have to do some kind of db conversion?
hello all,my configuration is: Sql 2000 SP3, OS win2003 serverwhen i try a query with enterprise manager the error message appaers[Microsoft][ODBC SQL Driver] timeout expiredi verify all components ( query time out settings ....)but nothing changePLEASE HELP ME !!Thank you
View 1 Replies View RelatedIs there a way to set a default database for a server registration?I'm with a shared host and clicking my web hosts server entry inEnterprise Manager lists all the database on the server, which takes afew minutes of waiting. Maybe there's a way to set one defaultdatabase for the server registration so that when I click the serverentry it connects to the server and lists only the default database.Any ideas?
View 1 Replies View Relatedhey does anybody know what are these in UDF's in SQL2k?when to use UDF's and when to use Stored proceduresare they dependent?where i will get information on this topicplease let me knowthanks and regardshrishikesh*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies View Related