I have setup a new server.
MS Small Business Server 2003 Premium
It is supposed to come with Sql Server 2000
I see some services but for the life of me I can find Enterprise Manager anywhere. Any suggestions? Did I mess up the install and need to reinstall?
Does enabling/disabling Data Execution Prevention have a performanceimpact on SQL 2000 or SQL 2005?For SQL best performance - how should I configure for:Processor Scheduling:Programs or Background servicesMemory Usage:Programs or System Cache
I am currently work on mssql 6.5. On my workstation, I have mssql 6.5 cient software.
However, I would like to install mssql 7.0 server on my nt workstation and work with it to become familiar with 7.0. Can I install mssql 7.0 server on my nt workstation? Can mssql 6.5 client coexist with mssql 7.0 on the same machine if they are in different directories?
How many result-rows does mssql return should be used asynchronous method to use mssql cursor, can get the best performance in any time in any result offset?
i want to make the cursor fast in any time whatever how many results returned
i was planning to create a database migration tool .. its a certain database of a DMS (document management system) to another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
I am a bit new to the MSSQL server. In our application, we use so many SQL queries. To imporve the performance, we used the Database enigine Tuning tool to create the indexes. The older version of the application supports MSSQL 2000 also. To re-create these new indexes, I have an issue in running these "CREATE INDEX" commands as the statements generated for index creation are done in MSSQL 2005. The statements include "INCLUDES" keyword which is supported in MSSQL 2005 but not in MSSQL 2000.
Ex:-
CREATE INDEX IND_001_PPM_PA ON PPM_PROCESS_ACTIVITY
Ben writes "I have a sql script that doesn't function very well when it's executed on a SQL 2000 server.
The scrpt looks like this:
--------------------------------------------------------------------------------------------------- USE [master] GO IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME') EXEC sp_addlogin N'SSDBUSERNAME', N'SSDBPASSWORD' GO GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME] GO GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME] GO GRANT CONNECT SQL TO [SSDBUSERNAME] GO GRANT CONTROL SERVER TO [SSDBUSERNAME] GO GRANT CREATE ANY DATABASE TO [SSDBUSERNAME] GO USE [master] GO If EXISTS (Select * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME') ALTER LOGIN [SSDBUSERNAME] WITH PASSWORD=N'SSDBPASSWORD' GO GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME] GO GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME] GO GRANT CONNECT SQL TO [SSDBUSERNAME] GO GRANT CONTROL SERVER TO [SSDBUSERNAME] GO GRANT CREATE ANY DATABASE TO [SSDBUSERNAME] GO USE [master] GO IF EXISTS (select * from dbo.sysdatabases where name = 'ISIZ') DROP DATABASE [ISIZ] GO USE [SurveyData] GO exec sp_adduser 'SSDBUSERNAME' GRANT INSERT, UPDATE, SELECT, DELETE TO SSDBUSERNAME GO USE [SurveyManagement] GO exec sp_adduser 'SSDBUSERNAME' GRANT INSERT, UPDATE, SELECT, DELETE TO SSDBUSERNAME ---------------------------------------------------------------
I need to be converted to a script that can be executed on both MSSQL 2000 and MSSQL 2005.
I was wondering if somebody there could help me with this problem?!
I've been tasked to move our production databases on MSSQL 2000 to 2005. I've supported MSSQL since version 6.5 and performed migrations to successor versions.
Current Environment is MSSQL 2000 32-bit with current Service Packs.
I've performed mock migrations on Test servers upgrading all Production instances simultaneously from MSSQL 2000 to 2005 32-bit. The Test environment is identical to Production minus server name, IP etc. Also I have a separate server with MSSQL 2005 installed where I use the DETACH / ATTACH and BACKUP / RESTORE method for migration / acceptance testing. There are approximately 30 databases totaling 70 GB. This has gone as expected and fairly successful. Vendors have been coordinated with to update code and staff for acceptance testing.
I'd prefer going directly to MSSQL 2005 64-bit instead if possible due to memory benefits etc. This is where I'd like some feedback prior to borrowing a 64-bit server for testing.
Upgrade options:
1. Is it better to migrate from MSSQL 2000 32-bit to 2005 64-bit via: a. DETACH / ATTACH b. BACKUP / RESTORE c. Is one method more advantageous relating to the end result? 2. Regarding XP clients, have issues been experienced with the default SQL Server driver or is an alternate recommended for XP clients to connect to a MSSQL 64-bit server databases? 3. If you have performed this migration and have relevant experience please pass them along.
Hi folks. I am sure this is a common situation so there shouldn't be any problems ;-) I need to run a web server and a separate database server, but am having trouble working out what username I can use in my SQL database. Here is my setup:Web server: [Windows Server 2003, IIS6, ASP.NET 1.1] The anonymous web account for the website has been changed to one created by me, so I know the password - lets call it 'IUSR_ME'. Basides that it is all default. IIS_WPG has also been given access to all website files. Database Server: [Windows Server 2000, SQL Server Standard Edition] I already have a 'classic' ASP application running on this setup, and this was achieved by putting IUSR_ME as a user in the database. Does anyone know how to do it with ASP.NET? Many thanks in advance.George
Hi, I am using VS2008 without SQL Server Express Edition.I am trying connect to MSSQL Server 2005 at localhost. How could I connect success using AspNetSqlProvider ? How to write connectionString in web.config ? Regards.
Hello, I recently got a MS SQL server problem thrown at me and I'm stuck. I have MS SQL Server 2000 hosting two databases. The problem is that when connecting via ODBC to the databases users can no longer edit or update fields. I can update and edit them through Enterprise manager, and through a PHP webinterface that also uses ODBC. If you create a new database all is well, but the other two are "locked" somehow. It was working great one day and then the next it wasn't. Can anyone direct me in the right direction. I don't even know where to start searching. Thanks.
I have to port a database from MSSQL to MySQL. I'm really a newbie with MSSQL and I need some hints on how to do this task.
I received a .bak file which my boss told me that this a backup of the database I have to port.
Then I installed MSQL 2000 developer edition on my workstation and then started playing with it.
The problem is that I don't know how to connect to the database... and with what application do some queries. In mysql I use phpMyAdmin which is really useful. Is there something similar for SQL server? Or something like sqlplus under Oracle?
Moreover how can I install the .BAK file they sent me on my MSSQL install in order to recreate the db on my workstation??
Candy writes "I have a computer tower icon on the bottom toolbar/launchbar next to the time on my computer there is a round white circle super imposed on the left side.
I have had a recent power outage that messed up the computer and I reinstalled XP and both Office 2000 and the update 2003 full install. Then all the updates and service packs which have indicated they came in correctly.
My computer has been going into programming language like we used to use in the early 90's with dos. It shuts down before I can read any thing.
When I click on the icon left click a little box comes up saying server with a drop menu and service with a drop menu and they are blank. beneath that are start stop and pause buttons, beneath that is a box to be ticked that says auto start service when OS starts. No check in the box. AND, beneath that at the very bottom, it says Unknown-//- MSSQL Server.
hey guys--i need some expert advice!we have a Dell PE 2650 with 2GHz and 2MB RAM with 2000 Server. on it wehave about 6 MSSQL DB's. a couple of the DB's are the back-end for adecent sized web app (5-10 users on average, 20 users at most). manytimes, the cpu skyrockets on our db server when using the web app.sometimes things timeout, other times not. at this time, upgrading thehardware is not an option. aside from increasing the timeout periods, iwas wondering if windows 2003 server would utilize the processor better(even just a little bit?) enough to know the difference.should i attempt the upgrade, or is 2003 no more efficient withprocessor resources?thanks a bunch!
I am not able to start the MSSQL Server service on my system ever sinceI shifted my house and got a new network provider. Earlier, I was onthe local cable hub, now my computer is on a DSL network. I don't knowif the network would have something to do with it, but I am justproviding information for the sake of completeness.When I try starting MSSQL Server from the Services applet in theAdministrative Tools in Control Panel, I get a message saying,The MSSQLServer service on Local Computer started and then stopped.Some services stop automatically if they have no work to do, forexample, the Performance Logs and Alerts service."Please help.
DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?
I have tried several approaches.
A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
C: I have also tried opening the Database, and back up file through Server Management Studio. without success.
D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.
I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.
Has anyone had a problem transfering a database to a server. This is the first time I have done this. I have a site and sqldatabase hosted by a hosting company and I am supposed to transfer my database This is what I'm doing
From the Start Menu, select "Programs" -> "Microsoft SQL Server" -> "Import and Export Data" then click "Next". In the "Server" field, type in the Name or IP of the source server (your server), choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field, click "Next". Note: You can also use Windows Authentication if the SQL server is a local server. In the "Server" field, type in the hostname of the DiscountASP SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your DiscountASP database username and password (this was sent in your database order confirmation email), choose your database from the "Database" field, click "Next". Choose "Copy objects…", click "Next". Uncheck Use Default Option. Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions". Leave next window as is, click "Next". Click "Finish".
It seems to work ok untill it gets to about 90% done then a message says "There has been an error" and gives no more info. Can anyone help me out
First I created an NT account " xyz " and gave it an admin right. then, I opened Control panel/service tab, selected Mssqlserver and clicked on startup botton. I choose log On as This account and I selected xyz account from Win NT . Once I selected the account I run "start the service."
I did the same thing with the SqlServerAgent, and MSDTC.
Here is my question.
What if I am the Admin person and I use my logname and password in these services. What is the impact in doing so. Or it is better to designate one account (xyz) for these services and not use the account else where.
Another Question is that when I start the service and open the enterprise manager, Do I need to add xzy account in the security tab of enterprise manager and assign server roles to xyz account. What do I gain in doing so and what do I not gain if NOT doing so.
I do not know the answer, If you do have insight in this please let me know
We've got an mssql database hosted on our fasthosts account, however I don't have any applications to access this. When using MySQL databases I use the MySQL control centre available on the MySQL website.
Are there any similar applications available (and if possible free!) that do a similar job for mssql.
Hi I'm an experienced programmer, but just don't have much experience with ASP or MSSQL. I inherited a website and now need to set up an automated backup system for a fairly large (40MB) MSSQL database hosted by a 3rd party provider of reasonable quality with ASP and SQL Server 2000. Let's avoid ASP.NET solutions since the website I inherited is written in "straight up" ASP (old school).
I have access to the database, login etc. I'm thinking I should combine an ASP script with the database connectivity and write daily/weekly backups to a dir on the hosting server.