Hello all, Can anyone point me to a good reference on SQL 2000 to SQL 2000 replication over the Internet? Each server is hosted at distant...

Jonathan Roberts

11-28-2006 06:12 PM
Jonathan Roberts

I am trying to update 1 table with the top records from another table for each record in the first table UPDATE HPFSLOWMOVING SET TOP 1 LASTRCTDATE...

Darren Woodbrey

11-28-2006 04:39 PM
Erland Sommarskog

Dear comp.databases.ms-sqlserver: (Announce): Who: Jonathan Robie is the XQuery Technology Lead at DataDirect Technologies, which specializes in...

Stylus Studio

11-28-2006 03:17 PM
Stylus Studio

I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the...

Ted

11-28-2006 02:52 PM
Beowulf

Hello there, I have about 30 sql servers runnign multiple databases amd i need to audit them so what i want to do is to log onto each server and...

Guvnor

11-28-2006 08:36 AM
mladjo

Dear All, I'm attempting to create a query that will transpose repeated fields into a single table structure. Can anyone think of how this can be...

Caspian

11-27-2006 04:44 PM
Erland Sommarskog

USE AdventureWorks GO -- Retrieve order manifest SELECT SalesOrder.SalesOrderID,

CK

11-27-2006 04:04 PM
CK

UPDATE Sales.DeliverySchedule SET DeliveryList.modify('declare namespace df=http://schemas.adventure-works.com/DeliverySchedule; replace value of...

CK

11-27-2006 03:43 PM
CK

Learn MS SQL with interactive tutorials at www.tutorialsdirect.com

amazingelearning

11-27-2006 02:21 PM
amazingelearning

Learn MS SQL with interactive tutorials at www.tutorialsdirect.com

amazingelearning

11-27-2006 02:21 PM
amazingelearning

This query SELECT DeliveryList.query('declare default element...

CK

11-27-2006 02:03 PM
CK

Hello, I have following Situation: I have a Dimension "SourceDirectory", whis has Elements "SourceDirectory1", "SourceDirectory2", ... until...

chris

11-27-2006 01:25 PM
mladjo

I have the following XML in an XML column in a SQL 2005 Database. <DeliveryList...

CK

11-27-2006 01:23 PM
CK

I need to update two fields in a few hundred rows in a table. I'll be provided with a spreadsheet giving me the key field and the two new values for...

mark@campbellsci.co.uk

11-27-2006 08:48 AM
mark@campbellsci.co.uk

Hi I am attempting to take a manual backup of an SQL 2005 database, via Right Click on MyDatabase --> Tasks --> Backup However, when I try to...

smokejo@googlemail.com

11-27-2006 05:34 AM
Greg D. Moore \(Strider\)

Hello people, I might sound a little bit crazy, but is there any possibility that you can incorporate 4^15 (1,073,741,824) tables into a SQL...

ramraj@gmail.com

11-26-2006 11:40 PM
Serge Rielau

Hi, I have three tables with there fields given in brackets: User: (PK), Divisions: (PK), DivisionsOfUsers: , the "DivisionsOfUsers" tables has...

Darsin

11-26-2006 02:09 PM
Erland Sommarskog

Ik wil uit een tabel het gehele getal halen, de waarde staat als 05612123 maar wanneer ik dit opvraag in bv. de Query Analyzer wordt de waarde...

Eus

11-25-2006 05:01 PM
Hugo Kornelis

Using SQL Server 2005 Express. I need to periodically duplicate an entire database and rename it. Most tables are empty but some are to be...

George Shubin

11-25-2006 04:55 PM
Hugo Kornelis

Hi. I have a problem with trigger FOR in merge-replication. My trigger is not "NOT FOR REPLICATION" and it's modified table with...

Piotr Wojtysiak

11-25-2006 09:17 AM
Piotr Wojtysiak

Full 2000 .NET and SQL Server Interview questions with answers PDF http://www.questpond.com/SampleInterviewQuestionBook.zip

Jobs

11-25-2006 12:44 AM
Jobs

MS SQL interactive tutorials at www.tutorialsdirect.com

amazingelearning

11-24-2006 06:44 PM
amazingelearning

select convert(float,'1.2334e+006') 1233400.0 select convert(decimal(20,2),'1.2334e+006') Server: Msg 8114, Level 16, State 5, Line 1 Error...

othellomy@yahoo.com

11-24-2006 04:56 PM
Erland Sommarskog

/* Subject: How to build a procedure that returns different numbers of columns as a result based on a parameter. You can copy/paste this whole post...

serge

11-24-2006 04:47 PM
Erland Sommarskog

Hi All, My SQL server transaction log is getting bigger every day and my HDD if running out of space. So i follow the MS KB about how to Shrinking...

sifrah

11-24-2006 04:43 PM
Erland Sommarskog

I have a stored procedure that (after selecting, incrementing and updating) returns the next sequential filename. I haven't been able to plug it in...

Joe Hurzeler

11-24-2006 04:18 PM
Dan Guzman

I have never used replication before and I have been asked to consider it in a project I am currently working on. I have created an application for...

bfausti@gmail.com

11-24-2006 04:14 PM
Benzine

i have another problem.and it's now on converting a char(4) to datetime here is the situation J_TIM < F_TIM J_TIM is datetime while F_TIM is char of...

paul_zaoldyeck

11-23-2006 07:58 PM
paul_zaoldyeck

I'm trying to write a stored proc... Basically, I have a tblItems table which contains a list of every item available. One of the columns in this...

Nobody

11-23-2006 05:17 PM
Hugo Kornelis

Chris Cheney wrote: Ahah! That helped enormously - thanks, much appreciated. -- SlowerThanYou

Slower Than You

11-23-2006 10:10 AM
--CELKO--

Hi Folks! I have a strange thing happening; I have a field that Counts the number of records and another field that shows the number of...

Rico

11-23-2006 09:47 AM
Rico

can anyone teach me how to append to datetime data into one. the first is a date and the 2nd one is a time. the time is converted from...

paul_zaoldyeck

11-23-2006 09:13 AM
Dan Guzman

hi, how far dynamic query built inside stored procedures is efficient than normal queries inside stored procedures. does dynamic query have advantage...

kalaivanan

11-23-2006 07:52 AM
Madhivanan

hi, i need some help with this. basically, what I need is to select all of the rows from one table in a cell ie col1 col2 nam1 a nam1 ...

Akimeu

11-23-2006 07:42 AM
Madhivanan

Hi. Somebody can tell how to deal with this error. When I try to connect from an asp page to update a record wich has a ntext field it give me this...

Daviso

11-23-2006 07:27 AM
Erland Sommarskog

I have a table that I am trying to do a query on. Table is named GPFCount2. CREATE TABLE ( NULL , NULL , NULL , NULL , NULL ,

Jennifer

11-23-2006 03:22 AM
Ed Murphy

Forgive me if this question is a bit too generic, if it is, feel free to just not respond. I have a database which has been running in PostgreSQL...

Engada

11-23-2006 03:11 AM
Ed Murphy

Sqlserver is case insensitive in this way ? for example: select....where col1 like '%BURG%' will return 'Burger King' ???!!!

klabu

11-22-2006 04:18 PM
Serge Rielau

Can anyone offer some advice on how to reduce the size of a database log. The database is mirrored on another server using the logs. Thanks

d.grabov@gmail.com

11-22-2006 04:12 PM
Erland Sommarskog

Hi All, As per BOL, XML data type can store up 2 GB of data. My question is when a row is inserted in a table, for its xml column, 2GB of space...

SQLMan_25

11-22-2006 03:18 PM
SQLMan_25

select convert(float,'1.2334e+006') 1233400.0 select convert(decimal(20,2),'1.2334e+006') Server: Msg 8114, Level 16, State 5, Line 1 Error...

othellomy@yahoo.com

11-22-2006 08:36 AM
Helmut Woess

Hey there :) Sorry if I'm asking a dumb question here, but I'm still quite new to MS SQL, so this problem might appear larger to me than it really...

Daniel Smedegaard Buus

11-22-2006 05:30 AM
Daniel Smedegaard Buus

select convert(float,'1.2334e+006') 1233400.0 select convert(decimal(20,2),'1.2334e+006') Server: Msg 8114, Level 16, State 5, Line 1 Error...

othellomy@yahoo.com

11-22-2006 12:08 AM
othellomy@yahoo.com

Hello, I have an application that uses SQL Server express. I'd like to be able to package the SQL Server Express set up file and deploy it with my...

Rico

11-21-2006 09:23 PM
Rico

I have a wired situation..! I set up transactional replication on one of my development server (SQL 2000 Dev Edition with sp4). It is running fine...

Query Builder

11-21-2006 06:12 PM
Query Builder

I have a database which contains more than 20000 stored procedures which were created with ansi nulls off. This i found out using the query SELECT...

balaji

11-21-2006 05:43 PM
David Portas

I apologize if this is a simple question, but I am very new to SQL Server. I feel like I am missing something easy here. I an running VB ..NET from...

dakvanslam

11-21-2006 03:52 PM
dakvanslam

I have a data collection system that uses MSSQL Server 2000 running on Windows Server 2003, and am experiencing intermittent problems with incoming...

TDye

11-21-2006 02:58 PM
TDye

For reasons that are not relevant (though I explain them below *), I want, for all my users whatever privelige level, an SP which creates and inserts...

Peter Nurse

11-21-2006 01:49 PM
Peter Nurse

I'm trying to help a client export some data from SQL 2005 to an Access database or even an Excel file. Either way I get an error like this: -...

Mindaugas

11-21-2006 11:06 AM
Mindaugas