Rating Thread / Thread Starter	Last Post	Replies	Views
Using DTS to move data to a new table with some datatype changes I have a production application that I am building some upgrades using a second (empty) copy the database. A few of the upgrades included changing... tdmailbox@yahoo.com	05-09-2005 06:29 AM Joško Šugar	2	74
DTS of data between two tables, same field names but differnt datatypes I need to migrate data from one sql database to another. The second DB is a newer version of the "old" database with mostly the same tables and... tdmailbox@yahoo.com	05-09-2005 06:27 AM Simon Hayes	3	102
SQL Replication DAK Is there a separate news group for SQLServer Replication. TIA Laurence Breeze Laurence Breeze	05-09-2005 06:21 AM Laurence Breeze	2	78
Sql server authentication not set Hi , am new to sqlserver 2000.I want to connect to my sqlserver which is a remote machine.I want to connect to sqlserver by... Raghuraman	05-09-2005 03:27 AM Erland Sommarskog	3	62
SQL DTS package to process a remote OLAP database When I start creating a new DTS Package and I choose the Analysis Processing Task icon, I only have the option of working with the local... serge	05-09-2005 02:59 AM Simon Hayes	1	73
Help with SELECT Query I'm not a SQL expert. I want to be able to write a stored procedure that will return 'people who bought this product also bought this...'. I have a... jimh@netwasp.com	05-08-2005 05:10 PM --CELKO--	4	71
How To write An Sql Crosstable Select statment Hi, would like to know how to write a crosstable select statment in sql server2000 where having: - ItemNumber, ItemDescription, ItemColor, ItemSize... Joe Saliba	05-08-2005 10:37 AM John Bell	1	66
How To write An Sql Crosstable Select statment Hi, would like to know how to write a crosstable select statment in sql server2000 where having: - ItemNumber, ItemDescription, ItemColor, ItemSize... Joe Saliba	05-08-2005 10:34 AM Erland Sommarskog	1	113
How To set delimeters and text qualifiers in a file hello, i would like to know please if there's any mean to change delimeters (, or ;) and text qualifiers in a file in a i/o file written in vb... Joe Saliba	05-08-2005 10:23 AM Erland Sommarskog	1	82
how to add 1 to the field when i work with Aceess Db i have SQL statment that cout the visitor: update Tbl1 set fldvisit = fldvisit +1 where fld2='abc' when i move to... yuval	05-08-2005 06:39 AM David Portas	2	79
Is this correct use of INSTEAD OF Triggers? I am loading data from table A into table B. Certain columns in B have check constraints. I'd like for any rows from A, which violate constraints, to... Dan	05-08-2005 05:54 AM John Bell	4	86
persisting data for a pluggable tree Hi all, I am rather new to database design and modelling concepts in general and was hoping for some advice on a problem I am trying to solve. ... bob_yohan@yahoo.ca	05-08-2005 02:45 AM bob_yohan@yahoo.ca	4	53
HexToInt, vbintoHexStr - fun with CAST Fun with CAST! (Optimized SQLServerCentral script posts) I found some interesting "tricks" to convert binary to hexadecimal and back, which allow... Aaron W. West	05-07-2005 07:42 PM Aaron W. West	0	68
User interaction with SQL I am a Windows admin who knows how to administer SQL server, but I don't have any experience in creating a data interface so that regular users,... CJ	05-07-2005 12:35 PM Derrick Leggett	2	62
Book and class Can anyone recommend a good SQL Server book or class for Beginner-Intermediate, please? Thanks news.purdue.edu	05-07-2005 03:13 AM John Bell	2	75
Tunneling enterprise manager over https ASP.NET? My host does not provide a good web based management tool for the sql server database I am using. They queue imports and exports so it takes several... tvmaly@gmail.com	05-07-2005 02:52 AM John Bell	1	70
odbc errors on terminal server We connect via terminal services to an excel spreadsheet that has an ODBC link to an access database using a pivot table, when we try to refresh the... paul_tomlin@hotmail.com	05-06-2005 11:08 PM John Weinshel	3	58
Primary key Prompt me, what for need "primary key" in the database table? Alexandr	05-06-2005 10:58 PM John Weinshel	4	93
Problem using CAST with Zeroed out Field Values Hello -- I have a field with date values like: 20050714. When using SQL Server to convert it to a Date in a View, I use the following: CAST(MyDate... robboll	05-06-2005 09:21 PM robboll	5	65
Conecting over the Internet for getting data from clients. I want to connect over the internet to get data from clients.What would be the easiest method and the most stable methos to do it 1.Use a Point to... AG	05-06-2005 07:12 PM David Portas	1	69
wil s2k developer edition really work on XP Pro box? Microsoft site says yes If yes, then if I publish my site on a win2k server, will it still work? These questions assume that a yes answer does not... adso	05-06-2005 06:12 PM Erland Sommarskog	2	70
Query Analyzer Template files, object browser bug I just found an odd bug and was wondering if anyone else has seen this. Any templpate file in the directory 'C:\Program Files\Microsoft... Neal B. Scott	05-06-2005 06:10 PM Erland Sommarskog	2	63
Wrong syntax in where smth in case ? Hello all, I belive, my problem is probably very easy to solve, but still, I cannot find solution: declare @i int declare @z int create table... Matik	05-06-2005 06:06 PM Erland Sommarskog	3	76
Number Data Types... Hello all, I'm kind of struggling with numeric data types... I have read alot of material, and think I have a 'decent' grasp on the various number... WjWm	05-06-2005 05:52 PM David Portas	2	64
Connecting for entire session, or just when performing an operation? Here's a simple question for you: Is it better to maintain a single open connection to the database for the entire duration of the users session, or... Robin Tucker	05-06-2005 05:38 PM Erland Sommarskog	3	65
update from ...? Hey, I need to update a row in one table with a row (most but not all columns) from another table. This sounds like there should be a really easy... rob	05-06-2005 05:33 PM Erland Sommarskog	5	139
Problem returning a datarow Hi, I have a client/server app. that uses a windows service for the server and asp.net web pages for the client side. My server class has 3 methods... Phil	05-06-2005 05:29 PM Erland Sommarskog	3	64
SQL Profiler Hi I am just started at a new position. This organization has a number of database servers with mission critical databases. However, I have... Akinja	05-06-2005 04:51 PM Akinja	2	93
openrowset - problem in reconnecting to oracle Hi Guys , We are trying to use openrowset function to connect from sqlserver 2000 to oracle 10g database . If we provide a correct oracle database... Alias	05-06-2005 02:59 PM Alias	0	66
Select JOIN problem The query: SELECT BTbl.PKey, BTbl.Result FROM BTbl INNER JOIN ATbl ON BTbl.PKey = ATbl.PKey WHERE (ATbl.Status = 'DROPPED') AND... shumaker@cs.fsu.edu	05-06-2005 01:44 PM Simon Hayes	1	72
Mails are stuck in the Queue Folder Hello All, I wrote one code for sending mail by using Asp.Net+C#, My code is as follows. private void btnSend_Click(object sender, System.EventArgs... Kalpesh	05-06-2005 01:20 PM Simon Hayes	1	100
XML to View Hi, How can I make a view that gives it's data from az XML file(it has URL)? Thanks alot Elham Ghoddousi	05-06-2005 01:19 PM Simon Hayes	1	93
Help ! Database Still says loading after restore SQL 2000 SP3 My database is still showing Loading .... after doing a restore and the restore showing it to be successfull. I have restarted the... csomberg@dwr.com	05-06-2005 01:08 PM Simon Hayes	1	63
Sending external email from within a Scheduled Job I'm not a newbie, but I've not been able to find out how to do this particular task, and BOL isn't being too cooperative. My application sits on a... teddysnips@hotmail.com	05-06-2005 12:42 PM Simon Hayes	1	53
Help ! Database Still says loading after restore SQL 2000 SP3 My database is still showing Loading .... after doing a restore and the restore showing it to be successfull. I have restarted the... csomberg@dwr.com	05-06-2005 11:31 AM csomberg@dwr.com	0	51
Linking Two SQL Servers Two SQL Servers 1) "Test" Payroll DB Transaction Table pr_SubmitTransaction in Payroll DB ******************************************** 2)... m.ramana@gmail.com	05-06-2005 10:01 AM m.ramana@gmail.com	7	61
Stored Proc not updating multiple rows ( 1 2 ) I'm using a stored proceedure which should update a number of rows in a table depending on a key value supplied (in this case 'JobID'). But what's... EmbersFire	05-06-2005 08:11 AM EmbersFire	13	83
Complicated SELECT Problem I'm having some trouble coming up with the correct select statement. Lets say I have the following two tables: ---------------- ... Jason	05-06-2005 06:28 AM Erland Sommarskog	3	51
cursor insert with like '%' Hi I have a weird problem I want to cursor thru the values in a temporary table and use the values to do a select statement to insert into another... yurps	05-06-2005 04:57 AM yurps	2	57
Field not being updated within Stored Procedure I have this stored procedure that loops through a table and updates a couple of fields. For some reason one of the fields is not being updated. If... AS400 Guru	05-05-2005 06:49 PM Erland Sommarskog	1	67
Help Please - Backup FileGroup and Restore SQL 2000 I have server1 with two filegroups. I want to backup FileGroup Primary on Server1 and Primary has a physical file called MyData.mdf. I... csomberg@dwr.com	05-05-2005 06:09 PM Erland Sommarskog	1	62
Crosstab queries Dear friends, I wonder if exist a way to make crosstab queries in SQL Server like those in Access without "external" programming. Does the SQL... Sotiris Rentoulis	05-05-2005 05:37 PM Erland Sommarskog	1	72
Storing binary files in MS SQL 2000 Hi folks, Is it possible to store Binary Files in MS SQL 2000 ??? Say I have a 100K PDF or a 150K word document. Is it possible to store this in... Ringo Langly	05-05-2005 05:11 PM Erland Sommarskog	3	53
Separate an And/Or parameter ( 1 2 ) I want a user to be able to search for names in a table of clients using a single parameter, but be eable to use "and" or "or" IN the parameter. Like... laurenq uantrell	05-05-2005 05:08 PM Erland Sommarskog	14	112
What is purpose of N in SQL examples? What is the purpose of the "N" preceding the parameter values in the SQL examples? Here is an example copied from Books Online, SP_ATTACH_DB: EXEC... Eric Bragas	05-05-2005 04:48 PM MGFoster	1	51
SQL problem Hello everyone I have a question, something that's been bugging me for some time now. Let's look at a query SELECT A1, (SELECT SUM(EventValue)... Wariat	05-05-2005 03:17 PM Wariat	3	63
DTS vs Datastage or Informatica I am trying to find articles that compare these ETL tools. If anybody knows of any or has any information I would greatly appreciate it. David duvy613@gmail.com	05-05-2005 01:39 PM duvy613@gmail.com	0	98
SQL 2000 - 450+ Databases We have a three tier application running on two tiers. 1&2 running on one server and a seperate server for the databases. On the database server we... interflex@hotmail.com	05-05-2005 12:05 PM pb648174	4	64
BULK INSERT row terminator Hello all, I have a multiple text files with an odd row terminator. If you were to examine it in VB it would be like a "CrCrLf" instead of just... joshsackett	05-05-2005 10:44 AM joshsackett	1	57
How can I INSERT w/Constraints in other tables? Three tables (all new, no data) will receive data from dBase and be transposed into them...All three have auto generated IDENTITY columns and pk and... trint	05-05-2005 10:42 AM David Portas	3	61

Page 145 of 282

145

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off