here's the scenario.. I am running a DTS to collect the summarized info from Oracle database into SQL server. I then have a update job which updates my transactional table from the summarized table. The update takes a very long time (~ 3 minutes)even though it has around 1500 rows which cau...more >>

I have a column [id] in a table [products] The first 1, 2 or 3 alphabetic characters of [id] gives the category of the [id] example: ms123 --> category MS f-2345 --> category F rs2-123454 --> category RS erv-2345 --> category ERV Can someone help me with a sql-statement that gives the di...more >>

Not sure if this is the right group to post this to but. This is the current query that I have. select tableA.id,tableB.artist,tableB.image,from tableA,tableB where tableA.image = tableB.image AND tableB.price >0 AND tableB.price < 20 order by tableB.price DESC' What I need is, for each...more >>

Hi All, We have SQL Server 2000 (sp3), running on Win2k Server. Yesterday, mid morning, during normal processing (selecting data .. loading data .. etc) the sql server service suddenly shut down and would not start again. We received several messages but the 2 most consistent messages were ...more >>

Hi, Where can I learn more about new Microsoft SQL Server? Is there any free e-book or some pdf file? Thanks ...more >>

This seems so easy....change the join to show all records, but the zero records still do not show I want to join 2 tables....basically Customers and Orders....get the total number of orders for each Customer within a date range...but I can't seem to show records where the total for a particula...more >>

I want to run and 'Alter Database' statement from within a batch file. The batch file is to be run from an external automation program, (don't ask why).. I know the syntax for the alter db statement but not sure how to do it in a batch file and also If I have 2 instances how do I run it against ...more >>

A newby question: I've got a .dmp from from an Oracle database that I need to import into SQL Server. I have no idea how to do this. If anyone know how to do this, I'd very, very much appreciate the help. Thanks, CC...more >>

If I detach a database on a server, then attach the database with a single file only using the data file...will I lose any transactions that were in the original log file? There is a debate going on here at work where some people think that during the detach, transactions in the log file are sav...more >>

I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using a TCP/IP client connection. I get this error when attempting to restore a database. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()). [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network ...more >>

Hi All I'm trying to find a math function (if it exists) in SQL Server. If it doesnt exist, then maybe someone can tell me what its called so I can do a bit more reading on it Basically I want to do this: Parameter Components 1 1 2 2 3 1, 2 4 4 5 ...more >>

Hi, I have a table with about 70k rows. When I use open table --> return all rows and then edit a field Enterprise Manager then says it has to return the entire result set for the update to take place. This can take a long time and makes editing data a slow process. Is there any way to get ...more >>

Hi, A long time ago I set up a database with *very* descriptive and therefore long table names. :( I did the same with the column names. :(( The column names even repeat the table name. :((( This was done in a period in which I was still using a lot of dynamic sql :(((( and sql in the code o...more >>

Hiya, I want to populate a list view (in a variety of ways), but I would rather not execute my function once for every record I want to show in the list. What I want to do is pass an array of "keys" into a stored procedure and have that procedure return one recordset with all of the recor...more >>

Hi All, I am new to Sql and I want to know if a given value lets say its 225 is within ranges defined in the table. I have a table TblControl. Data type of both field is int. StartRange End Range 0 100 200 300 500 600 900 950 (Sql server 2000 ...more >>

I am about to buy some database hardware, and am considering buying a dual 64-bit opteron server. In the past, we have run been running the 32-bit version of SQL Server 2000. Has anybody tried the new 64-bit version of Sql Server 2000? Can we assume that something that works in the 32-bit wo...more >>

I'm trying to create a temp table in the stored procedure. the syntex is the following: create st_proc variables declared if something >0 create temp table #Table1 if something <0 create temp table #Table1 SQL Compiler complains about the second create. thanks...more >>

Hi, We have a heavily used production server and a table which logs every hit on a web site. This table has grown large over time and we want to clear it down as efficiently as possible. We would like to issue a truncate table statement, but with millions of rows we are a bit wary of how this w...more >>

Hello I'm desperate for help with the following dynamic SQL. It used to work for ages but suddenly stopped working today! I can't recall changing anything of importance.. So I say. Anyway, I'm getting this error: "Cannot use empty object or column names. Use a single space if necessary." I'v...more >>

i am a beginner of database design, could anyone please help me to figure out how to make these two tables work. 1) a "players" table, with columns "name", "age" 2) a "teams" table, which can have one OR two player(s) a team also has a column "level", which may have values "A", "B", or "C"...more >>

Hi, Here is my original query: select rosterid, lastname, firstname from table order by lastname I would like to use column aliasing to display lastname, firstname in a column entitled name. I tried the following syntax, but it's not working: select rosterid, lastname+', '+fir...more >>

Hello, A utility I was running caused our database's log file to run out of hard drive. So, I detached the database, deleted the log file, and tried to reattach. SQL server fails to reattach because it cant find the log file. (Why it cant just create a new default one is beyond me...bu...more >>

Hi! I have an select on a view that takes too much time. The view include joins. I tried index-analysis and explain-plan, but this don't help. But it helped when making a real table (select * into realtable from bigview) and afterwards making my select on realtable...? Suggestions? Where t...more >>

I have a query below that returns a table with some client information along with the last project manager that met with them and the date they met. Nothing is included in the table if there are no meetings for that client. Is there a way that I can still have the client information included e...more >>

Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to move to DR location. The relocation kept the same virtual and phusical server name, and we did no...more >>

Hello, On our corporate website, we will be using email notifications for various things. I would like for our marketing guy to be able to edit the email templates over the web so that I don't have to keep updating them myself for every little change. I want to store the templates within the da...more >>

Hi, Everytime a job starts it puts logging into the system (application) logging files. (Messages) How can I prevent SQL from doing that. Arno de Jong, The Netherlands. ...more >>

What does the CIO need to know about Sequel Server administration?...more >>

Is there a way to sort records the following way. Original Table: KeyField Column 1 1 0 2 500 3 200 4 300 5 0 To this sorted table KeyField Column 1 ...more >>

Is there ANY data type other than varchar that is valid for local variables and allows more than 8000 characters?...more >>

Does anyone have any good references they could recommend on Cursor based SQL writing? I have to create SQL that can loop though records simular to VB loops and I have been told that this is the way to go. Any recommendations would be helpful....more >>

I have two avenues to access my primary SQL Server. (I work remotely using a VPN connection.) Usually, I hit the server from my local machine but I also login to a desktop machine inside the main building using a terminal ap and hit the server from that desktop. Anyway, when I import files ...more >>

I have two tables populated during the use of an application to log user events and application states. They are named "EventTable" and "StateTable" and the structures follow: EventTable: ID EventTimeStep EventID -- ------------- --------- 1 5 E1 2 22 E2 3 ...more >>

Hi, I have a table as following aa Text1 aa, p@xxx.be, 15267 aa Text1 aa, p@xxx.be, 16598 aa Text1 aa, p@xxx.be, 17568 aa Text2 aa, p@xxx.be, 25698 aa Text3 aa, x@zzz.be, 12258 I have to write a query as follows ... SELECT DISTINCT TOP 500 fldText, fldContact, fldItemid FROM table ...more >>

Hello all, I am new to sql and have some Access experience. In sql, how do I: compare 2 identical tables, (except for data); then update table 1 with new data from table 2 TIA Jake ...more >>

What is the best way to grant a user permission to create a view? I first created a role using enterprise manager but for the role I created it doesn't seem to offer that permission. It offers the basic stuff such as insert, select, and update. I could go in and use a grant create view sql ...more >>

Hi All The problem:!! I want to create a temp table which is common between different users so that each user could select his rows and print them without printing others selection. All clients use the same connection string. Is there a way to identify users? I think it's possible to delete r...more >>

Below is a code snippet that is throwing the following error: Error Source: Microsoft DTS Package Error Description: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Object required: 'Server' Error on line 13 In my code line 13 is the following: Set Cnxn...more >>

I'm in the process of migrating a lot of data (millions of rows, 4GB+ of data) from an older SQL Server 7.0 database to a new SQL Server 2000 machine. Time is not of the essence; my main concern during the migration is that when I copy in the new data, the new database isn't paralyzed by the ...more >>

Hi, Can anybody tell me if it is possible to return a table data type (as opposed to a temporary table) from a stored procedure. I am currently studying for 70-229 using the Thomas Moore book but it doesn't really make it clear, as the text suggests you can't return them but some of his sam...more >>

Hi. I had a VB program that was using an SQL Server 6.5 DB. Date format was dd/mm/yyyy. Now the DB was changed to an SQL Server 7 and the date format is yyyy/mm/dd. How can I do for changing date formats in the new DB to the old format? I´m searching for a database level solution, not se...more >>

Can MSDE be used on computer in different cities? Say the server in Dallas and the client computer in Houston. Or is the full SQL Server required? ...more >>

(MSSQL2000) I have read the transaction/locking sections in the MS-help, online and several books. What I want to understand is the transaction behavior in single statements [not a BEGIN TRANSACTION Statement1, Statement2... COMMIT]. If I have a Table: "Letters" with 1 column "L" and the tabl...more >>

Does anyone know how I can password protect XP Professional Control Panel? Thanks Ronnie ...more >>

I am having the following problem and any help would be GREATLY appreciated: In an application I am developing, at some points we create a new table. When I create this table on another users box, I can not access it from my box. In sql server I am dbo, but the table created by my application...more >>

I have a system configured with Windows 2000 and SQL Server 2000 Clustering (active/passive). Both SQL Servers have a local E:\ drive with the same directory structure. I would like to move the tempdb off of the shared SAN and on to the E:\ drive. I don't foresee any issues with this but want...more >>

Hi, In the process of localizing the 'regions' table, we added three new tables. The localized data will be stored in the TokenKeys and TokenValues tables. It would be easier if we did away with the TokeyKeys/TokenValues tables and just added a localeid in the regions table, but this is the ...more >>

how to show all tables in current database ?...more >>

In Excel VBA, I've established an ODBC connection to a SQLServer db, and I can do a successful SELECT query, but I'm having trouble doing an UPDATE query. When I run the following code, I get the error, "Cannot Execute a Select query." Dim dbsCurrent As Database Dim qdfChange As Qu...more >>

I'm working on an ASP Web application, and am having syntax issues in a WHERE statement I'm trying to write that uses the CInt Function on a field. Basically, I want to select records using criteria of Race, Gender and Crime Code. But the Crime Code field in the table is text, and I cannot ch...more >>

Hi, Currently we have logshipping setup with one production db server sending the logs to one standby database server. we would like to have setup where there will be two standby db servers. Second server will be located in different country. Kindly let me know if we can have the setup where ...more >>

I have a column called SEGMENTED_BLOCK sample data: X,X,X XX,XX,XX, TYZC123456,X,X, TOYZ654321,1234,777777 I need to do something that has the effect of SELECT (stuff before first comma) as FIRST_ITEM, (stuff after first comma, but before second) as NEXT_ITEM, (stuff after second ...more >>

Hi, In case of failover to standby server, what is theest way to redirect client applications to new server? 1) DNS name change -- not viable due to Caching issue. IS there any alternate like Oracle's onames/LDAP for resolving name with sql server? Can use Sever alias? Thanks...more >>

Hello all, I know this may be a basic question, and that the short answer is probably "Yes"; but the File menu on the Computer Management console doesn't have an Add or Remove Snap In choice. When I run MMC (from the run command), I get a new/blank console, the Add or Remove Snap In choice i...more >>