Hi I have written an application in VB through which I can convert DBASE IV database to MS SQL Server database. Also, the application...

Shwetabh

04-27-2006 07:08 AM
Erland Sommarskog

Hi Could somebody may explain me how works backup in clusters ? Thanks Adam

Adam

04-27-2006 07:01 AM
Adam

Hello, I have been researching the use of symmetic and asymmetic encryption in SQL 2005 and I am pretty excited to give it a try. Through examples,...

rcamarda

04-27-2006 03:34 AM
Erland Sommarskog

The XML Datatype does not support the case-insensitive search makes the XML DataType (almost) useless, if I stored the xml in the XML column,...

John

04-26-2006 06:06 PM
Erland Sommarskog

hello all, i have this table: CREATE TABLE . ( NULL , (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON GO

hharry

04-26-2006 05:50 PM
Hugo Kornelis

Hi, I was hoping someone could confirm the following about the following number 2 SQL query: 1. This extracts the data required given that there is...

David

04-26-2006 05:46 PM
Hugo Kornelis

Hi all, I am a newbie with SQL and I have a statement that someone else wrote for me. It works up to a fashion but there seems to be a bug with it...

alanenglefield@gmail.com

04-26-2006 05:34 PM
Erland Sommarskog

Dear MSSQL experts, I use MSSQL 2000 and encountered a strange problem wqhile I tried to use a select into statement . If I perform the command...

Daniel Wetzler

04-26-2006 02:09 PM
AT

Does anyone know how to how to performance case-insensitive search on XML data type in SQLServer 2005? Or I have to convert all the xml data to lower...

John

04-26-2006 12:08 PM
John

Hi need help My english is not good so ill be short. This is my database create table customers ( customerid int unsigned not null auto_increment...

Bandul

04-26-2006 05:37 AM
Bandul

Is it possible to do SQL log shipping to more than one Databases on same Secondry Server WITH A DIFFERENT SCHEDULE for each log shipping? You can...

AT

04-26-2006 03:27 AM
AT

I have one table used to maintain information on Service Events. Each record contains a Repair, Maint, and Battery checkbox (bound/boolean). Any one...

AT

04-25-2006 11:18 PM
AT

Hi, We are in the process of buying a new server to run mssql. However before this as a tempory fix to using a msaccess backend i believe through...

David

04-25-2006 05:30 PM
Erland Sommarskog

I have the following basic statements being executed: Create a temp table, #TempPaging Insert Into #TempPaging (Col1, Col2) Select Col1, Col2 From...

pb648174

04-25-2006 01:31 PM
AT

I am developing an integration process between two databases. One of them is a SQL Server 2000 and the other is using MSDE 2000. The integration...

AT

04-25-2006 10:09 AM
nicolas.bouchard (AT) gmail (DOT) com

If this is in the wrong group lemme know and I'll re-post it to the correct one. I am using PHP and MySQL. Suppose I have a table named "servicios"...

Philippe Signoret

04-24-2006 09:20 PM
Philippe Signoret

Hello Everyone, Stylus Studio has just released a new educational video tutorial entitled An Introduction to XQuery - you can watch it online...

Stylus Studio

04-24-2006 05:47 PM
Stylus Studio

I inherited an existing database application about 6 months ago. I've finished converting it to use SQL Server 2000 as the backend (MS Access 2002...

Beowulf

04-24-2006 05:37 PM
Erland Sommarskog

I've got a table that contains a column of accumulating uptime data that looks similar to this: 239.13 239.21 239.30 239.38 239.46 239.55 0.35

sucaba.r@gmail.com

04-24-2006 12:44 PM
Tom Moreau

Tools: SQL Server 2K, Excel 2000 Hi, I have an Excel report worksheet with formatted headings. What I want to do is to export data from the SQL...

Edgar

04-24-2006 10:28 AM
Edgar

Dear all, I have been always accessing my database using the intergrated ASPNET account; by default in MS VS 2005, a web site with a solution...

coosa

04-23-2006 06:40 PM
coosa

My article on dynamic SQL, "The Curse and Blessings of Dynamic SQL" is frequently referred to in these newsgroups. I like to announce that I have...

Erland Sommarskog

04-23-2006 06:20 PM
Erland Sommarskog

Hi My DB backup and transaction backup of a database keep on failing with the following error: Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:...

David Greenberg

04-23-2006 10:07 AM
Dan Guzman

Hi, In SQL 2000 if I wanted to take a complete copy of another running sql database all did was create a new database locally and right-click it and...

maflatoun@gmail.com

04-23-2006 06:57 AM
Erland Sommarskog

I am learning SQL Server 2005 and I was told to install a second instance of SQL Server 2005 on my machine. How can I install a second instance of...

David

04-23-2006 12:20 AM
Dan Guzman

I have a data file that I converted from Access to SQL Server using the upsizing wizard. I then attached the tables to the Access front end using...

Rico

04-22-2006 02:23 PM
Erland Sommarskog

Hi I'm new to SQl.. I have some monthly data which is being encoded as Varchar...Say for the month of January 2005 it wud look like '200501'. For...

balaji.balaraman@gmail.com

04-22-2006 11:10 AM
--CELKO--

Lyle Fairfield (lylefairfield (AT) aim (DOT) com) writes: At least that was a concise comment. Nevertheless, exactly what you think is crap? How...

Rico

04-22-2006 07:05 AM
Erland Sommarskog

We have a 3 month old quad processor/dual core server running SQL Server 2005 and already it is getting close to hitting the CPU wall. An 8 way CPU...

IanIpp

04-21-2006 03:36 PM
IanIpp

I have a SQL based ERP package. Now I am having an issue on a particular table of people deleting a record (in the ERP system) and no one having any...

mike

04-21-2006 03:13 PM
mike

hi! I have two tables with same structure. I need to run a select query that will return only the rows from one table that are not in the other. In...

Zvonko

04-21-2006 02:46 PM
Gert-Jan Strik

Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user...

Friends

04-21-2006 02:17 PM
MGFoster

Hey Everyone, Stylus Studio has just released a new online video tutorial entitled: An Introduction to XSLT. You can view this free online video...

Stylus Studio

04-21-2006 11:45 AM
Stylus Studio

In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How...

shawn

04-21-2006 09:08 AM
John Bell

Can you please assist me on how to get the 2nd record in case there are 3 or more records of an employee, the query below gets the MAX and...

heri

04-21-2006 07:05 AM
Madhivanan

Hi, I have the following set and would like to select all rows that have min value of column 4 for a given column 1 and 2 group, irrespective...

tamashee@yahoo.com

04-21-2006 07:02 AM
Madhivanan

Hi Everyone, I use the following to get records from the last two days in MySql: where date_entered <= curdate() and date_entered...

John

04-21-2006 06:55 AM
Madhivanan

In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How...

shawn

04-21-2006 03:04 AM
John Bell

Hi all, I am having issues of efficiency of backing up data from one SQL data base to another. The two servers in questions are on different...

Vishal

04-20-2006 10:56 PM
Vishal

Hi, I have a .NET application that I want to save the Config.EXE contents to my SQL database for remote review/testing. This config file is 3700+...

ZRexRider

04-20-2006 10:43 PM
Liang Zhang

Is there anyway in SQL Server to rollback an SQL statement which was already executed. I know there is a transaction log but what it contains and how...

Jack

04-20-2006 05:07 PM
Erland Sommarskog

Hi all, I posted messages before about trying to purge many records (about 35%) of a 200Gig database. The responses gave me a lot to think...

hallpa1@yahoo.com

04-20-2006 05:01 PM
Erland Sommarskog

We set up a test box and having been trying to move an entire instance from our production server to this one. I have moved all my created dbs using...

murrayb3024@gmail.com

04-20-2006 05:29 AM
Ajay Rengunthwar

For some reason, I recall having read that SQL Server 2005 would support a datatype that represented date, but not time. (This would be useful for...

Larry Bertolini

04-19-2006 08:04 PM
Greg D. Moore \(Strider\)

I've previously used version 7 and 2000. I've recently started to learn ASP.net. I've installed Visual Web Developer 2005 Express and this...

C.O.Jones

04-19-2006 04:21 PM
C.O.Jones

Is there possibility to use IF conditions inside SELECT statements? For example, can i write something like this: CREATE PROCEDURE ( @OPTION...

Igor

04-19-2006 11:48 AM
Hugo Kornelis

Hey Everyone, Stylus Studio has announced that Stylus Studio® 2006 Release 2 XML Enterprise Edition provides integrated support for xqDoc from...

Stylus Studio

04-19-2006 11:01 AM
Stylus Studio

SQL 7.0 Stored Procedure Execute Privileges Only? Does anyone know if a user/pass can be set up to give a sql 7.0 user stored procedure execute...

Edbar

04-19-2006 07:54 AM
Ajay Rengunthwar

I am hoping this is a quick easy question for someone! :) I am trying (struggling) with moving data from Sql Server to a Lotus Notes table. I am...

ProgrammerGal

04-19-2006 07:06 AM
John Bell

(excessive crossposting limited to two of the foour groups) On Tue, 18 Apr 2006 17:57:02 +0200, Peter wrote: Hi Peter, The point I'm missing in...

Hugo Kornelis

04-18-2006 05:56 PM
Erland Sommarskog