Hi, I am getting an error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." My application is developed using VB.net. I use SqlServer2000. I get this error when 15-20 clients work with the same page.When the user click...more >>

Hi Can you give me sone pointers to where I can get more information about the various operations like index seeks,Bookmark Lookups,Clustered Index Scan in an execution plan. Thanks Ragu ...more >>

Hi all, I have to write a program to read the names of databases in Analysis Services. I don't know which table I can get this information from. Thanks a bunch ...more >>

I got log shipping to partially work *lol* any how what my new issue is, the masterdb, any good documentation? Ive tried searching google and find very little on that matter. Thank you ...more >>

Hi Friends I have question. I connected oracle and MS access tables(via Delphi7). I wanna get type of field in indicated table. For example if it is integer or boolean e.t.c Please tell me the SQL function or whatever that retrievs type of field. Thanks *** Sent via Developersdex http...more >>

Hi, I am completely new to the BCP utility and fairly new to SQL Server I am learning from a book and I am trying the following example (the server I'm learning on is called contractor and a password has not been give to the sa) bcp pubs..authors out authors.txt -C -r \n -t, -U sa -P -S c...more >>

Hello, I have the following setup and I would appreciate any help in improving the performance of the query. BigTable: Column1 (indexed) Column2 (indexed) Column3 (no index) Column4 (no index) select [time] = CASE when BT.Column3 = 'value1' then DateAdd(...) ...more >>

Hi, a query of mine slowed down significantly when this statement was added into the where: (DATEDIFF(day, Col_StartDate, GETDATE()) BETWEEN 1 AND (SELECT CASE datepart(dw, getdate()) WHEN 1 THEN 2 WHEN 2 THEN 3 ELSE 1 END) ) What ...more >>

I am facing problem like; We generate reports thru Excel Pivot table. The data is coming from sales cube. Let?s assume that there are 2 products A and B. The user wants to filter for each product and view ?stock in hand? and ?total sales? for particular month (as two columns). From the Pivo...more >>

I have a database file approximately 30GB in size which creates 3 data tables daily. I need to reduce the size of the DB due to disk size limitations. Could I EXPORT some tables, let us say over thirty days old, to something like DB_Name_Archieve and them delete them from the production DB to ...more >>

Given this table: CREATE TABLE #T_PEOPLE ( SSN char (9), BIRTHDAY datetime ) insert #T_PEOPLE(ssn, birthday) values('123456789', '1/1/60') insert #T_PEOPLE(ssn, birthday) values('111223333', '1/1/50') Which query is faster to find the ssn of the older person? This query: select top 1 SSN ...more >>

Hello, I'm using Entreprise Manager (for Sql Server 2000) to generate my database's script. By mistake, i've changer FillFactor one time. And, now I can't remove this data from generated sql script. How to remove that ? Thank's a lot. ...more >>

I have a table where inactive names are lower case and active names are uppercase. Note: Not my design. Anyways I want to select all names form this table where the name is uppercase. I see collate and ASCII pop up in searches but the examples don't seem usable in queries as much as they were ...more >>

I know this is very very silly. But I am stuck and don't know what to do. I have a simple form which has 1 textbox and a 'Save' button. I have created a Database connection and an Adapter with Dataset with the help of Wizards. I have binded by text box control to one of the database field...more >>

Can any one direct me to sources for best practices of field types and sizes to use for commonly used information such as address, names, city, business names .... Thanks, Brian ...more >>

Greetings All, currentley there is a heated discussion in my place of work over which method is better/more efficient for simple selects. Background: 1.) Simple Application that uses sql server for backened db. 2.) The application is only inserting and selecting data from the db. 3.) The deve...more >>

Greetings All, currentley there is a heated discussion in my place of work over which method is better/more efficient for simple selects. Background: 1.) Simple Application that uses sql server for backened db. 2.) The application is only inserting and selecting data from the db. 3.) The deve...more >>

Hi group I want to make a new serverinstance, but based on some old files from a previous instance I once had from a SQL I scrapped. I only know how to use the SQL Server enterprise manager console, and I haven't found any tools in there to do that. Any suggestion will be more than welcome. ...more >>

Hello, I'm trying to find the most optimal way to perform a tricky query. I'm hoping this is some sort of standard problem that has been solved before, but I'm not finding anything too useful so far. I have a solution that works (using subqueries), but is pretty slow. Assume I have two table...more >>

I have a very big table with 20 million records DistinctProjectionKey which i join several times to different tables in this query. select distinct distinctprojectionkeyid,dpk.MarketID, dpk.Classificationid, dpk.DistributorID, dpk.ManufacturerID, dpk.LocationID, dpk.TimeID,P4.FACTOR as f...more >>

Hi... SQL SERVER 2000 SP3, WINDOWS 2K SERVER... If i run this command on a remote server select replicate(' ',190) i have the following error [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 Genera...more >>

I am developing a simple DB-Library program in C calling SQL Server 2000 on windows 2003 and NT 4. I have some T-SQL code that checks for the existence of a table and want to abort the program if the table doesn't exist. I issue a raiserror if the table doesn't exist and then call RETURN. I co...more >>

My main table has the following structure: t1 (id_primary, id_secundary, name) i.e. [(1,1,"name1"), (2,1,"name2")] I want to join this table with the following second table: t2 (id_primary, id_secundary, value) i.e. [(1, NULL, "value1"), (NULL,1,"value2")] The join should first try to f...more >>

I have a table which has 10 columns which make up the secondary key. 1 or more of these columns can be set but the remaining columns in the secondary key will be null. For example : id k1 k2 k3 k4 k5 k6 k7 k8 k9 k10 data ------------------------------------------------- 0 1 1...more >>

http://www.surfjunky.com/?r=cps ...more >>

Hi, I've a problem with making a query. I need to get out a result where a date for example 25-02-05 is in a table. The problem is that the dates in the table are old like 25-02-03. So is there a sollution where I only need the day and month to get the result? Thanks, Fred ...more >>

Dear All, (No aswers on access newsgroups) Access2000.adp connected to SQL-server 2000 MainForm unbound: seachform on companies meeting a complex combination of criteria. SubFrom and ListBox to display the searchresult ( 2 outputs to test what's best). Searchresult is stored in a creata...more >>

I'd like to convert a Decimal value into a string so that the entire original value and length remains intact but there is no decimal point. For example, the decimal value 6.250 is selected as 06250. Can this be done? ...more >>

Dear All, Tables: ORDER, ORDER_PROPERTY relation ORD_ID = OP_ORD_ID ORDER: ORD_ID, ORDT_ID, ORD_NAME, .... ORDER_PROPERTY: OP_ORD_ID, OP_PRP_ID, OP_VALUE I want a list ORD_ID, ORD_NAME, OP_VALUE of all orders with ordertype (ORDT_ID) = 1 showing OP_VALUE for OP_PRP_ID = 144 and a blanc c...more >>

I need to bring the ssn's into UniqueSups (supervisors) from tblNonNormalized. My inherited DB is not normalized and I find it extremely irritating due to the workarounds needed. I created tblUniqueSups by doing a select Distinct Supervisor Name. Now I need to bring in the SSNs of the Unique Su...more >>

Hello, I need to import a bunch of .csv files. The problem I am having is the "non data" information in the files creating bogus rows and column definitions. Here is an example of the csv file. CBOT - End-of-Day Futures Bulk Download 2001. 2 Year U.S. Treasury Notes Futures Date ...more >>

Let me start by saying that, yes we know v6.5 is no longer supported by Microsoft and that moving to SQL2000 might resolve our problem. Actually the migration to SQL2000 is 1 to 2 months out and in the QA phase now. Unfortunately we need to resolve the current 6.5 issue now as it heavily impact...more >>

I am new to BCP. Can anyone help me understand this? I tried searching the BOL but it doesnt show much help on syntex. Lets say I have a simple table and want to out put the records into a file. Then with that output file, I want to create a format file using the BCP utillity and builk insert it...more >>

Hello All, Does the BCP utility enable you to selectively import rows from a flat file to a table ? For example: The first column in my flat file contains a record type - 1, 2..7 I only need to import types 1, 2, & 3 Can this be specified in the .fmt file ? Thanks in advance hh...more >>

Hey guys I have to implement a dynamic Parent - > Child Scenario ... but the catch is as Follows : I need to create this Table Design so that I can have multiple Parent -> child - > parent Relationships (ie Db driven "Window Explorer - feel". 1 Folder that holds another Folder that holds...more >>

Hi Our SQL server has a lot of stored procedures and we want to get some cleaning up to be done. We want to delete the ones that have been not run for like 2-3 months. How exactly will i find out which ones to delete. Enterprise manager only seesm to give the "Create Date" How exactly can I fin...more >>

Hi, I feel so stupid to ask this question, but here it goes When I select a column from a table, if the column has a null value I want the select to return me a blank. I have done this before but I forgot, some one help? select name, age from people in the above query the name can be n...more >>

Hi all ! Does someone know how many concurrent connections 2005 Express can accommodate ? The limit on MSDE was 5 before performance drops considerably. Thanks for your help. Sebastian ...more >>

Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database software. There are 7 workstations (windows 2000 and XP) that run the parts database. 4 of those workstations run really fast, the database calls ar...more >>

Okay all I have a problem. I have two list of adresses and phone numbers. I do not have control over the contents of the lists The only unique field between the two is the phone number. I need to be able to inner join the two lists on phone number. This would normally be straigt forward but...more >>

Can someone tell me why SQL seems to ignore my order by clause? I tried to run through the debugger, but the debugger stops at the select statement line and then returns the result set; so, I have no idea how it is evaluating the order by clause. THANK YOU! CREATE proc sprAllBooks @SortAsc...more >>

I have a Database on a MS-SQL Server wich was at the beginning 55 MB (size). Every time I Backup the database the size increases (50 mb each time) !!! Now it is over 700 MB of size and I can not store it in a CD !!! Somebody told me that the size wich is increasing is that of the LOG FILE... Wha...more >>

Is it possible to get the machine name in a trigger so that it can be stored in a field? Thanks. ...more >>

Group, Is there a way to assign nullability on a column when using a select into? I've tried some of the usual things like coalsce, isnull, and cast. Since the new table gets definition from the source table or can be somewhat adjusted with cast is there a way to cast a not null? In the e...more >>

say I have a table with field1,field2,field3,.... and have a SP with a parameter @myfield is there a way I can do Select @myfield from Table1 thanks for your help ...more >>

I have a DTS package that needs to refresh data in 3 separate Excel spreadsheets on a daily basis. The problem is that unless I manually delete the previous day's data, it appends rather than replaces. I can't delete the excel files on a daily basis, as they have to be there for the DTS packa...more >>

Hello. I hope I have choosed right group. I have problem preparing SQL syntax. I think it is quite simple but I haven't tried to do this till now. The thing is that I have a string and I must compare it with text fields in database. But the problem is it could not be simple > SELECT * FROM T...more >>

I have a deadlock situation, part of the problem looks like this; spid ecid dbid ObjId IndId Type Resource Mode Status ------ ------ ------ ----------- ------ ---- ---------------- ------- ------ 404 0 9 792389892 1 KEY (010086470766) SIU WAIT ...more >>

I am in the process of upgrading from Access to SQL Server. When I import the tables from an access file, everything looks normal in Enterprise Manager. All the tables are listed properly. However, when I login through Query Analyzer, the tables names have a prefix (my username). Why is that? ...more >>

I made a trigger for delete just like this. " CREATE TRIGGER [MbPromoHdrDel] ON [dbo].[MbPromo_hdr] FOR DELETE AS Declare @severity int, @IdNmbr nvarchar(10) Set @Severity = 0 Declare NoId Cursor Local Static for Select [Promo_Id] from deleted Op...more >>

Hi, I am trying to execute a simple sql file thru ant task. The file is: use [centivaTest] GO However I get the errror message: [sql] Failed to execute: use [centivaTest] GO So I changed the file to: use [centivaTest] ; GO as ant treats ';' as a delimiter. However another erro ...more >>

Hello, I have two tables (table1 and table2). I want to set a flag in table1 for each common row with table2. I use the following syntax UPDATE table1 SET flag='Y' from table1 INNER JOIN table2 on (table1.a = table2.a) AND (table1.b = table2.b) However the situation arises where I may have...more >>

Hi all, I have just written a sql statement where I want two fields updated from another table. The statement like so: update kpidmatter set clientcode,clientname = (select clientcode, clientname from clientconversion where (clientcode = kpidmatter.clintcode)) where exists (select clientco...more >>

I am attempting to set up log shipping from my primary dell clustered 2 node sql server to a backup quad xeon server in case of a failure. When I follow the information given from Microsoft regarding this and I get to the point where I am at "Add Destination Database" I am being prompted for m...more >>

Hi, I have just started a business and I was wondering if I could get some advice about product selection. I am currently buiding my website using asp.net connecting to sql server database. My question: Am I only required to purchase a SQL Server Developers Licence? I won't be hosting the s...more >>

Hi Your help for the following query will be highly apprecaited. I've wasted alot of time on it. Data definition is at the bottom. Thanks ----------------------------------- Business need: User selects answers for few questions. Answers are presented in the form of radio buttons. ...more >>

Is it possible and how do I do use a select like query with an ado command's parameter object? For Example: Instead of this: command.CommandText = "SELECT * FROM Table WHERE field LIKE '%searchString%' This: command.CommandText = "SELECT * FROM Table WHERE field LIKE '%?%' command.Parame...more >>

I have two win2003 servers. One is IIS and the another is SQL server. I can use MyConnection=new SqlConnection("server=SQLServerName;database=myDBName;UID=sa;PWD=mypwd") to access my data. But I can not use MyConnection=new SqlConnection("server=SQLServerName;database=myDBName;Integrated Securi...more >>

Adding numerical field to filters in openquery is as easy as typing the number but I am having major problems using strings. I have tried a few solutions including the usual concantenations but no solution. Is there a simple way of including strings with the filters for a query below, possibly...more >>

Hi, Say, a database has all the FK constraints created properly, would sql server 2000 save this kind of meta data into sysforeignkeys table? Or it depends on ...? I'm trying to find all the orphen records in a given database via meta data. TIA. ...more >>

Hi, I am trying to call a user defined function(UDF) from a stored proc, using a default parameter in the called UDF (e.g. @bid_price_type int = 0 ). However the calling stored proc complains that the UDF is expecting a 2nd parameter when I only provide the @test parameter value. Are default...more >>

I need help in T-SQL. I am using DATEADD function and I want to add 6 months to a date. But it does not return me the rusults, which I want e.g. SELECT DATEADD(m,'20040630') returns 20041230 which is logical correct? But I want it to return end of month (i.e. 20041231) Any help in this c...more >>

Recently, using PERFMON, I've been rather dismayed to find that our application is averaging 3 - 4 lock timeouts per second, and frequently has extended periods of several minutes where this figure reaches the hundreds. Average LockWaits/sec are less than 0.05, and TableLockEscalations...more >>

Recently, using PERFMON, I've been rather dismayed to find that our application is averaging 3 - 4 lock timeouts per second, and frequently has extended periods of several minutes where this figure reaches the hundreds. Average LockWaits/sec are less than 0.05, and TableLockEscalations/sec ...more >>

I have installed SQL Server 2005 Beta 2 on my PC. When I try to make a connection to it from the DTS environment, I get following error: ============================================= Could not get server list. (DTS Import/Export Wizard) ============================================= [DBNE...more >>

Hi, i have "req_date" column of "datetime" type in Database table besides other columns. From my Web page, i am calling the Stored Procedure with variable parameter "Search_Date" of Varchar(60) type. the value, i am passing to Stored procedure through "Search_Date" is compared to req...more >>

From what I've read in the docs, ado.net currently supports opening sql server ce tables in table-direct mode and performing Seek operations on them (using SqlCeDataReader), but not on the full-blown sql server. Is this (will this be) still true with ado.net 2.0 & sql server 2005? ...more >>

I am using Visual Studio .NET 2003 with SQL Server 2000. I am trying to insert the date and time into a SQL database by using hour(now). I am having a hard time trying to figure out which datatype to use in SQL to store this value. I have tried using datetime, char, nchar, text and nothing seems...more >>

Dear Techies, I making one stored procedure, which does some operation based on an interface hash (#) table ---- name #mydata. This stored has two section of code (seperated by parameter value 0 and 1) But hash table #mydata (same name) number/name of columns changes as per call 0 or 1. ...more >>

I know when you are using group by functions you have to include all the columns in the GROUP BY clause. But what I am having problems when using a case statement to determine whether to sum of not a column. eg. SELECT Country, Case WHEN Age<15 THEN Sum(Income) ELSE NULL END AS YouthInco...more >>

hello, what is the sql server 6.5 equivalent for: "select catalog_name from information_schema.schemata" i would like to see a list of available schema's on a server and this seems to work on 7.0 and newer. would i be able to do it with the systables ? i have looked through the content o...more >>

How can I make something that in MS Access query looks like this: SELECT IIF([Amount] Is Not Null,Amount,0) AS PayedAmount ... Regards, Markonni ...more >>

I'm doing what I thought was a simple GROUP BY summary of fairly simple data and the my numbers aren't working out Some results are showing up <NULL> when I know the data is in the database I'm no SQL expert, but if I'm summing (SUM) multiple fields and adding them together in my...more >>

hello, At the beginning I would like to describe my very simple table. It is composed of three columns: 'name', 'forename', 'status'. This database stores results of games. The values of column 'status' can be only: 1 for win, 2 for lose,0 for draw. My aim is to get a table which consists als...more >>

Thank you for taking the time to look at my question. Any help would be much appreciated ! Database: Microsoft SQL Server 2000 Database Structure: 1. tblEmployee a. EmployeeID 2. tblCertification1 a. VisitDate b. CertificationScore1 3. tblCertification2 a. VisitDate...more >>

SQL 2000 I thought I would throw this out there for some feedback from others. I'd like to know if you feel using MS auto-increment field is a good solution these days or should one grow their own ? Thanks, Me. ...more >>

I am using SQL Server 2000. I have created a new database in Query Analyzer but I cannot see it in Enterprise Manager. I then created a new database in Enterprise Manager, but I can't see it in Query Analyzer. How do I get these applications to see the databases that the other creates? ...more >>

Here is an issue that has me stumped for the past few days. I have a table called MerchTran. Among various columns, the relevant columns for this issue are: FileDate datetime , SourceTable varchar(25) SQL statement: SELECT DISTINCT FileDate , SourceTable FROM MerchTran ORDER BY F...more >>

Hi All, If I have a DTS package file...myPacakge.DTS, how do I import this file to my SQL Server Instance ? Thanks in advance ...more >>

I have a stored procedure to create a table. In my program I want the user to name the table to be created, therefore I pass a parameter to the SP for the table name. I cannot get it to work. It creates a table called "@NewTableName". Any ideas? CREATE PROCEDURE dbo.sp_FFProduction_Crea...more >>

Hi, I wish to use email functionality of sql to send me an email when an insert is performed on a particular table. I know that a proc and may be a trigger is required. Can someone please provide me some hints. Thanks, Guju ...more >>

I'm trying to write a program in cold fusion to check the existance of fields and data types according to requirements I was looking at the syscolumns table for some of this information but I've discovered that in my playing (creating and deleting tables) thre are multiple entries for a fie...more >>

Hello All, Is there a T-SQL equivalent of the PL/SQL cursor rowtype datatype ? Thanks in advance ...more >>

what nchar() value equals the tab character. I need to replace it in a string. ...more >>

Hi newbie question I'm sure I have 2 databases on 2 different machines, there is no connection between the 2. What I need is a way of extracting particular rows from particular tables and adding them to another database. The only viable way of doing this is via email for unimportant reason...more >>

hi group My database name : developer day 1. Taken full backup day 2. taken differential backup day 3. taken differential backup day 4. taken differential backup day 5. taken differential backup day 6. taken differential backup finished backups month 1. after one m...more >>