At least one company has developed such a product. Here's a link: http://www.dataintegrityinstitute.com/copula.htm
I am interested to read your thoughts on this.
DISCLAIMER: I don't work for the aforementioned company and don't benefit from them in any way.
Is it possible to install and run SQL server on Windows Server 2003, Standard, Appliance Edition? The operating system came installed a storage server.
Thanks!
I am moving a SQL 2k database from a Windows 2000 server to a Windows 2003 server (seperate appliances) and would like as little SQL downtime as possible.
I have several applications that I believe are connecting to servernow by servernow€™s name and don€™t want to have to figure out how to change them to servernew. Would it work if I built servernew and copied/moved the SQL database to servernew, then take servernow off line and change servernew€™s name to servernow?
I am open to any suggestions on other more appropriate methods.
Thanks in advance
Melonheads Sister
This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?
View 3 Replies View RelatedWe are migration few database from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)
Problem :
- The performance difference observer was not much (Just 15-18%)
- The CPU Utilization goes to 100% immediately, when the software login screen appears and it sustains in between 90% to 100%
- Multi-User Access (3 or more concurrent users), the sql performance is tremendously slow.
Steps followed for Migration:
- We have used the backup and restore method to migrate the data from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server).
- We ran the DBCC DBREINDEX for each affected tables
- We executed the sp_updatestats procedure for all the tables
- Upgraded the DB compatibility version to 90
- Installed the SQL 2005 Enterprise Server (64 bit-Itanium Server) Service pack 2.
One thing that we observed, was the memory usage, on SQL 2000 the sqlservr.exe uses around 1.5 GB where as on the SQL 2005 its just 120 MB.
A normal select query on 2000 Server took 11-12 sec, having 10 lac records, and the same query on 2005 took 1 min (3-5 sec CPU process taken by sqlservr and rest by the Sever Management Studio.
The only differance noted was that on 2000 the entire data was displayed at one go where as in 2005 the data was displayed at the 1st sec, and was filling the rest in the buffer, and to finally display entire data it took 1 min.
Also
when we run this query
select * from sys.dm_os_sys_info
one column os_priority_class shows a value = 32 ? what does this means.
In the MSSQLSERVER SERVICES, properties, there is a parameter displaying value
Advanced > Running Under 64 bit OS = No ? what does this means.
Could anyone pls suggest as to how to increase the sqlservr.exe memory area, and also how the enhance the performance.
Here is the senario. I have a SQL 7 server setup and running in our server room. I do all of the tasks from Enterprise Manager at my computer down the hall. I want to run the Sql that will generate a database from our development server to our production server. The problem that I am having is that when I run the Sql (after modifing the file paths) I get a msg that says it can't find the path specified. Why is that? If I go directly to the production server and run the sql I don't have the problem. Could this be because the drive that I want to put the file on is a hidden share? Please help.
Thanks in advance.
I want to install the Enterprise version of SQL7 onto a W2K box. Do I need to use the Advanced Server version of W2K?
Thanks
Steve Jimmo
I have recently installed MSDE on my computer. Now I need to get a copy ofEnterprise Mgr or equivalent. Does anyone know if I can obtain this fromsomewhere without having to purchase anything from M$
View 1 Replies View RelatedHi
has anyone used this tool to upload sql databases to a web host
i'm struggling
cheers!!!
Adrian
The data limit in SQL Express is 4 GB and SQL Enterprise is unlimited. I have SQL Express installed on my desktop machine. and SQL Enterprise on my web server. Now, I am thinking to develop solution in ASP.NET with SQL Express. and finally upload the solution on web server, where SQL Enterprise is installed. So, will there be any problem in such case ?In other words, the mdf file created by SQL Express and SQL Enterprise is same or different ?
View 5 Replies View RelatedHow Can I Install SQL Enterprise On Win Xp Pro?
I Cann't Install SQL Enterprise On Win Xp Pro
help me ,thx
I installed SQL Server MSDE 2000 but I can't find how to start it. Does this package include an Enterprise Manager or not? I thought that maybe it was a standard XP Pro feature. I had no problem finding it in W2000 Pro.
View 1 Replies View RelatedWhen I open databases, there is nothing there - not even Master, Model, Temp, Pubs, etc.
When I open the query analyzer, however, they all appear in the drop down.
What is up with that? and how can I remedy?
OP sys:Win98
SQL Server 7
Hi
When i was trying to install SQL Server 7.0 Enterprise Edition on NT 4.0/sp 6 box, got a message and that "cannot install SQL Server 7.00 EE on Windows NT Server EE" and i opted for desktop edition and installed SQL Server 7.0 and upgraded all the users and system databases. (I found a article in Technet - Q234060 about this problem and the solution is run winntup.exe before installing sql server)
Now the question is, i want to upgrade the SQL Server Desktop to Enterprise edition. How to do it? is it required to re-install SQL Server ? or any other methods available.
Thanks in advance
Jaya.
Has anyone encountered this error: When you are in Enterprise manager and you select a database then the tables tab and then you select a table and go to open table- select all rows, I get an error--An unexpected error happened during this operation-Query Designer encountered a query error! Please let me know if you have seen this. Also, when I access this from one networked computer I get the same error, then when I access it from another I do not!! The servers are interacting with Pivotal. The one that works does not!!
View 3 Replies View RelatedHi all,
I have SQL 7.0 desktop addition installed on my local win NT workstation. I am able to connect to my local server using Quary Analyser but when i am trying to connect using EM, i am not able to connect. I am receiveing the following error message.
__________________________________________________ ___________________________
A conncetion could not be established to "servername" - Specified SQL Server not found. ConnectionOpen(CreateFile()).
Please verify SQL server is running and check your SQL Server registration properties(by right clicking "servername" node) and try again.
__________________________________________________ ___________________________
I have tried as said in the error message and also tried connecting with "sa" but its not working. I can see that the server is running and i am able to connect through QA.
any help is highly appriciated.
We can no longer open tables in EM. The error message is;
An unexpected error happened during this operation
[Query] - Query Designer encountered a Query error:
Unspecified error
The tables are fine - can access them other ways.It looks as if the fault is in the script used by EM. Anyway to clear this ??
I have SQL 7 Enterprise and NT 4.0 Enterprise running on a server with 4 Gig of RAM. Is there anything special I have to do for SQL to access all the memory? My NT administrators tell me that it will only access up to 3 Gig if I add a /3G switch to the end of the boot.ini file. Any suggestions?
View 1 Replies View RelatedI am fairly new sql dba in a company and I am sure Enterprise Manager is installed on PC's and it shouldn't. Is there a way of finding out other then visiting each workstation. Thanks in advance..
View 1 Replies View RelatedI am considering upsizing my Access 2000 DB to a SQL 7 server. I was told that having SQL 7 Enterprise Manager is highly prefferd but not essential as I can maintain the upsized DB with Access 2000. The only way that I have been able to find JUST enterprise manager seems to be with purchasing the whole SQL 7 program for $1300! Microsoft cannot be that cruel, that you have to buy the whole program just for Enterprise Manager!
My questions are:
Can I download just MS SQL 7 Enterprise Manager anywhere for a reasonable fee or free?
and
if not, can I continue to use Access 2000 to maintain the SQL 7 upsized DB?
I'm trying to determine what version of SQL to run a 10 gb DB in a 24 x 7 environment.
I am having trouble finding comparsions between the two versions. Does anyone have any info on the differences between the two !!!!!
Thanks in advance.
I have access to a SQL 7 server via my ISP Hosting account. I know Enterprise manager comes with the server software, but how can I get a copy of JUST Enterprise Manager?
JD
Is non-SA account able to view the SQL Enterprise Manager?
Thanks in advance!
Plum
Does anybody know how to recognize from an NT box whether it's an Enterprise Edition or Standalone Edition. This is required to install SQL Enterprise Edition on NT 4.0 box.
If it's a Standalone version, do we have to reinstall NT 4.0 Enterprise Edition or any patch/fix available to upgrade a Standalone NT to Enterprise version.
TIA
Jagan
Is it possible to administer both 6.5 and 7.0 databases from the same SQL Enterprise Manager? I have read that you cannot do this because the 7.0 "plug-in" to the MMC wont work with 6.5 databases.
View 2 Replies View RelatedI am stepping in as our SQL 7 DBA for a platform were 7 was installed prior to my arrival. As a company, we have all versions of 7 licensed - how do I know if Standard or Enterprise version was installed on this server?
If Standard was installed - how nasty is it going to be to upgrade to Enterprise?
Thanks
Hi Everyboday:
We encountered a error in SQL Server 7.0 Enterprise Manager. None of the table can be accessed in EM. The error message showed:
[Query]- Query Designer encountered a Query Error: Unspecified error.
I checked NT and SQL Server Log. The problem is not logged. The DBCC checkdb also showed the database is fine. I also found the database permission in Security->Logins are goone. I reissued them as dbo. After I reissued the security, the error about Query Designer continue to show up and EM still does not work.
I called the Microsoft hotline support. They did not understand this problem. Since it is our production environment, I hope somebody and share their experiences or give me your recommendation. I will try to reboot server tonight.
Thank you very mcuh.
Joan
We had database corruption and cannot access the Enterprise Manager. DBCC returned errors 9000 to 9999 which I can't get any suggestions on how to handle from BOL. Any ideas!!!!! Thanks.
View 4 Replies View RelatedHi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?
Thanks
Mark
How can I force users of Ent Manager 6.5 to enter a name/password when connecting to a server that has been registered? I dont want to use the sa name and password so that anyone could use my workstation to access our servers.
View 2 Replies View RelatedDoes anyone know if it is possible to go from the Enterprise edition of SQL, back to Standard?
In other words, Enterprise Edition is installed, but what we really want is Standard. Is there any way around this, other than uninstalling and reinstalling SQL?
I assume not, but thought I would check...
Does anyone know how to turn off or disable the auto discovery for Enterprise Manager. Apparently our Network group is complaining that Enterprise Manager is generating noise on the network, it is not signifcant in volume but they complain it impacts there ability to detect hacking attempts on our network because it causes some false positives. I generally keep Enterprise Manager running because I will always have some manual job running from it and we have so many servers it takes awhile for them to all load when I first fire it up.
Thomas
Hello guys,
Just wondering if i can use CPU, Memory usage, I/O or wait events for SQL trace. I am having difficulty in finding theses events on SQL trace.
Also is it possible to show the SQL trace file output in graphical format.
Thanks