Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Transfer Codepage 840 To 1252 In SQL 7


Well , I have a SQL 7 work with code page 840 and contain about 3 MG of arabic content (extended ASCII Code) , but we need to chnage the SQL 7 to work with code page 1252 with the data ib it , cause we face a problem with the code page 840 so we want it to be 1252 , so if some one suggest anything to solve this problem , I will be happy to hear from them ....


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Code Page Translations Are Not Supported For The Text Data Type. From: 1252 To: 950.
Code page translations are not supported for the text data type. From:1252 To: 950.I would like to know what this message means. I also installed thelanguage packs in advanced settings, Everything is set to English. Mywindows XP computer is XP English. For some reason I cant get an updateto go thru using ADO. like Recordset.UpdateAlthough other routines using .update workAny ideas?

View Replies !   View Related
SSIS Failing To Load Extended Character In Code Page 1252
Background€¦
 
We€™re receiving the data as flat files, when I open up the file in notepad the characters look like the error€™d examples (see below).  Open the file up in a texteditor where you can apply code page 1252 it display the characters correctly, which is expected behaviour!
 
I use SSIS to load these files into my database, applying the correct code page€¦
 

€¦however the data gets loaded in the incorrect form.  Plus the database is collation €˜SQL_Latin1_General_CP1_CI_AS€™ which is code page 1252 so I can€™t see why I am getting these issues.
 
This is an example of the Umlaut (German chars) issues were getting, they€™re appearing in the database like this€¦.
 
tuid                  travelproductid            lastname
1741869            6                                  P€?hls
1792950            6                                  Sch€žfer
2087798            6                                  L€?schhorn
2089010            6                                  Sagemller
2314086            6                                  Jnger
 
 €¦& should be€¦
 
1741869            6                                  Pöhls
1792950            6                                  Schäfer
2087798            6                                  Löschhorn
2089010            6                                  Sagemüller
2314086            6                                  Jünger
 
 
I think it€™s a bug with SSIS, I know having a Unicode file would certainly solve this but I don't have that option.

View Replies !   View Related
How To Tell Which Codepage Is In Use
How do I find out what codepage a server has been set up with?

I've 2 sql boxes. Registering them in Enterprise Mgr. gives a message for the second one saying codepage is different. I don't want to have to reinstall both.

I thought I'd be able to find this in a FAQ or BOL but haven't found it so far.

Thanks.

Simon.

View Replies !   View Related
Codepage
When registering a new SQL Server I get the following message:

"Warning - The client and server codepages do not match.."

However when I run sp_helpsort on the client and server both have the same code page (cp850).

Does anyone have any idea as to why I'm getting this message.

Any suggestions welcome.

Thanks,

Karl

View Replies !   View Related
About Codepage?
LocaleID is 'English (United States)'
However, after I scripted query statement like 'select cast(col as varchar(20)) as col1...', the codepage changed to my local codepage, the col's datatype is nvarchar(20)
Any idea about this? Thanks

View Replies !   View Related
Codepage Conversion
I'm in the process of upgrading some databases from SQL 7.0 to SQL 2000. The SQL7.0 server was installed using codepage 850 (multilingual), Sortorder CI AS.

I now copied the datafiles to the new SQL2K server and attached them. The database properties now show codepage SQL_Latin1_CP850_CI_AS which seem right to me. Unfortunately most special characters show wrongly in our application. In EM or QA everything looks fine. I tried to change settings in the client network utility but without success. Any ideas what is wrong? :confused:

Thanks a lot
M

View Replies !   View Related
Pb Codepage Et ISQL
Bonjour,
J'execute un script en sql 7 qui lance isql qui crée un fichier texte en sortie. j'ai un souci, ce fichier de resultat a remplacer les lettres accentuées é è ...
par des virgules ,
Quelle est la solution ? Merci d'avance ...

View Replies !   View Related
SQLServer7 + CODEPAGE 437 !!!!!
HI

I'm trying to install an application that uses a SQLServer7 dB. However when I try to install the app goes through some preliminary checks.

It finds SQLSErver7 installed but realises the codepage is set to something other than 437 which it needs.

How can I change the codepage to 437? Also what codepage is this error referring to.

Please help as this is driving me nuts and I really dont want to have to reformat the hard drive and start all over again.

Best regards
Alex.

View Replies !   View Related
Codepage Problem
I searched forum but i didn't find solution to my bizare problem. I have flat txt file and want to import data to sql. OleDBDestination gives me warning: blabla column cannot be processed because more than one code page are specified. My locale are 1250 and my db is 1252.

Any solutions about codepages?

Thank you

 

View Replies !   View Related
Get Data In Other Characterset / Codepage
Hi.

I'm trying to read data in another code page (then my computer uses). I want to read Codepage 850 (MS-DOS), this because I'd like to create a MS-DOS compatible file.

Ant ideas?

View Replies !   View Related
Can't Get Right Sortorder And Codepage SQL 2000
Hi!

We are trying to install MSSQL 2000 under win 2000 with the
same codepage and sortorder that we have for a SQL 7
installation with sortorder 185 (swe/fin) and character set ISO 8859-1
But we can't se any option that match that in SQL 2000?.
There is an option for Scandinavian sortorder but only with
codepage 850. Operating system Windows 2000

Has anyone any solution for this?

View Replies !   View Related
ISQL - Script DOS Et CODEPAGE
Hello, I execute a script in sql 7 which launches isql which creates atextual file at output. I have a problem, this file of result has to replace the letters accented é è... by commas, Which is the solution?
Thank you in advance...

View Replies !   View Related
Euro Symbol With Codepage 850
I have a SQL 7 installation with codepage 850 but I cannot get the Euro symbol to appear? Does codepage 850 support it?

View Replies !   View Related
Transformation's CodePage Problem
Hello all,

I'm having a problem creating a very simple transformation.

source:
sql 2000
table: FE_Login_Attempts
field FLA_UserName defined as varchar(50)
collation: SQL_Latin1_General_CP1_CI_AS

destination:
sql 2005
table: Inc_Fact_CasAp_Transactions
field FLA_UserName defined as varchar(50)
collation: SQL_Latin1_General_CP1_CI_AS

for some reason, I'm having a problem transfering certain records, even though the collation on the dbs are the same, and I'm using the 1252 codepage for the  FLA_UserName  field.
the complete error messege i'm getting is:


Error: 0xC020901C at Insert CasAp_Transactions into Inc_Fact_CasAp_Transactions, TTF-SQL;db_CasAp;FE_Login_Attempts [1]: There was an error with output column "FLA_UserName" (1157) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

Error: 0xC020902A at Insert CasAp_Transactions into Inc_Fact_CasAp_Transactions, TTF-SQL;db_CasAp;FE_Login_Attempts [1]: The "output column "FLA_UserName" (1157)" failed because truncation occurred, and the truncation row disposition on "output column "FLA_UserName" (1157)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

Error: 0xC0047038 at Insert CasAp_Transactions into Inc_Fact_CasAp_Transactions, DTS.Pipeline: The PrimeOutput method on component "TTF-SQL;db_CasAp;FE_Login_Attempts" (1) returned error code 0xC020902A. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Insert CasAp_Transactions into Inc_Fact_CasAp_Transactions, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Insert CasAp_Transactions into Inc_Fact_CasAp_Transactions, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Insert CasAp_Transactions into Inc_Fact_CasAp_Transactions, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.


Any help will be greatly appreciated.
Liran

View Replies !   View Related
SqlBulkCopy CodePage Translation Vs BCP
I have deveoped a replacement for some an old bcp based applications in the .Net Framework that uses the SqlBulkCopy class.

I have run into some difficulties with code page translation:

The original BCP client runs with OEM Codepage 437 , thus the data  "ëÄÆòÖ" gets loaded as "d-¦=+". DB is SQL_Latin1_General_CP1_CI_AS, column is varchar.

I have been unable to perform any code page Encoding in .Net that yields the same result.

I want to emulate this behaviour in my database loader but as yet have been able to find a way....

Any Ideas???

Thanks,
Niall

View Replies !   View Related
SQL7 Setup Can Not Detect 6.5 Codepage
How can I get my SQL7 setup to reconize my 6.5 codepage upon setup?
I keep getting an error during setup that it can not detect the codepage of SQL6.5.
This in turn makes the upgrade wizard fail without any warning.

View Replies !   View Related
Codepage 932 Is Not Supported By The Java Environment.
I have a JDBC type 4 driver, connecting to a Japanese SQL Server 2000.  The connection gives this SQL exception:

SQLException: Codepage 932 is not supported by the Java environment.

SQL State: null

SQL Code: 0

This same software has been in use and working just fine for over 2 years with other servers.  Does anyone know the solution to this problem?

Thanks!

pds2

View Replies !   View Related
How To Change Codepage Of MSSQL Server _AFTER_ Installation ?
I know there is a sortid in .iss file, which could be used to change installation params, but I want to know how to change it after installation. Thanx.

View Replies !   View Related
Sorting With Unicode Characters Not Covered By A Single Codepage
Hi group,
I'd like to ask a question about collations. Say I have a SQL Server 2005 Express database with a table where a field is defined as NVARCHAR(100), containing some Unicode Greek text. The Unicode Greek text draws from 2 Unicode ranges: Greek and Greek Extended (for ancient Greek). This means I also have character codes like +1F00 (Greek small letter alpha with psili) etc, i.e. much greater than the +0300 region of modern (monotonic) Greek, as covered by codepage 1253. So, even if I specify a collate for the Greek codepage this does not work for other Greek characters, e.g.:

select * from SomeTable order by theFieldWithGreek collate greek_ci_ai

This will not produce a correctly sorted output, as all the characters belonging to the +1F00 region will be placed after the ones at +0300: this means that e.g. alpha (the first letter of Greek alphabet) with psili (+1F00) will sort AFTER omega (the last letter of Greek alphabet) just because of this diacritic.

Is there a case and accent insensitive collate I can use for such Unicode ranges, or I'll have to resort to custom functions or additional fields to use just for the purpose of sorting? What's the intended way of dealing with such Unicode texts in SQL Server?

Thanks!

View Replies !   View Related
Error At OutputColumn.SetDataTypeProperties(dataType, Length, Precision, Scale, TargetColumn.CodePage);
 

I have generated the package ! but it gives me an error at:
 

outputColumn.SetDataTypeProperties(dataType, length, precision, scale, targetColumn.CodePage);

private void ConfigureDataConversionComponent(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData90 dataconversionComponent)

{

PipeLineWrapper.CManagedComponentWrapper managedOleInstance = managedOleInstanceDataConversionComponent;

// Get the derived's default input and virtual input.

PipeLineWrapper.IDTSInput90 input = dataconversionComponent.InputCollection[0];

PipeLineWrapper.IDTSVirtualInput90 vInput = input.GetVirtualInput();

// Iterate through the virtual input column collection.

foreach (PipeLineWrapper.IDTSVirtualInputColumn90 vColumn in vInput.VirtualInputColumnCollection)

{

managedOleInstance.SetUsageType(

input.ID, vInput, vColumn.LineageID, PipeLineWrapper.DTSUsageType.UT_READONLY);

}

// putting the truncation row disposition

dataconversionComponent.OutputCollection[0].TruncationRowDisposition =

PipeLineWrapper.DTSRowDisposition.RD_NotUsed;

// putting the error row disposition

dataconversionComponent.OutputCollection[0].ErrorRowDisposition =

PipeLineWrapper.DTSRowDisposition.RD_NotUsed;

// get the output column collection reference

PipeLineWrapper.IDTSOutput90 output = dataconversionComponent.OutputCollection[0];

foreach (PipeLineWrapper.IDTSInputColumn90 inColumn in

dataconversionComponent.InputCollection[0].InputColumnCollection)

{ // create the map

// get the target column from the mapping informations

PipeLineWrapper.IDTSOutputColumn90 outputColumn =

dataconversionComponent.OutputCollection[0].OutputColumnCollection.New();

outputColumn.Name = inColumn.Name;

Column targetColumn = GetTargetColumnInfo(inColumn.Name);

// find out the length of the column

int length = targetColumn.Length;

// get the precision of the target column

int precision = targetColumn.Precision;

// get the scale of the target column

int scale = targetColumn.Scale;

// get the SSSIS complaint datatype from the given mappings

Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType dataType = targetColumn.DataType;

// setting the data properties

outputColumn.SetDataTypeProperties(dataType, length, precision, scale, targetColumn.CodePage);



// putting the external metadata column id to zero

outputColumn.ExternalMetadataColumnID = 0;

outputColumn.ErrorRowDisposition = PipeLineWrapper.DTSRowDisposition.RD_RedirectRow;

outputColumn.TruncationRowDisposition = PipeLineWrapper.DTSRowDisposition.RD_RedirectRow;

PipeLineWrapper.IDTSCustomProperty90 property = outputColumn.CustomPropertyCollection.New();

property.Name = "SourceInputColumnLineageID";

property.Value = GetSourceColumnLineageID(targetColumn.Name);

property = outputColumn.CustomPropertyCollection.New();

property.Name = "FastParse";

property.Value = false;

// Now we are preserving the Lineage id into a list.

// you know, when later we will configure the dataflowcomponent of SQL destination

// then, we will find all the inputs (the input came from flat file and the inputs

// came from the derived columns output). And we need to distinguish among them.

// we will only consider those inputs into the data destination component, where the

// inputs are came from the out put of derived column component. which is actually here.

derivedLineageIdentifiers[outputColumn.LineageID] = outputColumn.Name;

}

}

View Replies !   View Related
Transfer Manager Does Not Transfer Stored Procedures
I am using transfer manager in SQL 6.5 to copy a database and
all objects with data to another server. Transfer manager is not recreating all stored procedures. This even happens when I used it to another database on the same server. Any ideas??

View Replies !   View Related
Transfer Data To New Table Then Transfer Indexes
Is it possible/advisable when transfering very large amounts of data from server to server to:
trasnfer the data to a new table first
second alter new table adding indexes, defaults, ets based on original table

if it is what flow item would be used to transfer/alter the indexes and defaults?

I'm very new to ssis so the more detail you can give the better.

Thanks

View Replies !   View Related
Transfer Manager Transfer Dying?
Hello:

I have been trying to run transfer manager to transfer all of the data
from the production database on one server to a test database on another
server(to refresh it). In order to make sure it runs on the server, I have
been scheduling it under EM to do so and I am pointing to the log on the
destination server on the EM Transfer panel.

For some reason, I am getting the following message in the destination
server error log:

99/02/16 10:24:41.42 ods Error : 17824, Severity: 10, State: 0
99/02/16 10:24:41.42 ods Unable to write to ListenOn connection
'.pipesqlquery', loginname 'sa', hostname 'TEMP09'.
99/02/16 10:24:41.42 ods OS Error : 232, The pipe is being closed.
99/02/16 10:24:41.42 spid17 Error : 1608, Severity: 21, State: 2
99/02/16 10:24:41.42 spid17 A network error was encountered while sending
results to the front end. Check the SQL Server errorlog for more
information.

I checked the event viewer error log and see no messages for today.

Can any one advise me what I need to do for this to run successfully?

Thanks. Any information furnished will be greatly appreciated.

David Spaisman

View Replies !   View Related
SSIS Transfer Objects Report An Error: 0xC002F325 At Transfer SQL Server Objects Task
hi folks

i try to copy all objects from one dt to another db on the same SQL-Cluster.

The transfer work some minutes (generate skripts for creating objects) and will fail if the data would be copy

see errormessege below

 

SSIS package "AdminContent to MCAdminContent.dtsx" starting.

Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80040E37.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E37 Description: "Invalid object name 'dbo.AllDocs'.".

helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

Task failed: Transfer SQL Server Objects Task

SSIS package "AdminContent to MCAdminContent.dtsx" finished: Success.

 

have any one an work arround for my problem or have i a bad configuration?

thanks for help

 

roland

View Replies !   View Related
DTS Transfer
Hi,
 I have the following method which transfers data SQL to SQL on the same server but when I try to change the destination server it won't transfer the data. The method runs through as expected with no exceptions or errors but with no data transfered.
 
Private Sub TransferSQLData(ByVal SourceDetails As Admin_upload.EnvironmentDetails, ByVal DestinationDetails As Admin_upload.EnvironmentDetails)
 
'Transfer database from source to destination.
Dim oPackage As New DTS.Package2
Dim oConnection As DTS.Connection2
Dim oStep As DTS.Step2
Dim oTask As DTS.Task
Dim oCustomTask As DTS.TransferObjectsTask2
Try
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")
oCustomTask = oTask.CustomTask
oPackage.FailOnError = False
With oStep
.Name = "Copy Database design and data"
.ExecuteInMainThread = True
End With
With oTask
.Name = "GenericPkgTask"
End With
With oCustomTask
.Name = "DTSTransferObjectsTask"
.SourceServer = "MYSERVER"
.SourceUseTrustedConnection = True
.SourceDatabase = SourceDetails.MetaDB
.SourceLogin = SourceDetails.MetaUser
.SourcePassword = SourceDetails.MetaPWD
.DestinationServer = "MYSERVER"
.DestinationUseTrustedConnection = True
.DestinationDatabase = DestinationDetails.MetaDB
.DestinationLogin = DestinationDetails.MetaUser
.DestinationPassword = DestinationDetails.MetaPWD
.CopyAllObjects = True
.IncludeDependencies = False
.IncludeLogins = False
.IncludeUsers = False
.DropDestinationObjectsFirst = True
.CopySchema = True
.CopyData = DTS.DTSTransfer_CopyDataOption.DTSTransfer_ReplaceData
 
End With
oStep.TaskName = oCustomTask.Name
oPackage.Steps.Add(oStep)
oPackage.Tasks.Add(oTask)
oPackage.Execute()
Catch ex As Exception
LabelUploadMeta.Text = "Failed to Upload MetaData: " & ex.Message
Throw ex
Finally
oConnection = Nothing
oCustomTask = Nothing
oTask = Nothing
oStep = Nothing
 
If Not (oPackage Is Nothing) Then
oPackage.UnInitialize()
End If
End Try
End Sub
This works fine but when I set the following within the method:
.DestinationServer = "ANOTHERSERVER"
It won't transfer the data.
I can access the remote server and read and write data to it.
 Any ideas? 
 

View Replies !   View Related
Transfer/bcp
I've been trying to use the transfer to move 1.5 million records to another database. I keep getting "deadlock" errors. I've up the locks to 15000, single user mode and selected the select into check box. What is my next step? I had did this the other day with no problems. The reason I have to do this agian is that I tried to cahnge the index on a field from nonclustered to clustered and all my data vanished. Iv'e never had that happen before. Any thoughts would be great.
thanks

View Replies !   View Related
Transfer By IP
When I transfer between 2 server and I connect at them by name there is no problem, but if I connect to one of them by IP Address the transfer begin but in the process the next message appear:

Error 10004 (DB-library):Unable TO connect SQL Server is unavailable or not exist.Especified SQL Server not found

Known anybody why?

Any operation dont support IP Adress?

Thanks in avance

View Replies !   View Related
Db Transfer
I recently transferred a db from our production machine to a test machine. After the transfer was complete I realized that all copied logins were copied with blank passwords. Is this default behavior? Can I set the transfer to include passwords?


Dave King

View Replies !   View Related
SQL Transfer
Hi Everybody...

I have recently tried to transfer my database over from one machine to another, but failed to do so because it gets jammed on 30%. I am just wondering if there is any other ways I can take to migrate the database over.

I am currently running sql server 6.5 in concurrent with iis 4 and nt4. I am trying to seperate the iis to a new server machine and sql server to another server.

Please advise me which route to take if you have any suggestions and your solution is important to me. Thanks!

-Ken

View Replies !   View Related
DTS Transfer
Hi,

stupid question but i have forgotten how to transfer a DTS package between servers, its been so long since i last had to!!!

TIA

View Replies !   View Related
DB Transfer.
Hi,
When i transfer a database from one sql server to another, the text fields in the table gives some problem. When i try to update those fields - i get an error message saying
"The virtual page does not match with the physical page. " . This should be b'cos the text fields are stored as a pointer to a location. Noe how do i
transfer the database without causing any data loss ?

thanks,
Karthik narain

View Replies !   View Related
Transfer From 65 To 70
Hi ,
Can anyone suggest me to transfer a database from 65 to 70.
I trasfer a database using DTS, but i am only getting data. I need my users , views, stored procedures, permissions.
I need to upgrade three databases from 65 to another 70 server.
i also generated a script from 65, but which is showing errors.
Could u pls give any suggestions.
thank u.

--Raj

View Replies !   View Related
DTS Transfer
Hello,

I am using SQL Server 2000. Can anyone explain to me how to export a DTS package into a .dts file?

Thank you,
Crystal

View Replies !   View Related
Transfer From One Db To Other
Hi,

I want to transfer rows from one database to another.
Source My Source tables in database 'Staging'

CustomersEng
Name
Age
StCode
CityCode
InternalID

CustomersSpanish
Name
Age
StCode
CityCode
InternalID

CustomersEng and CustomersSpanish contains a replica..only difference being that 'Name' in the CustomerSpanish table is written in spanish language. The Stcode, citycode and Internalid together makes the row unique.




Code BlockSample script
Create table #CustomersEng (name nvarchar(20),age int, st_code int,
citycode int, internalid int)
Insert into #CustomersEng values('Aron',23,1,1,12);
Insert into #CustomersEng values('Cathy',28,1,1,13);
Insert into #CustomersEng values('Zarog',33,1,1,14);
Insert into #CustomersEng values('Michale',25,1,2,12);
Insert into #CustomersEng values('Linda',43,1,2,13);
Insert into #CustomersEng values('Burt',53,1,2,14);

Create table #CustomersSpanish (name nvarchar(20),age int, st_code int,
citycode int, internalid int)
Insert into #CustomersSpanish values('Arona',23,1,1,12);
Insert into #CustomersSpanish values('Cathylo',28,1,1,13);
Insert into #CustomersSpanish values('Zarogo',33,1,1,14);
Insert into #CustomersSpanish values('Michalo',25,1,2,12);
Insert into #CustomersSpanish values('Lindalo',43,1,2,13);
Insert into #CustomersSpanish values('Burto',53,1,2,14);

 
 
---------------------------------------------------------------------------------------------------------------
Destination tables in database 'CMO'

CustomerMaster
CustomerId (identity) (pk)
StCode
CityCode
InternalID

CustomerDetails [customerid and languagecode together are primary keys]
CustomerId (fk)
Name
Age
languagecode

Language
languagecode (pk)
languagename



 



Code Block
Create table #CustomerMaster (customerid int identity(1,1), st_code int,
citycode int, internalid int)

Create table #CustomerDetails (customerid int,name nvarchar(20),age int,
languagecode int)

Create table #CustLanguage (languagecode int, languagename varchar(10))
Insert into #CustLanguage VALUES (1,'English')
Insert into #CustLanguage VALUES (2,'Spanish')
 
 






Code BlockEXPECTED OUTPUT
CustomerMaster
1 1 1 12
2 1 1 13
3 1 1 14
4 1 2 12
5 1 2 13
6 1 2 14

CustomerDetails
1 Aron 23 1
1 Arona 23 2
2 Cathy 28 1
2 Cathylo 28 2
3 Zarog 33 1
3 Zarogo 33 2
4 Michale 25 1
4 Michalo 25 2
5 Linda 43 1
5 Lindalo 43 2
6 Burt 53 1
6 Burto 53 2
 
 



How can i write t-sql for this?
 
thanks

View Replies !   View Related
Transfer Database
I had Sql Server 2005 installed on my machine, with that I am working on Visual Studio 2005. I just need to add an existing database into the app_data folder. The database is existing in the Sql server, it contains 180 tables so I cannot manually copy that tables in the app_data folder. for that is there any another way to copy all the tables into the database into the folder app_data with the data in the table.
Thanks & Regards
Girish Nehte

View Replies !   View Related
User Transfer
Hi All;
I know that in the SQL Server, the logins are not contained in the database (thanks to Kevin Yu) but I don't know where are they stored. For example if I want to transfer to another server I'll have to backup users too; but HOW?
In order to be more clear: When I simply take a backup from my server and restore it to my computer I can not login again with the user login information which is created on the server; However even if I make some changes; after backing the DB up from my computer and restoring to the server the logins are working (with re-mapping)
Thanks...

View Replies !   View Related
Help With Data Transfer
Hi everyone,I need some help transfering my database(SQL2005) to the host's server.In SQL 2000 I had the Management tools > DTS or ImportExport tools.SQL2005 lacks this, all I've got is Express Manager > can't connect to multiple databases.Can connect to one database and has a screen to excute TSQL commands.I don't want to have to recreate the whole database on the server.....This would be crazy... 150 stored procedures and 30 tables. Not to mention all the individual settings for each column.I know there is SQL Studio Management tools for the full version of SQL 2005. Anyone got any idea's ?Any input/suggestions is greatly appreciated.Thanks,JShep

View Replies !   View Related
How To Transfer Database
I am trying to transfer my database from my computer where built it to another computer.  I have microsoft SQL server 2005 CTP on my computer and the other computer has Microsoft SQL server. 
Does anyone have any suggestions on how to do this???  I cannot find much info on SQL server 2005 CTP.   I have found some info about the copy database wizzard, but I cannot find that in CTP. 
Please any ideas or info would be wonderful
Thanks
Sarah

View Replies !   View Related
SQL Error After Db Transfer
I recently transferred my SQL DB from one server to another, I backed the DB up, copied across and restored it into the new location, the problem is that I get the following error.

System.Data.SqlClient.SqlException: Invalid object name 'Table Name'

I have created a new user for this database and changed my code accordingly.


<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="VB" Debug="true" %>

<Script Runat="Server">
Sub Page_Load

Dim conPubs As SqlConnection
Dim cmdSelectContacts As SqlCommand
Dim dtrContacts As SqlDataReader

conPubs = New SqlConnection("Server=Treebeard;UID=Intranet;Pwd=glglgl;Database=Contacts")
ConPubs.Open()
cmdSelectContacts = New SqlCommand ("Select * From Clientdata", ConPubs)

dtrContacts = cmdSelectContacts.ExecuteReader()

While dtrContacts.Read()
Response.Write( "<li>" )
Response.Write( dtrContacts( "c_forename" ))
End While

dtrContacts.Close
conPubs.Close()

End Sub

</script>


Any Ideas?

View Replies !   View Related
Transfer From 2000 To 7.0 - What Can Be Done?
I have a log file that went out of control (147GB), I feel that doing a shrink on the file/database would be time consuming so I am thinking of recreating the database from an imported version from our test server.I know that data can flow from one SQL server to another without regard to the SQL server version but can tables, stored procedures and views export from a 2000 database and put back into a 7.0 database?Thanks--Message posted via http://www.sqlmonster.com

View Replies !   View Related
Data Transfer
I have a table in a database that has just over 1 million records, eachrecord about 50-60 characters. I need to transfer this data to anotherdatabase. I implemented two options:1) Read the data record by record and insert into the destinationdatabase, using ODBC. I played with different commit intervals, up to100,000. This version takes about 12 minutes. Having indexes on thedestination table or removing them made little difference.2) Dump the data into a flat file, and use bulk copy to read the fileinto the destination table. This takes less than a minute.Are these results within the normal ranges? I am particularlyinterested in a way to improve upon the first method.

View Replies !   View Related
Data Transfer
hi,My problem is I am creating a new database. I need to all the tablesand procedures fromone databse to another database in sql server 2000, both in sameserver.Kalaivanan.

View Replies !   View Related
Help With Data Transfer
Hi,We have a unique situation here that is puzzling me. I have a programthat uploads data to our SQL Server. The program runs fine on WIndows95. I have installed it on a Windows 2000 machine and it will connectto our data but will not upload. It processes the file but the datadoes not appear in the database.I have checked the ODBC setup and everything is the same except I usedsqlsvr32.dll instead of sqlsrvr.dll for the 32 bit driver.I know this isn't a lot of information to go on, but the program waswritten by a contractor who has since been replaced and I don't reallyhave an idea of even where to begin checking.Any suggestions would be appreciated.Thank you,

View Replies !   View Related
Transfer Database
How can I transfer the schema of a database from one SQL Server app toanother? I've used MySQL in the past and all I had to do is create a..sql file with the DDL statements for the database, then import thatfile in the other db. Can I do the same kind of thing with SQL Server2000? If so, how?Also, is there a way to transfer the schema and data?Thanks in advance for the help!!!

View Replies !   View Related
Transfer From DBase To MS SQL
In my project, I need to transfer the database from dBase to MS SQL 2000. I only have the .dbf files for the dBase database. Can someone give me a help? Thanks in advance.

View Replies !   View Related
Transfer Tables
Transfer tables from one server to the other on a regular basis. I'm doin this using the DTS import wizard (saved it as a package and scheduled a job). But i noticed that if the table structure changes on the soruce tables, the DTS package will fail.

I want to make a DTS package that imports 6 tables, now how do i make it such that if the structure of the tables changes it shud still work. ie, everytime the tables are tranferred, the old tables on the target server must be dropped and re-created with the source server table definition. I hope this is doable.

Plz help if ne one has done this b4.

Thx

View Replies !   View Related
Standbyserver/transfer Log
hi ,
i have finised the experiment about standbyserver/transfer log(not replicate,not clustering),everything looks ok,but when i make a new table on primary server ,the table will never be transfered onto secondary server unless use the followings:
on primary:use msdb ,sp_change_primary_role 'northwind',@final_state=3
on secondary:use msdb,sp_change_secondary_role 'northwind'


is it correct?????
thx in advance....

View Replies !   View Related
Transfer Database
Transfering DB from one collation in SQL 2000 to a different collation in SQL 2000.

We need to transer our databases from codepage 850 to 1252.

We have succesfully transfered all objects and data EXCEPT stored procedures and triggers using the "Import/Export Data Wizard." We then scripted all the stored procedures and triggers from the cp850 database and installed them into the cp1252 DB. However for quite a few stored procedures and triggers we get the error "Cannot resolve collation conflict for equal to operation." I have tried scripting the sp's with the option 'Only script 7.0 compatible features' on and off but get the same errors each time.

Can anyone help?

Thanks

Paula.

View Replies !   View Related
Transfer Data
I would like to ask about the Data transfer . I have huge data in Access database and want to transfer in the MS SQL Server 2000. Can some body help me how i can do it.
Thanks

View Replies !   View Related
What Is The Best Way To Transfer Data?
I would like to transfer data from an SQL Server 2000(standard edition) on a server located outside of the department TO a laptop/notebook using MSDE located within the department. This will be 1 or 2 times a year of transfering the data from a server to a laptop. So what are some ways or the best ways of transferring data?

Thanks,

Don

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved