Hi, I am trying to export rows from SQL2005 linked to coresponding rows from Oracle to an Excel spreadsheet using SQL Server 2005 Integration Services (DTS as it was) I really am not sure what I ought to be attempting to do, however I seem to be able to create two OLE DB source 'objects' a...more >>

I have data coming from a telephony system that keeps track of when an employee makes a phone call to conduct a survey and which project number is being billed for the time the employee spends on that phone call in a MS SQL Server 2000 database (which I don't own). The data is being returne...more >>

Hello, I am using SQL Server 2000 with SP4. I have a database with two full backups at 4:00 PM and 5:00 PM and a transactional log backup at 5:30 PM. Is there a possible way to do a point in time restore to 4:30 PM, that is between two full backups? When I try to use the transactional log b...more >>

I need to be able to drop a table after a user is done with it. I have tried something like, DROP TABLE USER.tblEducation_SAP1 but I get an error. Can someone suggest the way I should be using the USER value in this instance? Thanks! ...more >>

Hi there. I'm on a SQL 2000 SP4 machine. This is a development machine, with only a couple of small databases on it. Yesterday I needed to recover a table from backup, so I went through the following process: -Used 'Create SQL script' to generate a create db statement from the current...more >>

Running SQL Server 2000. I have been asked to move the transaction logs to another drive. I was able to do that for the user databases using detach/attach. However I don't see that as an option for moving the logs for the system databases. Is there any way I can move the system database logs?...more >>

Hey, First, sorry if this post appear twice, because, I can not find my post recently send, trying to post it once again. I'm out of ideas, so, I thought, will search help here again :( I'm trying to prepare a view for ext. app. This is in normal cases very easy, but what if the view struct...more >>

Hi, I'm coming back to Sql Server after 4 years away, using other RDBMS, and there's a few things I'm struggling to remember how to do (if I could do them in the first place...) Main amongst those is EXCEPT syntax. In DB2, if I have two sets of data and I want to exclude the second set f...more >>

Hi, Is there a way to findout the query plan of the executing process using the SPID/KPID information. Thanks in advance, Thyagu.D ...more >>

I have a requirement in SQL 2005 in Development database 1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) . 2. Only DBA's ( who are database owners ) can create, alter tables . Developer's should not create or alter tables . 3. Developers can create/alter Stored Procedure/User Defin...more >>

Hello, I'm not very familiar to SQL Server, but I've to upgrade a DBMS from V6.5 to V2005. >From the V6.5 I've got a backup file and a dump file (which seems to be the same, at least it has the same size). After installing V2005 - at another system - I could not find any option to import...more >>

hi,All could you tell me which case is more efficiency?(my tables have no index) And does it has any else case more efficiency? case1: "select sum(Invoice_Production.Quantity) from Invoice_Production,(select [dat_Item].ItemCode from [dat_Item],(select [dat_MachineType].MachineTypeID fr...more >>

I want to select one field from a table,but it should on some conditions which refer to 5 table ,such as A.FILED1=B.FIELD1 AND B.FIELD2=C.FIELD3 AND .... Should I use case "select sum(a.amount) from a,b,c,... where a.field1=b.field1 and b.field2=c.field2 and ..." or "select sum(a.amount) fr...more >>

I have the following cursor that I am comparing 2 tables, the production table and a copy of the production table, I want results of all address's that are like the address1 field...the problem is...my results are giving me every field and if there is more than one, it is putting it in a grid......more >>

Hi! This is my table: CREATE TABLE [Query_Result] ( sifrob VARCHAR(13), katbroj VARCHAR(15), kol FLOAT ) This is some values: INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol]) VALUES ('49501879', 'G-46052', 1) INSERT ...more >>

new to SQL Server 2000. We have an obsolete database that we need to save off for x number of years. DB2 has utilities (DB2Look/Export) that allows for the export of the data along with a schema and script that enables the future recreation of the structure of the databases and tables to includ...more >>

I'm looking at an MS SQL server database and it stores city names across the world. All a arabic , chinese etc names are converted to the latin alphabet. I feel it is probably critical we support accents as a means to distinguish between cities that would be converted to the same Latin alphab...more >>

When I want to delete a data from a table that this tabl has a trigger and this trigger reached another tables to delete the data in cursor I have this messeage: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. My trigger : CREATE TRIGGER [TOPBA...more >>

Hi All, I was able to connect to MS SQL Server 2005 on my computer but after a while I can not. When I want to connect to it using MS SQL Server Management Studio I got this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this ...more >>

Can not open mssql .bak file in ms_sql. File starts with "ti" and some weired charctor. Can some one help me on how to open this back up of mssql database. I've tried to restore this file in mssql and it says it does not recognize this file. I understand that .bak file for mssql should start wit...more >>

Hi, I have the following query: SELECT dbo._Fault.id, dbo._Fault.date_created, dbo._Fault.reference, dbo._Fault.class, dbo._Fault.owner, dbo._Fault.Contact_Name, dbo._Fault. Product, dbo._Fault.Problem_Description, dbo._Fault.Action_Taken, dbo._Fault.Problem_So...more >>

Hi everybody My problem with sql server is the following one: I've got my backoffice manager application done with asp technology that works on sql server installed on Win2000 and running on IIS5. what I've done is simply doing a backup of my db and moving the asp application on another server:...more >>

Hi, See this code: DECLARE @SQL nvarchar(4000) SELECT @SQL =3D 'SELECT * FROM CUSTOMER WHERE CustomerName =3D N''Tr=E1=BA= =A7n T=E1=BA=A5n H=E1=BA=ADn''' PRINT @SQL The result always is this: SELECT * FROM CUSTOMER WHERE CustomerName =3D N'Tr?n T?n H?n' ...more >>

Hello, I have a stored procedure that processes an individual file from a directory and archives it in a subdirectory.Now, the problem is, when i execute it , it will only process one file. What i want to do is to check to see if there are any files in the folder, and if there are , process...more >>

I have a table with entries tied to a membership database. The problem is that I want to select a limit of sixteen entries per member, per day, where some members have 16+ entries per day. I have this so far ( which I've simplified for this post) SELECT dbo.members.firstname, dbo.members...more >>

Hi, Can anyone help please? select notefield, modifiedon FROM Table1 WHERE id = '100426' and (statusfield like '%criteria1%' OR statusfield like '%criteria2%') Produces a list of records based upon the criteria. I would like to be able to only show the newest dated record, from the mo...more >>

hai, I have using sql2000 server i met one problem in upadate query. My table name is reserve sno. cmname allocated 451 raja no 555 kumar yes 338 prabu no 224 mari no 993 arun no 330 makesh yes This...more >>

What is the difference please?...more >>

Hi All, I have two tables, one is about member infomations, the other is the catergories member_info(id,name,email,phone) member_categories(id,category) how can create a view like this (id, name, category1, category2, category3) with high performance? Thanks in advance. Joshua ...more >>

Hello, I'm new to SQL Server, working for a non-profit computerizing a lot of its data. I imported a table of people's names, birth dates, etc. into SS2005 from Access, and the birth_date was imported as an Access date/time field, giving it the datetime datatype in SQL. The column values lo...more >>

The table in the database has a field called LabID. That field is an integer and consists of the year plus a counter. For example, the first record of 2006 would be "20060001," the second record of 2006 would be "20060002" and so on. I'm trying to create an Insert trigger that can generate th...more >>

If anyone is able to provide advice for tuning the below query in sql server, it is much appreciated. In addition any index suggestions are also appreciated as I have access to the tables. Thank you. select a.id, isnull(b.advisement_satisfaction_yes, 0) as advisement_satisfaction_yes, isnull(...more >>

I have a stored procedure that will execute with less than 1,000 reads one time (with a specified set of parameters), then with a different set of parameters the procedure executes with close to 500,000 reads (according to Profiler). In comparing the execution plans, they are the same, except ...more >>