Hello Forum readers, Any advise on the following, will be much appreciated : I have a customer who tries to extract some columns (fields) from an existing SQL table or add more columns (fields) in order to define a different layout (from the current one) and create a new ascii file. I have t...more >>

I have to download a MSSQL database, which shouldn't be a problem using enterprise manager... the problem I have however is that I can connect to the database and export most of the data in to a local database... all except the main table... which gives an error... the problem I believe being ...more >>

We are replacing our server with a new 2 processor system, with Windows 2003 server. My question really has to do with licensing, partially. If I use our currently licensing for SQL2000, which is licensing the server, and CALS per workstation, will SQL be able to utilize both processors to t...more >>

Hello, I'm in search of a sample database (along the lines of Northwind or AdventureWorks... but not) that I can use in product demos. Preferably free, but if you know of one that's also for sale that would be great too. Any ideas where I can find something like this? Thanks in advance, ...more >>

I am trying to establish if the standard edition of SQL server 2005 actually has support for a 2 node active/passive cluster and if it will be available in the proposed product release on November 7th. I have seen references to this in http://www.microsoft.com/sql/2005/productinfo/sql2005fe...more >>

I am trying to establish if the standard edition of SQL server 2005 actually has support for a 2 node active/passive cluster and if it will be available in the proposed product release on November 7th. I have seen references to this in http://www.microsoft.com/sql/2005/productinfo/sql2005fe...more >>

I write you because I have a big problem with request access : when I use a sql server wiev in access (attached view) and i join it with a local access table, the sql server trace say sql server send all the data of the view to a access . This view have 15 000 000 ...more >>

I have a SQL Srv 2000 table where one of the columns is a Phone number, but all of the data is simply 10 digits (2065551212) ... I need to run something that will either alter all of the values so that they display the appropriate marks (206) 555-1212 or at least mask the column data so it ...more >>

I have a table that has 8 columns and if looked at on row by row basis, every row has at least one entry. I need to keep the data in the first 2 columns together, second 2, third 2 and fourth 2........basically the integrity of the rows is by groupings of 2 columns. Is there a way to compac...more >>

I have a table with a smalldate field, I need to compare with current date, but only the month/day/year and not the time. I tried: Select * from table where date = left(DATEADD(day,0,getdate()),12) But I get no results, what am I missing ? Aleks ...more >>

Hello, I'm just entering the SQL DBA field and i'm looking for article or site that outlines little things to watch out about sql server. I'm more interested in the operational aspect such as "never reindex during production hours", when to run dbcc commands, and what hash join and nest loo...more >>

Hi All, I have a very large DB in SQL 2000. I would like to change the properties of a field (increase the number of characters).The field is currently nvarchar 50, I would like to make it 100. What should I do? do I need to run any util to update the structure of the DB? Thanks in advan...more >>

First I'm sorry if this isn't the right place but I'm between a rock and hard place. We have a process in place to move data from the mainframe thru Access to SQL Server. The guy that set it all up is long gone, and since my boss thinks that DB2 running on an IBM mainframe and SQL Server runni...more >>

I have a dts created file (from a text file) that has a column which is defined as varchar. The data is actually a floating point number. How can I convert it in SQL to reflect this? In design table can I simply change the data type to float? TIA...more >>

Hi all, I am Very NEW to SQLSERVER family had been working with ORACLE & DB2 . i am currently working on SQLSERVER 2000 version. 1) Like in Oracle we have NVARCHAR dataype to support internationalization what is the simillar one in SQLSERVER 2000 2) Oracle supports unique time zones f...more >>

Hi all, I am developing a multi user application using Delphi. Currently I am using a database engine that is terrible. I am considering switching over to SQL Server. One of the features that I could really use is for the client applications to be notified when data changed. That is, if on...more >>

Hi there. If I'm designing a table of menu items to be used as a "drop down box" in an application where the user can either choose a pre-existing item OR type in a new item, should I form a relationship between the table with the list of menu items and the table where the item will appear?...more >>

I have a newbie question about duplicate data. Here is the situation. Let's say I have a pets table, all kinds of info about pets, weight, age and NAME. Using name as an example, it is very likely that I could have multiple entries for "Max" Given the fact that this table is in essence a de...more >>

I have a required where I need to get a comma separated file. How to convert values 1.59 to display as "1.59" ...more >>

No one knows how to architect a system like me, but I keep running into so called experts who state their opinions as facts and take the time to dare question my knowledge. Some examples of the right way to do things. If there is a performance problem in a few large databases, break them in...more >>

Hi, Can anyone give me a sample syntax if I want to execute a batch file on a remote server using SQL SERVER job (using CmdExec) and remote.exe My server name is: KOZEL My network share and batch file to execute: \\kozel\cognos\call_option4.bat How would my remote.exe syntax look? Th...more >>

hello all In my application i have a table of 10,000 records. i need to fetch them 1000 at a time . Which mean first fetch 1-1000 Second fetch 1001-2000 third fetch 2001-3000 and so on . What is the method that i can use to extract data rows like this can anybody help me out with this pl...more >>

This is my first foray into MS SQL Server, so I am trying to get my feet wet with a couple of things. One thing I am trying to do right now is fill in a uniqueidentifier field I added to a table using the NEWID() function. In MS Access, I would have cranked out a little VBA code that simply ...more >>

Hello, I have a file that ends with .dts. I believe this file is the actual script for the .dts package and not the data itself. Does anyone know how to access this file or pull it into SQL since it is not in a DB? Thank you! Diane ...more >>

Hi there Please help!!! I'm using the "System.Data.SqlClient" namespace in an ASP.NET/VB.NET page to connect to a SQL Server 2005 Express database. Moreover, I'm using XCopy and "Database=temp;AttachDBFilename='c:\temp\temp_Data.mdf'" in the connection string when I attach to the databas...more >>

We are in the initial stages of migrating the backend of our MS Access database to a MS SQL Server. In setting up a test FE for testing, I have noticed on several occasions when I have replaced a link to a table in the Access BE with an ODBC link to the SQL Server that Access FE asks to "Sele...more >>

I am in the process of taking my first stab at a MS SQL Server based DB. The original DB was in MS Access and had a front end DB with the GUI and a back end with the data. The data has been successfully transferred to the SQL Server. Now I am in the process of re-building the relationships...more >>

I have SQL SERVER 2000 Deverloper & Windows 98. When install it , I can't select SQL server option. My computer show is "OS not support you can install connect only option and read only option. I want to install SQL server option. ...more >>

I have my application installed on one server and SQL server installed another system, which my application uses to log the data and rerieve the data. I want to check for the physical mdf and ldf files, if they are present, i need to make sure that link is proper. I am using "dbcc checkdb" ...more >>

Hi, In Access, I'm used to entering "Date()" or "Now()" as the default value for a date field, when I want it to record "today's" date. How do I do this in SQL Server? I have a datetime field in there, and neither Date() or Now() are being accepted. Thanks Nath. ...more >>

In this post I am going to try to simply a question that I posted earlier. Can I use VFP to access a SQL Database? If so what is the command? What is the best software for creating applications to work with SQL? I am just getting my feet wet with SQL so please take it easy on a rookie. ...more >>

Hi Guys, I am trying to connect SQL Server using perl and I am able to do the same in a perl script. When I run the script from command line it works perfectly fine but if the same script I invoke from GUI it throws the following error Error: [Microsoft][ODBC SQL Server Driver][SQL Server]...more >>

Is there a function I can use in my view to cause a field to be displayed in proper case (first char of each word upper case, rest lower)? ...more >>

Sorry about the crosspost - trying to get a difinitive answer- If I'm running a Legato Co-Standby or CA Brightstor failover setup, where only one server is accepting connections at a time. Do I need to purchase a full count of SQL and Server client licenses for both servers. I've heard that I...more >>

My number in a field is 3.3999999999999999 but I need this to be stored as 3.39 How to get do this convertion ...more >>

Hi there I have Ken Henderson's book in front of me (pp. 193-194) re: producing a simple histogram. His code is as follows: SELECT "Less than 10"=COUNT(CASE WHEN s.sales >=0 AND s.sales<10 THEN 1 ELSE NULL END), "10-19"=COUNT(CASE WHEN s.sales >=10 AND s.sales<20 THEN 1 ELSE NULL END), ...more >>

I recently received a new pc at work running the following operating system: OS Name Microsoft Windows XP Professional Version 5.1.2600 Service Pack 2 Build 2600 My previous pc was running: OS Name Microsoft Windows 2000 Professional Version 5.0.2195 Service Pack 4 Build 2195 On my old pc ...more >>

I have a database containing something like the following. Status Magic OthMagic A 1 0 A 2 1 A 3 4 B 1 1 B 2 0 B ...more >>

Hi there What is the precise meaning of "Warning: Null value eliminated by aggregate or other set operation"? In which circumstances would this be an expected result (rather than a "warning")? Best regards Loane ...more >>

I use linked server to get data from Oracle one query returns only 32 records when there is 150 in the oracle table as select * from openquery(linkedServerName,'Select org_id from org_tb') select count(*) from openquery(linkedServerName,'Select org_id from org_tb') returns 32 but selec...more >>

I need to have the output parameters from a stored procedure stored procedures returns three columns id int, @custcap char(32) OUT, @knowcap char(32) OUT as inputs to my query like below select c1,c2,c3,c4,output from stored procedures from t1,t2 where t1.id=t2.id How is this poss...more >>

How can i check whether an non clustered index exists on a table without using the system table (sysindexes)? I have tried the books online with no success. My intention is to use a format like shown below; IF (OBJECTPROPERTY( object_id('FK_Project_TO_CostCentre') ,...more >>

I'm running a local MSSQL 2000 server and everything has worked fine until this week... when it suddenly stopped working and to fix it I had to reinstall the master database... which now allows the server to run. My problem is however that I cannot login to the database using windows au...more >>

I'm running a local MSSQL 2000 server and everything has worked fine until this week... when it suddenly stopped working and to fix it I had to reinstall the master database... which now allows the server to run. My problem is however that I cannot login to the database using windows authen...more >>

I have just started using DTS in SQL enterprise manager and have been successfull in importing my files. I now have 536 files that I have to join together.....concatenate would be a better term I guess. I want to combine all the data in the files into 1 new file. Could somebody please explain...more >>

Hello, All. Does anyone know if you can make tables and fields variables in SQL? I have a couple queries that I need to run on many tables, the only thing that changes is two tables names and the keys that join them, the rest of the query stays the same. For some reason it does not work. ...more >>

I need to import data in several hunderd excell spreadsheets to a sql 2000 table. What function should I use? Do I need to create a table in sql with the same columns as the excell file and then run a query? Thanks for any help ...more >>

I installed SQL onto the local C: drive and need to have a database created (or move the default installation) to the RAID drive. I've read that it can be done with attach and detatch statements, but not the master, msdb database files. Do I need to reinstall?...more >>

I am a new user of SQL Server. Now I need to migrate the following stored procedure from Oracle to SQL Server. Can someone tell me how to do it? Procedure ModifyTree(I_TableName in Varchar2, I_ColumnName in Varchar2, I_ParentName in Varchar2, I_ColumnValue in Varchar2, ...more >>

I've reviewed some of the info on Metadata services in the BOL, however, there isn't any kind of comparative review or samples of how it is actually used. I'm looking to document a new build of a data warehouse and want to create a metadata repository to enable lineage searches, links to trans...more >>