Transfering SQL SERVER 2000 Database To Access
Nov 5, 2003Hi,
I have managed to transfer the SQL SERVER 2000 database tables to access database by using DTS. But how can I transfer stored procedures in SQL SERVER to Access 2000
ADVERTISEMENT
Transfering Access Longtme FieldType To SQL 2000
Oct 16, 2001|
Complete message thread: ( indicates your current position in the thread)
Not specified - Rani 10/16/01 11:29:45 AM
--------------------------------------------------------------------------------
Subject:
From:
Date: Not specified
Rani (ranipw@hotmail.com)
10/16/01 11:29:45 AM
Hi
I have an Access 2000 database which I am trying to export to SQL 2000. I am using import utility from the SQL Enterprise manager. It imports all b ut 2 tables, which has a field of type DataTime with longtime format (like 5:30:28 PM). It gives the following error on this column.
Inset Error Column 13 ('connectTime',DBTYPE_DBTIMESTAMP) status 6: Data Ovewrflow. Invalid character value for cast specification.
How can I transfer this field to SQL with out loosing its format.
Thank you all.
Rani
Transfering MSSQL Database To Server
Sep 9, 2004Has 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
Transfering Data From A Web Form Into Sql Server Database
Sep 20, 2005Hi I am trying to develop a web based application. I am trying to insert data from my web form into sql server database using stored procedures. I am having a problem while i try to exceute the command. The error given by system is System.InvalidCastException: Object must implement IConvertible. at System.Data.SqlClient.SqlCommand.ExecuteNonQueryany suggestion what am i missing?With Regards,Sameer Jindal
View 2 Replies View RelatedASP.Net On Window Server 2000 - Database Access
Jun 27, 2006Hi
I have problem in configuring my web project on Window server 2000. I have created the web application using Visual Studio 2005 tools. I have configured Window server 2000 with the .Net Framework Version 2.0. I can access the page which doesn't have database access.
The connection string in the web config file is giving me the problem that connection string can't be found. Does any one have any idea?
My database connection string looks like this.
<connectionStrings>
<add name="etzAusBldConnectionString" connectionString="Data Source=CASCADE;Initial Catalog=etzAusBldBaseData1;User ID=sa1;Password=****"
providerName="System.Data.SqlClient" />
</connectionStrings>
Moe
How Can I Transfer A Database From Access To Sql Server 2000?
Oct 6, 2006Hy ,
How can i transfer a database from Access to Sql Server 2000?
Exactly : i want to transfer a .mdb into .mdf, and i want to keep the structure of .mdb, a structure which have tables, queries, macros, modules... When i start the transfer with Data Transformation Services ( DTS- Import Data ) , i can see that DTS shows me only tables and queries. At the end of transfer, in my .mdf database, on server, i have only tables, without queries, macros, modules.
My question is how can i transfer the queries and macros ( exactly how are in .mdb ) to .mdf database?
Thanks in advance for any advice..
Emanuel.
Access To Sqlserver Transfering ?
Nov 14, 2006I am having Access database in my local system . Values in the access database will be updated for every 5 min . I am also having Sqlserver database online with the same structure database of Access in my local system . What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically .How to do that ?
View 3 Replies View RelatedUpsized ACCESS Database To SQL Server 2000 With AS/400 Link
Jul 20, 2005I have upsized an Access database into SQL Server and manged to getthe data in place ok. The wizard created an Access Project which Ihave started to modify.However, I am also trying to get data from an AS/400. Specifically fora currency/exchange rate file. I only want ot copy the records sincethe last copy otherwise there are a vast number of records.I have created a linked server to the AS/400 within SQL Server, andcreated a view, within my specific database which allows me to look atall the data in the table.However, my problem is that I want a VB routine, in the AccessProject, which lets me copy out specic records from the view into atable within the SQL Server database. Any clues?????My oroginal code used a link to the AS/400 and the folowing code:-s = "INSERT into zacjdf00 "s = s + "select CJCNCD, CJD5E9, CJCUCD, CJD5FF, CJD5FG, CJD5FH,CJD5FI, CJD5FJ, CJD5FK "s = s + "from XGHLDTM_ZACJDF00 "s = s + "where "s = s + "CJD5E9 = '" & group & "'"DoCmd.RunSQL (s)group is preset in the VB code.
View 1 Replies View RelatedMaintain Audit Trail Of Access To SQL Server 2000 Database
Sep 25, 2006Is there any way to maintain audit trail of access to my SQL server 2000 database by any user ?? I need to log the timestamp of any insert/update/delete to any record in a table within the database by the user.
Alex
Transfering Of Database
Sep 23, 2007Hi all,
How do I transfer a database from a SQLEXPRESS instance on my PC to another SQLEXPRESS instance on my laptop? I tried backing it up and restoring it on the laptop but it comes up with errors. This is the error
Restore failed for Server 'DOUGYDOESQLEXPRESS'
System.Data.SqlClient.SqlError: CREATE DATABASE permission denied in database 'master' (Microsoft.SqlServer.Express.Smo).
Do I need to perform some configuration somewhere? Any leads will be most appreciated.
Thanks
Transfering Database
Jun 9, 2004Hi all,
Really easy question I think. I've been working on a website using a back end SQL database. All the tables, views etc have been designed and built. There is some data in the tables. Now that I have developed it I want to move the whole database onto the live Server which resides on another machine. How can i transfer a database from my development server to the live one?
Thanks
Wheelz
Script For Transfering Database Diagram
Jul 20, 2005I've been trying to get the scripts posted earlier to the group byClay Beatty to work properly. Using the three components he posted, Ihave managed to get a new SP generated. However, when I paste thisscrip into a new copy of the original database (different name, samestructure as a test), I get an Invalid Object Name for the temp table#PersistedVariables.Has anyone run into something like this before? Or used the scripts Imentioned successfully? Help would be appreciated. The resultingsection of code causing the error is posted below. This is running onSQL-Server 2000.Tim PascoeCREATE PROCEDURE [dbo].[Create Diagrams] AS-------------------------------------------------------------------------- Database Diagram Reconstruction Script-------------------------------------------------------------------------- Created on: 2004-07-19 11:54:43.327-- From Database: CABIN-- By User: dbo---- This SQL Script was designed to reconstruct a set ofdatabase-- diagrams, by repopulating the system table dtproperties, inthe-- current database, with values which existed at the timethis-- script was created. Typically, this script would be createdto-- backup a set of database diagrams, or to package up thosediagrams-- for deployment to another database.---- Minimally, all that needs to be done to recreate the target-- diagrams is to run this script. There are several options,-- however, which may be modified, to customize the diagrams tobe-- produced. Changing these options is as simple as modifyingthe-- initial values for a set of variables, which are definedimmediately-- following these comments. They are:---- Variable Name Description-- --------------------------------------------------------------------- @TargetDatabase This varchar variable will establishthe-- target database, within which thediagrams-- will be reconstructed. This variableis-- initially set to database name fromwhichthe-- script was built, but it may bemodified as-- required. A valid database namemust be-- specified.---- @DropExistingDiagrams This bit variable is initially setset to a-- value of zero (0), which indicatesthat any-- existing diagrams in the target-- to be preserved. By setting thisvalue to-- one (1), any existing diagrams inthe target-- database will be dropped prior to-- reconstruction. Zero and One are theonly-- valid values for the variable.---- @DiagramSuffix This varchar variable will be usedto append-- to the original diagram names, asthey-- existed at the time they werescripted. This-- variable is initially set to take onthe-- value of the current date/time,although it-- may be modified as required. Anemptystring-- value would effectively turn off thediagram-- suffix option.--------------------------------------------------------------------------SET NOCOUNT ON-- User Settable Options------------------------Declare @TargetDatabase varchar (128)Declare @DropExistingDiagrams bitDeclare @DiagramSuffix varchar (50)-- Initialize User Settable Options-----------------------------------SET @TargetDatabase = 'CABIN2'SET @DropExistingDiagrams = 0SET @DiagramSuffix = ' ' + Convert(varchar(23), GetDate(),121)--------------------------------------------------------------------------- END OF USER MODIFIABLE SECTION - MAKE NO CHANGES TO THELOGIC BELOW----------------------------------------------------------------------------- Setting Target database and clearing dtproperties, ifindicated------------------------------------------------------------------Exec('USE ' + @TargetDatabase)IF (@DropExistingDiagrams = 1)TRUNCATE TABLE dtproperties-- Creating Temp Table to persist specific variables-- between Transact SQL batches (between GO statements)-------------------------------------------------------IF EXISTS(SELECT 1FROM tempdb..sysobjectsWHERE name like '%#PersistedVariables%'AND xtype = 'U')DROP TABLE #PersistedVariablesCREATE TABLE #PersistedVariables (VariableName varchar (50)NOT NULL,VariableValue varchar (50)NOT NULL)ON [PRIMARY]ALTER TABLE #PersistedVariables ADD CONSTRAINTPK_PersistedVariables PRIMARY KEY CLUSTERED(VariableName) ON [PRIMARY]-- Persist @DiagramSuffix-------------------------INSERT INTO #PersistedVariables VALUES ('DiagramSuffix',@DiagramSuffix)GO-- Insert a new dtproperties row--------------------------------INSERT INTO dtproperties (objectid,property,value,uvalue,lvalue,version)VALUES (0,'DtgSchemaOBJECT',null,null,null,0)DELETE #PersistedVariablesWHERE VariableName = 'NextObjectid'INSERT INTO #PersistedVariables VALUES ('NextObjectid',Convert(varchar(15),@@IDENTITY))Declare @NextObjectid intSELECT @NextObjectid = Convert(int, VariableValue)FROM #PersistedVariablesWHERE VariableName = 'NextObjectid'UPDATE dtpropertiesSET Objectid = @NextObjectidWHERE id = @NextObjectidGO-- Insert a new dtproperties row--------------------------------Declare @NextObjectid intSELECT @NextObjectid = Convert(int, VariableValue)FROM #PersistedVariablesWHERE VariableName = 'NextObjectid'INSERT INTO dtproperties (objectid,property,value,uvalue,lvalue,version)VALUES (@NextObjectid,'DtgSchemaGUID','{EA3E6268-D998-11CE-9454-00AA00A3F36E}','{EA3E6268-D998-11CE-9454-00AA00A3F36E}',null,0)GO-- Insert a new dtproperties row--------------------------------Declare @DiagramSuffix varchar (50)SELECT @DiagramSuffix = Convert(varchar (50), VariableValue)FROM #PersistedVariablesWHERE VariableName = 'DiagramSuffix'Declare @NextObjectid intSELECT @NextObjectid = Convert(int, VariableValue)FROM #PersistedVariablesWHERE VariableName = 'NextObjectid'INSERT INTO dtproperties (objectid,property,value,uvalue,lvalue,version)VALUES (@NextObjectid,'DtgSchemaNAME','CABIN Detail' + @DiagramSuffix,'CABIN Detail'+ @DiagramSuffix,null,1)GO-- Insert a new dtproperties row--------------------------------Declare @NextObjectid intSELECT @NextObjectid = Convert(int, VariableValue)FROM #PersistedVariablesWHERE VariableName = 'NextObjectid'INSERT INTO dtproperties (objectid,property,value,uvalue,lvalue,version)VALUES (@NextObjectid,'DtgDSRefBYTES','2502','2502',null,12)GO-- Insert a new dtproperties row--------------------------------Declare @NextObjectid intSELECT @NextObjectid = Convert(int, VariableValue)FROM #PersistedVariablesWHERE VariableName = 'NextObjectid'INSERT INTO dtproperties (objectid,property,value,uvalue,lvalue,version)VALUES (@NextObjectid,'DtgDSRefDATA',null,null,cast('0' as varbinary(10)),12)GO---SNIP----
View 1 Replies View RelatedPerformance Issues - Access 2000 Frontend SQL Server 2000 Backend
Jul 23, 2005Hi,Simple question: A customer has an application using Access 2000frontend and SQL Server 2000 backend. Data connection is over ODBC.There are almost 250 concurrent users and is growing. Have theysqueezed everything out of Access? Should the move to a VB.Net frontendtaken place ages ago?CheersMike
View 4 Replies View RelatedMaximum Capacity Specifications Comparison Table For Access, SQL Server 7, 2000 And MSDE 2000
May 27, 2008
Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000
Number of instances per server
n/a
n/a
16
16
Number of databases per instance / server
n/a
32,767
32,767
32,767
Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647
Number of users per database
n/a
16,379
16,379
16,379
Number of roles per database
n/a
16,367
16,367
16,367
Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB
Number of columns per table
255
1024
1024
1024
Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage
Number of bytes per row
(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB
Number of columns per query
255
4,096
4,096
4,096
Number of tables per query
32
256
256
256
Size of procedure / query
64 KB
250 MB
250 MB
250 MB
Number of input params per procedure / query
199
1,024
2,100
2,100
Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB
Depth of subquery nesting
50
32
32
32
Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)
Number of columns per index
10
16
16
16
Number of characters per object name
64
128
128
128
Number of concurrent user connections
255
32,767
32,767
5
Problem Using Access 2000 As A Front-end To SQL Server 2000 Tables
Jul 23, 2005I've created a small company database where the tables reside in a SQLServer database. I'm using Access 2000 forms for a front end.I've got a System DSN set-up to SQL Server and am using links withinAccess 2000 to get to the SQL Server tables.My forms worked fine until I made a few minor changes to the databaseschema on SQL Server (e.g. added a foreign key, or added a column).After that, all the links break - I click on a table link and get anerror msg like "invalid object name."Deleting the links after a schema change and re-adding the links seemedto fix the problem. The forms I'd already created seemed to work fineafter re-creating the links.But then I got more advanced with my forms. I have it set up so thatfor certain entry fields, the combobox gets populated with values froma table (the description appears in the drop-down and the correspondingprimary key value gets populated in the table). I created a number offorms using this technique, entered data, and everything worked fine.Made a small schema change and it broke everything -- not the actualtable links, but the functionality for the drop-downs. My values nolonger appeared, and this was true for forms that accessed tables whoseschemas did not change.This is driving me nuts. Is there any way to keep my forms frombreaking each time I make a small schema change?Thanks.- Dana
View 5 Replies View RelatedHow To Access My Sql 2000 Database ?
Oct 20, 2006Hello,All I have an asp.net application,the database is sql 2000,and my application installed in a server ,Sql 2000 server on the other server .they are all in our domain Lan,everything is Ok. But, yesterday our domain server is down,and we installed another domain(changed the domain name) ,now when I run my Application, there was error message : sql database access deny. I know my application account has problem,but I don't know how to fix it.below is my connectstring : <ConnectionString>Server=ServerNameHHMXDB;Database=HHMXPO;uid=*****;pwd=*****</ConnectionString> how can I create a user in my domian users and config my account in sql 2000 database ?thanks in advanced!
View 1 Replies View RelatedConverting Data From Access 2000 To SQL Server 2000
Oct 18, 2004Hi,
I worked on a project in ASP.NET using SQL server 2000 as the back end. Its a conversion application that I rewrote in ASP.NET using C#. I need to import the old data in Access db into SQL server 2000 and I have very little knowledge about doing it. The data in not a direct one -one transformation. There are considerable changes to the Database design and data types. Any help and suggestions wud be really helpful. Also, any article links wud be great.
Thanks
Access 2000 On Windows 2000 Can't Interact With SQL Server 7.0
Mar 13, 2001We have a SQL Server 7.0 system in NT 4.0 environment. We upgraded our users to Access 2000 and started to work with this. Now we installed a new
server which is Windows 2000 based and the domain is different from
the SQL servers domain. We then installed Access 2000 on Windows 2000
to use with terminal server. But I noticed that there was a problem
with the program. I then looked at the program which was written on Access 2000 and saw that the tables and views can't be seen. The program runs but
I can't see the views and tables. Another thing is access disconects from SQL Server when I want to see the tables. So what can be the problem.
In one part there is an Access 2000 on Windows 2000 server. On the other part SQL Server 7.0 on Windows NT 4.0. And Access can't see the tables in SQL server.
Why Only Admin Can Access SQL 2000 Database?
Oct 25, 2006
We have SBS2003 and SQL2000 is running on it. Recently we built a trips database and
Installed trips application on it but the problem is that only the administrator can run Trips application. Other domain users cannot get access to the new trips program. I added the users on database and double checked.
When normal user logs on, these messages show up:
Message 1:
"MS sql Server login
Connection failed:
SQLState: '01000'
SQL Server Error: 53
Microsoft ODBC SQL Server Driver DBNETLIB ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error:17
Microsoft OBDC SQL Server Driver DBNETLIB SQL Server does not existor denied."
Message 2:
"File dbo.control could not be opened. Error (r=100).
Press OK to end this application."
Any advance is welcome.
Peter
SQL 2000 Database Access Error
Oct 29, 2007
After restoring a database to a new server running SBServer 2003 with SQL 2000, I can access the database with any of the users accounts from the desktop of the server. When I try to attach to the database from a workstation on the network i receice the error "user nae does not exist". Any help will be appreciated.
Sql Server 2000 Linked Server To Access 97/2000 Incompatability
Jul 20, 2005We are experiencing a problem with Sql Server 2000 linking to anAccess 97 file. We have two machines that link to this .mdb file, andwe recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. Thelink on this upgraded machine no longer works, giving this message:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: Cannot open a database created witha previous version of your application.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'IDBInitialize::Initialize returned 0x80004005: ].The link on the older machine still works. We decided to tryconverting a copy of the file to Access 2000 to see if the newerpatches/drivers/whatever no longer supported 97. We set up a link onboth machines to this file, and they both work. However, on theupgraded machine, the following error is receievedServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: System resource exceeded.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'ICommandText::Execute returned 0x80004005: ].when making 1-3 connections to the the linked server, while the oldermachine supports at least 7 simultaneous queries connecting to thelinked server and still hasn't produced that error.Does anyone have any idea if there is a known issue with linking toAccess 97/2000 files under MDAC 2.8, Jet 4.0, etc? Any light anyonecan shine on this subject would be greatly appreciated.
View 1 Replies View RelatedMS Access 2000 Querying SQL Server 2000
Mar 15, 2004I am converting a MS Access 2000 project to use SQL Server. This project has uncovered a number of problems, my latest seems to be very odd.
When I query using ADO against the SQL Server database, the results don't seemed to be returned immediately. It's like the access methods being used are waiting too long to write/read the data.
This could be a simple ADO configuration error, but I cannot find any settings that would make this behave so strange.
I'm using OLE/DB drivers with trusted security and attaching using client-side recordsets (I tried server-side as well, same results) to get data for the Access form. In many instances, the data from the form is not yet retrieved when I check the results using the debugger. If I execute the same section of code just seconds later, it works without fail.
I ran the SQL Server Profiler just for grins and found that records were not getting written to the database as I would have expected. Apparently ADO had generated a transaction and rolled it back. (why I don't know) I have looked in Microsoft's support database and on MSDN to no avail. Rather then rewriting my T-SQL as stored procedures for these functions, I'm hoping for some insights from anyone else who has been down this nasty road.
Here is the exact scenario:
Problem #1:
A form that accepts data and has an update button does not update the recordset being used to populate the form. I even coded a rst.Update statement into the code. The record within the recordset isn't updated until the DoCmd.GotoRecord , , acNewRec call has been made.
I suppose I could code the insert statement myself, but shouldn't Access be updating the database for me. (it does have r/w access)
Problem #2:
A subform that performs a query and allows records to be added to a table does not correctly detect data returned from the query. A check is made in the code for a field (which has a value of 0) but the code detects a null value. If I step through this code in the debugger, enough time passes that the value is present and I never see the problem. If I set a breakpoint at the error, the null condition is indicated, even though the debugger shows a value of 0 for the field.
SQL Server version is 2000, with SP3a applied.
I updated the MDAC to 2.8, JET to 8.0 and still the same problem. I cannot find anything in my ADO or Access books for a setting that would cause this behavior. My connection is using the following info:
Set Conn = New ADODB.Connection
Conn.CursorLocation = adUseClient
Set rst = New ADODB.Recordset
Connection string: Provider=SQLOLEDB;Data Source=myserver;Initial Catalog=mydb;Trusted_Connection=Yes;Integrated Security=SSPI;
Recordset Cursor type: adOpenDynamic
Recordset LockType: adLockOptimistic
I open the recordset using:
rst.Open mytable, Conn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
Problem # 1
After manipulating the data in the form, I press a "save" button on the form. This button calls a number of subroutines, eventually executing the code below:
rst.Update
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Problem # 2
I set the recordsource using: (in the form_open)
Me.RecordSource = "Select * from mytable where myfield = 'data'"
In the form_unload, the problems occur. It tests for a value stored in the form from the query. This value is null at the time of the code execution, it has a value when inspected within the debugger however.
Maybe I'm missing something here, this project was originally coded using DAO. My conversion to ADO is 95% complete. (all of these two components are converted to ADO) This problem is causing me to miss out on sleep and look like a rookie.
Has anyone seen or heard of something such as this? Is there any hope for this snarled mess of 25K lines of code?
Thanks!
Migrating From Access 2000 To SQl Server 2000
Jul 20, 2005Hi,I have developed an application using VB 6 (SP 5), MS Access 2000 andCrystal Reports 9. I migrated from from access to SQl Server 2000.This wasn't a problem as i could import all the tables to SQL Server.Also, i could make VB6 talk to SQl Server.The problem arsies when i run my application. The sql syntax foraccess seems to be different than that for SQL Server. A simpleexample being: In access boolean datatype is true/false ,whereas inSQL Server the boolean equivalent is bit (numerical 1 or 0). Thesekind of issues are causing problems and most queries don't run.Would i need to go and change all the queries in accordance with SQlServer syntax ,which would be very time consuming or is there anyfunction which will convert the access datatype into its equivalentSQl Server datatype??Any input/thoughts/suggestions would be appreciated.ThanksJatin
View 1 Replies View RelatedData Access :: Server Rejected The Connection - Access To Selected Database Has Been Denied
Jun 10, 2015I have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.
But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013. The queries still work for users still using MS 2007.
I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.
Transfering Jobs From One Server To Another
Aug 7, 2000Hi
I need to copy all the jobs from one server to another server. How i have to do. I tried to take script of MSDB database, but it is not scripting all the jobs. PLs anyone suggest me what i have to do with scheduled jobs in 65.
it is very urgent pls.
thank u
--Rk
Transfering Data From DB2 To SQL Server
Jun 27, 2000I've read about using starsql odbc and sql server 7.0 DTS utility to transfer the database or data from a DB2 to SQL Server.
I have a SQL Server 6.5 and need to transfer data from a DB2. Is the operation the same? Is there a utility in sql server 6.5 that allows this?
Transfering Users From One Sql To Another Sql Server
Sep 24, 2000hi everybody,
i ave transfered all the users from one of my sql server to another sql server but what the problem is that all the users that are on new sql server having a NULL password.....
so that means that when u transfer users from one sql servers to another the passwords will be remain as null for all users......
or any sql server patch is required for that.....
thanks in adv.
Transfering Logins To A New Sql Server
Oct 26, 2005I have an application that runs off an sql server 2000 sp3 database. I have taken a backup (.bak file) of the production database and restored it to another server for testing purposes. the users cannot login to the new server because the logins have not been transfered to the new server. I am looking to transfer the logins using the procedure outlined at the following link: http://support.microsoft.com/kb/246133/ under the header "Create and Run Stored Procedures in the Master Database". what I need to know is will this procedure affect the production server in any way? (I can't have that) and is there anything else I need to do after this to let the users login to the test server with the same name and passwords?
thanks for any help
Jobs Not Working After Transfering To New Server!
Mar 5, 2004We have transfered some jobs to new server using DTS 'export jobs' task, but they are failing when trying to execute DTS packages in them saying 'login failed for user----though everything is correct with the user!
Any help is appreicated..
Transfering Data From Informix To Sql Server
Feb 6, 2004I need to transfer seven tables from Informix DB to SQL Server every night. Any suggestions for the best way of doing it? Is DTS the best way? How about through replication?
Thanks in advance.
Transfering Data From DB2 OS/390 To SQL Server 2005
Aug 3, 2006How can I make a connection in SSIS Data Flow to connect to DB2 on the mainfrain? Have several DTS packages in SQL Server 2000 that uses the ODBC connection.
Please help!
Transfering A Flat Text File In DTS To SQL Server
Dec 26, 2006How do I tranfer a flat file (text) to SQL Server using DTS? Please point me in the right direction.
View 19 Replies View RelatedHow To Access Sql Server 2000
May 4, 2007Hi everyone,
Well, it's a bit difficult to explain this issue. I have written an e-commerce asp.net web site the web site will be hosted on a regular web host that i bought from a hosting company. and we have 2 servers in our company which one of them has internal ip address and the other one has fixed ip address. I have to install my sql 2000 db on the first server(the one with internal ip), I wanted to know that how can I link the the data base to the website via the second server(the one with fixed ip address). I was thinking about using link servers in sql server....
Could any one told me that if it is a good idea or not????