Hi, The following query has failed to return all the records. SELECT b.Account_desc, b.Account, IIf(a.source_type = 'LY01', a.CSPL_CSPL,0), IIf(a.source_type = 'LY01', a.CSPL_CMS,0), IIf(a.source_type = 'LY01', a.CSPL_CMM,0), IIf(a.source_type = 'LY01', a.CSPL_CMT,0) from Actual_data_fin...more >>

I need to download all data in a table into a text file or an excel spreadsheet. What would be the easiest way to do this ...more >>

Dear Professionals, 1. Could any one explain in a simple word "what Collation play a role in SqlServer" 2. I want the restrict all the user to connect only from SA login .. can't connect through windows authentication.. what I have to do for this ? 3. Which license would be good Per seat ...more >>

My accountant is using Microsoft's Solomon Accounting Software. When she logs out she is getting the error of "unwritten pages". She is just hitting the enter key and everything goes on it's way. Today when she hit enter, she got: Other users are connected to the sql server. - She hit ...more >>

There is a data in the following table Account No. Stat. No. Line. No. 1 4 5 1 2 3 1 6 4 2 5 6 ...more >>

I have three stored proceudres and I want to sum up the result of three sp, can any one give me the optimized query. Exec ALTCmsGetBloodSugar 0,0,1 output :- Alias Count Blood Sugar 150 Exec ALTCmsGetBloodPressure 0,0,1 output :- Alias ...more >>

Hi, The EU is trying to connect to the SQL Server database through EM at her desk and she gets the following error message. "A connection could not be established to [SERVER NAME] - specified driver could not be loaded due to system error 126 (SQL Server). Please verify SQL Server i...more >>

hi, I receive following Warning can any one tell me why this is occurs and how can I eliminate it. Warning: The table 'Part_Tags' has been created but its maximum row size (14647) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the re...more >>

hello all, i am trying to get a returned value from a SP using an out parameter. my code is in C# and i need some help (pls). be greatfull if you send an example of the SP and the C# code that execute it and collect the returning parameter value. thanks a lot, Ran. ...more >>

Hello. I pray to that someone can help me... A month ago a compaq server hosting a SQL Server 2000 Server had a hardware crash. Unfortunatly, the Compaq Smart Array was configured with RAID 0. Aparently the problem was there a long time ago and there was not a recently backup file. So, we...more >>

I just set up a linked server between two SQL Server 2000 boxes. I then tried a query against a view on the linked server, and I get this error: Server: Msg 7341, Level 16, State 2, Line 1 Could not get the current row value of column '[linked_server].[database]. [dbo].[view].[FieldName]' fr...more >>

When Installing a second copy of SQL Server on the same server, is there a danger that our main database could be overwritten? I have had a recent server crash for unknown reason and I am not able to execute any exe files or dll types. My data is still on the server and I have done a par...more >>

Is it necessary or beneficial for the SQL Server and clients to be running the same version of MDAC? Our environment is IIS5 clients on Windows 2000 SP3 and SQL Server 2000 SP3. The client makes a connection to SQL Server using MDAC. The client does not connect to MDAC on the server machine,...more >>

There are two tables Expense Table Amount date 5000 01/01/2004 5000 01/01/2004 100 01/01/2004 Sal Table Amount date 10000 01/01/2004 400 ...more >>

Hi There We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on ...more >>

I've got two developers who will be upsizing an Access database but also making modifications to the resulting tables in SQL Server 2000. This will be our first in house application with an Access frontend. (A little history.) Usually we alias our developers as DBO in the database using sp_ad...more >>

Can the ownership of an existing SQL table be changed from the a user to DBO? How? Sorry but I'm a novice. Randy K wawork@dfw.wa.gov...more >>

I cannot find the Query Design GUI Tool. Where is it located? R...more >>

Our users use a third party app that connects to a SQL database on a windows 2003 member server. The app works if the user has a windows 2003 user account local on the server. 1. All of our user accounts are in a Novell Netware Domain. 2. We have purchased a processor license for t...more >>

Hi, We've got multiple data sources here at work - we have 3 AS400's, 5 MS-SQL boxes, and one MySQL box, as well as several Access db's residing on multiple machines. I would love to see something along the lines of Enterprise Manager, except that it would allow AS400 containers, Access ...more >>

Dear Professional Can any body tell me give me the URL where there is any good explaination step by step about the filegroup backup as well restoration process and all the detail. Thanks Noor ...more >>

Hi, Is there any way to write the Sql table data to a text file thru T-SQL. Pls let me know. thanks in Advance Bhaskar...more >>

Hi, Environment: MS-AccessXP(RT und Dev), Win2k, SQL-Server 2k SP3 in some forms (defined as endless View), get their data from views, i found out some strange behaviour. On slow machines e.g. 300 MHz the form is loaded and all data are shown properly. After 1-2 seconds the data seem to b...more >>

how do I run a file with an .sql extension from the command window in windows 2k server?...more >>

I have a couple Windows 2000 servers SP4, that cannot insert/updated to a SQL 2000 SP3a server on a Windows 2003 server. Windows 2003 server was installed fresh. Upgraded to 2000 to 2003 Windows servers with SQL 2000 SP3a work fine. I have ran MDAC 2.8 on the Windows 2000 SP4 server to see if...more >>

I am using SBS 2003 Premium with SQL Server installed and updated to SP3a. When I connect to the example database in infopath 2003 the "Submit to database" option is there when I insert a submit button. When I created my own database, the option is not there. Any ideas? Thanks...more >>

Hello Can anybody help me I have a query that runs very fast (about 1 second) in Query Analyzer, but runs about 1 minute in ENTERPISE MANAGER and my client application. I have MDAC 2.8 installed on my computer.Processor,memory and disk are not the problem (at least I think so) It is very intere...more >>

Production server installed with - default configuration. Problem: transaction not truncating after log backup. If i stopped the application, its truncating next backup this happening randomley....more >>

We have had to change the hostname on an SQL server (Blade and the blade moved chassis so name changed) was called blade-0-1-5 and is now blade-0-0-12 It seems i need to run 2 stored procedures which are sp_dropserver 'blade-0-1-5', 'droplogins' go sp_addserver 'blade-0-0-12', 'local' g...more >>

Hello, Anyone knews something about the official release of SQL Server 2003 ? I dont know if Microsoft has a trial version for download ,to check it. ...more >>

I'm using Enterprise Manager to connect to the SQL server space on my shared Web hosting server. Because, however, that there are literally about a thousand other databases on the server, each time I connect, I'm forced to wait ten to fifteen minutes while Enterprise Manager polls the server for all...more >>

I have one table named "serving" and I want that against serving ID there should be 42 records not more or less than that, how can I restrict that ? Waiting for your reply Thanks NOOR ...more >>

Can anyone tell me how to setup a client connection to SQL server 2000?...more >>

Hi all! I have a bunch of stored procedures that all return record sets. Now I want the results of these record sets to a file, with a special character to separate the columns. How can I accomplish that? Example: Col1 Col2 ---- ---- Hi all Be nice ....should become... ...more >>

Hi i use a program that use SQL 2000 server, by any days for three pc i receive the follow message when i try to open my programm or i try to create new odbc: connection failed sqlstate "HYT00" sql server error: 0 Timeout expired i have many pc on my network and don't undestand why only th...more >>

I have been trying to register a SQL server in my server group in Enterprise Manager but it cannot find the server. The SQL server (SQLServer2k) resides on a server machine running WinServer2K. I am trying to gain access from a remote PC running Win2k. I am able to see the server in the...more >>

using johnogorman@netscape.net ACCT ...more >>

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/ firewall to connect the two computers and I'm getting the following error: Unable to connec to server SERVERNAME Server: Msg 17, Level 16,...more >>

Hi together Why my SQL table in a SQL 2000 database (on a phisical Windows Server 2003) can only be read, but not written from my Desktop-Client with Access 2003? The specific domain-user, which tries to access this table in write-mode is in the usergroup, which was switched to "db-owner". O...more >>