Hi, Is freeTDS ODBC already ready? If yes, how to find it? Also, is it compatible to Windows: i.e. can itbe compiled on windows. Please tell me if...

Ajay

03-12-2006 02:25 PM
Fabrizio Magni

I need help flagging duplicate records in ome tables I have. For example if I have Table1 which conatins Field1, Field2 and Field3 like...

chudson007@hotmail.com

03-12-2006 11:46 AM
Miks

Hi, When we make a search for a table in SQL Server 2000 sysindexes table is searched and indid field is checked, If it's 0 we go for full table...

Miks

03-12-2006 08:19 AM
Dan Guzman

I have a local install of MSDE on my workstation. I have also defined a linked server with another SQL Server on our network. I accepted all...

Frank Bishop

03-11-2006 03:43 PM
Erland Sommarskog

Hi, I need to shrink a database file and was wondering whether it is required to run a full backup after the shrink operation. In SQL Server 7.0...

deebeeay@gmail.com

03-11-2006 02:18 PM
Erland Sommarskog

Hi We're trying to use call a stored procedure to update information in a remote Ingres database. We've linked the server, and can read information...

chloe.crowder@bl.uk

03-11-2006 02:13 PM
Erland Sommarskog

Hi I have created a Sql Script through Enterprise Manager for Drop a column. By default its creating lot of 'SET' commands. I doubt all these SET...

Dil

03-10-2006 06:35 PM
Erland Sommarskog

I am running SQL Server 2000 SP4 (w/AWE hotfix) on a 32-bit Windows 2003 Server (SP1). I am trying to run an Index defrag and rebuild job. It has...

traceable1

03-10-2006 06:24 PM
Erland Sommarskog

Hi, I have a user-defined function which returns a table (call it '@a'), and has another table defined as a variable (call it '@b'). When I try to...

sean.gilbertson@gmail.com

03-10-2006 02:17 PM
sean.gilbertson@gmail.com

Hiya, Is there really no way to use temporary tables from within a UDF? I like UDFs because I can use them like a table -- e.g., SELECT row1, row2...

sean.gilbertson@gmail.com

03-10-2006 12:14 PM
sean.gilbertson@gmail.com

Hi, I am trying to set up Transactional replication with immediate updation. The configuration is as follows: 1. Publisher is SQL server 2000...

prashant

03-10-2006 06:26 AM
prashant

Hi all, I have recently implemented a SQL 2005 cluster using SQL 2005 Standard on Windows 2003 Enterprise edition. Both nodes have 4GB of RAM and...

IM

03-10-2006 04:36 AM
IM

Hi, I wanted to know if it is possible to do to append two tables into a third table. For example, consider these two tables Table...

Shwetabh

03-10-2006 03:33 AM
Erland Sommarskog

hi, i am a beginner to ms sql server2000 i have a table create table ddd (a int, b int) by table structure is a b now when i enter a value in...

satish

03-10-2006 02:18 AM
Jack Vamvas

i need help in sql query my coding is as under Dim MRUNYEAR As String MRUNYEAR = "0405" Set fgrs = New Recordset fgrs.Open "select CT3HDR.CT3ID,...

GANESH NAIDU

03-09-2006 06:18 PM
Erland Sommarskog

I installed SQL Server 2005 on a server running Windows Server 2003 x64, and it installed into the "Program Files (x86)" directory, so I assume it...

sql_server_user

03-09-2006 06:14 PM
sql_server_user

I have this CREATE PROCEDURE dbo.cmsGetTaskOrdersAndFunding2 ( @FundingDate SMALLDATETIME, @BillingContractID INT, -- null for all contracts @Filter...

CK

03-09-2006 01:01 PM
CK

We are planning to add a new attribute to one of our tables to speed up data access. Once the attribute is added, we will need to populate that...

Ben

03-09-2006 10:48 AM
Ben

I am researching the use of OpenXml for doing mass updates/inserts. Does anyone know how this procedure works as far as sql injection is concerned?...

figital

03-09-2006 10:33 AM
Erland Sommarskog

Hi, I am trying to connect a MS SSIS package to an AS400/DB2 database, and I experience problem when I hit the "Create Package" button in the "Data...

mortenol

03-09-2006 09:33 AM
mortenol

I want the procedure to check for the existence of a paramter and if it is there, it will process these instructions, otherwise it will process...

CK

03-09-2006 08:05 AM
SQL

Hi All I know that I should supply the DDL for the tables I'm going to talk about, but I'm not 100% on how to generate them just yet. Hopefully my...

Laphan

03-09-2006 06:04 AM
Astra

TO all I have tabel autonumber value 1 1 2 5 3 6 4 8 5 9 6 10 7 12

cahyadi

03-09-2006 04:32 AM
cahyadi

When I specify a formula between Computed Column Specification, I have two zero values, getting Divide by Zero error, any idea how can I avoid this?...

Joriveek

03-09-2006 04:17 AM
MC

I have a requirement (motivated by a SOX thing) that is just giving me fits. I know it should be easy and I'm probably overthinking it, but I just...

datagal@msn.com

03-08-2006 08:37 PM
datagal@msn.com

Hi, I am trying to join two tables, one has multiple records per ID, the other is unique record per ID. The two tables look like below A ID date ...

menglin.cao@gmail.com

03-08-2006 06:27 PM
Erland Sommarskog

I am trying to copy the data in excel file into a table using the bcp and this is the code that I have. However the bcp utility does not seem to...

KR

03-08-2006 06:07 PM
KR

hi, i am a learner of ms -sql server 2000, i had a doubt in stored procedures suppose i have a data base having 20 tables, all the tables have...

satish

03-08-2006 05:35 PM
Doug

I am trying to pull some "notes" from a sql database.....the notes that are put into the database come via the web and the user is entering it for a...

cory.craig@integris-health.com

03-08-2006 04:56 PM
datagal@msn.com

Hi, I have a MSSQL Server communicating with an Oracle database through a MSSQL linked server using a MS ODBC connection. If I query the Oracle...

kenneth.osenbroch@telenor.com

03-08-2006 09:49 AM
kenneth.osenbroch@telenor.com

I have a situation where accessing perfmon counters remotely does not display the same list of Performance Objects remotely as it does when doing it...

Marc Melancon

03-08-2006 09:14 AM
Marc Melancon

Hello, We do not run SQL Server in our shop, but I'm starting to be tasked with analyzing SQL Server databases from outside shops. I will need...

Tim

03-08-2006 08:59 AM
Tim

Someone was trying to tell me about a tool to manage MS SQL, but it was a Sybase product. Does anyone know what product that is?

PaulR

03-08-2006 08:19 AM
PaulR

Hi All I wasn't aware of the security feature of MSDE, whereby it doesn't allow the TCP/IP(?) network protocol to work and allow a networked PC to...

Astra

03-08-2006 05:38 AM
Astra

Hi, I want to change the data in a few fields of a table. There are many records (about 1k+). All I want to do to these fields is to append a string...

Shwetabh

03-07-2006 10:30 PM
Shwetabh

Hello, (sorry for my English...) Could you help me with a SQL Server 2005 problem? I had installed SQL Server 2005 and then I tried to setup some...

Andrzej Magdziarz

03-07-2006 06:28 PM
Erland Sommarskog

Hi, I have the following SQL procedure I am running to clean up a filegroup and move all data to a single .MDF file: use <db_name> print 'Move...

jkv10_2005@yahoo.com

03-07-2006 06:20 PM
Erland Sommarskog

How to check if DB Constraints are enabled in a database?

sarada7@gmail.com

03-07-2006 06:16 PM
Erland Sommarskog

Hi all, I am getting this error when insert values from one table to another in the first table the values are varchar (10). In the second they...

suslikovich@yahoo.com

03-07-2006 06:11 PM
Erland Sommarskog

Hi all... I have a table in which some columns has distinct values and some has duplicates..i wan to select all the columns with distinct...

vvyshak@gmail.com

03-07-2006 05:32 PM
Erland Sommarskog

hi, i have inserted the image present in mydocuments using alter command create table aa(a int, d image) insert into aa values (1,'F:\prudhvi\baba...

satish

03-07-2006 05:21 PM
Erland Sommarskog

Rather than setting by session I would like to configure the DB as read uncommitted. Thanx Advance.

Robert

03-07-2006 05:05 PM
Erland Sommarskog

I have a table containing URLs. I want to be able to look up an URL very fast, so I used an nvarchar to store the URL, and put an index on it (maybe...

John Bokma

03-07-2006 01:56 PM
John Bokma

I have a database being populated by hits to a program on a server. The problem is each client connection may require a few hits in a 1-2 second time...

BarrySDCA

03-07-2006 01:40 PM
Ed Prochak

When seting up the Host and Satellite SQL Servers on same subnet replication works fine. Then the same Satellite SQL Server is moved to another...

sjoshi

03-07-2006 11:18 AM
sjoshi

I don't know if the title for the subject is appropriate here, anyway here goes: This process was set up by someone and I have inherited it. I have...

KR

03-07-2006 10:34 AM
KR

Hi All Strange request I know, but could somebody give me pointers on how I can put 3 queries into 1 'thing' and then get only the unique entries...

Astra

03-07-2006 09:17 AM
markc600@hotmail.com

Hi all, I have 2 tables 'ZoneData' and 'ZoneUser'. The 'ZoneUser' table has a column that refers to a 'ZoneData' row. Table definitions and sample...

Dave

03-07-2006 08:39 AM
Greg D. Moore \(Strider\)

I am using Cold Fusion to access an ODBC connection for an accounting program called MYOB. They provide the ODBC driver that you can install. I have...

Erich93063

03-06-2006 03:38 PM
Erich93063

Here's what I want to do: I've got a table with orders, each order has a specific discountrate (an int, which represents a percentage). Each order...

bartvanhemelen@gmail.com

03-05-2006 11:03 PM
Doug