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 >>