SELECT Parts.SKU, Locations.Description, Manufacturer.Name, PartsLocations.Qty, PartsLocations.LastInventoried FROM Parts INNER JOINT Manufacturer ON Parts.ManufacturerID= Manufacturer.ManufacturerID INNER JOINT Locations ON Parts.LocationID= Loactions.LocationID ...more >>

As an extension to the SELECT TOP n ... function, is there a way to select records between a range, ie. SELECT TOP 5 TO 15 ...? Thanks for any help, Chris. ...more >>

How I know the current database name in which currently I am standing... any system level funtions Thanks Noor ...more >>

I have created one database named test on DServ Server and in that database I have created three fileGroup named Primary, BaseFileGroup, TransactionFilegroup and after that I took the backup of that all filegroup and restore it into another server. (OServ). After a week I took only the backup of...more >>

I have created the Following view but gave me an error while decrypting the View.. CREATE VIEW MyTopCities WITH ENCRYPTION AS SELECT DISTINCT TOP 10 PERCENT ShipCity, ShipRegion FROM Orders ORDER BY ShipCity EXEC dbo.DECRYPT2K MyTopCities,'V' Server: Msg 2812, Level ...more >>

I am using the following command but it gave me an error dbcc checktable ('testing') with REPAIR_REBUILD Server: Msg 195, Level 15, State 4, Line 1 'REPAIR_REBUILD' is not a recognized option. Thanks Noor ...more >>

I upgraded my SQL Server to 2000. My clients were all running SQL 7 to connect to the database. It was slow, so I upgraded my computer to SQL2000 to test. Now I can't get connected to the database AND my clients can't connect either....more >>

I have a following table : CREATE TABLE [dbo].[defaultvalue] ( [id] [int] IDENTITY (1, 1) NOT NULL , [flag] AS ([id] + 1) ) ON [PRIMARY] GO I want to insert the data in it, how can I insert ? Thanks NOOR ...more >>

Hi Is possible from a "win form" application to create an alias like the "SQL client network utility" does. TIA ...more >>

MSDE is throttled for 8 concurrent operations. As ASP.net is designed around disconnected recordsets, I'm wondering how busy a site using ASP.net would have to get before the workload governor starts to have a noticeable effect. Anyone have any experience of this or guidelines? Martin Harran...more >>

Hey all, Fairly new to the SQL scene, I am trying to access my db remotely. Any free apps that you can recommend? Thanks, ...more >>

Can any body tell me that Can I know the number of drives in system as well as the used and free spaces of that harddrive through xp_cmdshell Thanks Noor ...more >>

Can any body tell me about the different between query and Ad hoc query... when we use this term ad hoc queries. Thanks Noor ...more >>

Here is the data ID Date Name 1 '01-01-2001' Noor 2 '01-04-2001' ali 3 '01-03-2001' Farhan 4 '01-05-2001' iqbal 5 '01-06-2001' Urooj I want the top 3 descending order records data wise like I want the data like this ID D...more >>

Hi All, I've a problem that requires a fairly lengthy introduction by me. If you've the time and the willpower I'd really appreciate your help. I'm running a application based on Access 2000 and SQL Server 2000. The system is designed to allocate a single record to a callcentre agent bas...more >>

How critical is it that SP3a get applied to client workstations? What are the ramifications of applying SP3a only to the servers? Thank you...more >>

Hi, i have this Access database with data entry forms. Now i want to move the data to SQL server and keep the entry system in Access. I tried to create a Access project which is linked with SQL server. the access project is just like a local application, i could make any changes on data and ...more >>

I am trying to do a select like this: select * from mytable where id = 2 for xml auto How can I capture the result in a Varchar or Text variable or immediately insert it in to a table ? ...more >>

I recently purchased sql 2000. I need connectivity for an old DOS program. I see that I need the file DBNMPIPE.EXE I can't find this file anywhere on my CD's or on Microsofts website. Where can I get it?...more >>

If you use MS Access to update data in SQL Server i guess you can choose between two methods to connect to a SQL Server databasem, create an access database with a linked table via ODBC or create an access projekt via OLE DB. Both methods gives me problem: Linked Table: When my tables get ...more >>

Hi, How I can restore MASTER database on another SQL server? If I want to resote got msg "restore can be done only from single user mode" - what should I do......more >>

Hi all, I want to populate full text index via query is there any way? please elaborate Thanx Farhan Iqbal ...more >>

Just curious if there's anything in SQL comparable to a FOR EACH ROW trigger in Oracle. I'm doing an import of a bunch of rows into a parent table using an INSERT/SELECT statement and I have triggers that fire pulling data from the same row in the source table into the child tables and creating t...more >>

Hi All, I would like to submit a large amount of CSV text into a = stored procedure. At present I'm using a varchar(8000) parameter and = then converting this into a temporary table using something like the sql = below. My question is does anybody have any suggestions on how to g...more >>

I am running SQL 2000 and Crystal Reports ASP. I have two tables called customer and invoice. There are 100000 customers and 7200000 invoices. Here are the fields: customer - id ...1 to 100000 - custno ...1 to 100000 - name - address1 - address2 - postcode ...more >>

I am passing the following query: select type, count(*) as 'Total', sum(case when status = 'Closed' then 1 else 0 end) as 'Closed', sum(case when status = 'Pending' then 1 else 0 end) as 'Pending', sum(case when status = 'Escalated' then 1 else 0 end) as 'Escalated' from ticket where l...more >>

What is the best and quickest way to develop, or download, an interface that clients can use to query sql? Thanks, CJ ...more >>

I have recently moved from developing an Access DB to developing an Access.adp using SQL Server2000. I havent been able to figure out how to pass a parameter from a control in an Access form to a Stored procedure. It was easy in Access but I just dont get it in Access/SQL stored procedure....more >>

I have a database created by another developer that I purchased and was recently instructed to change some values in some tables form one kind to another like "NOT NULL" to "NULL" or change something to a "FLOAT" I am not that good at SQL but have always done this stuff with the Query Anylizer.....more >>

Hi, I can't connect using an OLE DB connection string to SQL2K Server (SP3) running on a Windows2003 Server, but using the same connection string (with the address changed of course), I can connect to SQL2K Server (SP3) running on Windows2000 Server. I figure it must be a security issue on ...more >>

Anyone have a working example of a LDAP: call from SQL through OLE data access call? ...more >>

In oracle we use Prompt like in the run time it prompt to give input like insert into test (id, name) values (&id&, &name&) How can I fulfill this in SqlServer ? Thanks Noor ...more >>

I need help removing a ' from a field...more >>

I have a table in SQL Server that sometimes cant be updated because the table is in "Firehose Mode". There is an article (KB237398) about this and the solution is to list all rows with enterprise manager and that helps. Thge problem is that the table continously get into firehose mode. We ...more >>

Hi all Now a day I am facing too-many deadlock problems, is there any way or possibility that I make automated job, for diagnose the deadlock victim and kill that process. Any advice will be greatly appreciated. Farhan Iqbal ...more >>

I want to ask one question regarding optimization point of view like I have one table named ExerciseDetail and when any updation perform from the front end so first we delete all the records in Exercise detail against specific Exercise Plan ID and then again insert all the records so can any bo...more >>

What do you do when you are doing a search of a SQL database through Database Results Wizard and an asp page and the error comes back Database Results Erro The operation failed. If this continues, please contact your server administrator Nothing in the event viewer on either the web server ...more >>

Often, EM running on my desktop will cause all other windows either to refresh very slowly or not at all. (I may get a border with some of the display) I can't navigate to any window completely until I shut down EM. SQL 2000 running on Win2k. Thanks....more >>

This is the message that I get; "The setup routines for the SQL Server (32 bit) ODBC driver could not be loaded. You may be low on memory and need quit a few applications." Running Win XP Pro SP1. PC has 256 MB of RAM. Pagefile is set to a maximum size of 1500 MB. Why do I get this ...more >>

I have received the following error in the logshopping=20 3041 : BACKUP failed to complete the command BACKUP LOG [LMS] TO DISK =3D = N'D:\Program Files\Microsoft SQL = Server\MSSQL$XORBIX\BACKUP\LMS_tlog_200406081859.TRN' WITH INIT , = NOUNLOAD , NOSKIP , STATS =3D 10, NOFORMAT=20 Thank...more >>

can any body give me any good URL from where I can buildup the good understanding of Log Shipping with practicle example Thanks Noor ...more >>

Sql Windows/32 ActiveX error ActiveX object creation failed-please check that your installation is valid. How can i fix this error? The user can execute the command on other machines except his own. Is there something Im missing? ...more >>

Dear Professional Can any body tell me that IsLogshipping auto restore the database or we have to do it manually ? Thanks NOOR ...more >>

I have been using Enterprise manager and I am trying a simple query and keep getting an error that my syntax is incorect. As I recall I have done this before. Query is ALTER TABLE ProdAddons ALTER COLUMN ProdMult NULL GO The server does not like the workd NULL the column is currently NOT NULL ...more >>

I have an SQL database which sits on a Win 2000 server and is accessed by various clients (Win 98, xp, 2000, NT) This server has crashed (beyond recovery for the time) and I have loaded SQL Server Clinet Tools and MSDE on to a Win XP Pro machine. I am trying now to connect from the Win 98 client m...more >>

SQL2K backend Access 97 MDB frontend. I have a ComboBox whose Recordsource is a SQL Passthrough Query. One of the returned fields is a Boolean value - bit field in SQL Server. But I want it to display in the Access combo box as either Yes or No. Currently Access displays 0 or -1. Fine for me, but...more >>

I am having some general problems in EM. 1. When trying to open a table I get an error message saying: "Unknown error: 8007007E" 2. When trying to open a DTA package in DTS Designer I get an error message saying: "The specified module could not be found". Any ideas would be greatly we...more >>

Above message comes up attempting to contact the MSDE server. What does this mean ??...more >>

Can any body tell me about time out error. I am facing timeout error from my application result.asp page and when I saw the message in the event viewer so it gave me the following error. nitconfig: Error 32(The process cannot access the file because it is being used by another process.) openin...more >>

Yesterday my sql server was running properly but after reinstalling primary domain controller I failed to login like when I login through windows authentication so it gave an error that login failed and if I log through sa password then it gave login failed for default database. Can any body g...more >>