This is general scanario and I want some feedback from you guys. I am planning to add new indexes, drop some indexes, and change other indexes to composite and covering indexes. I want to create report that shows the indexes used by queries before and after I make changes. What should I do? ...more >>

Perhaps a stupid question, but I recently discovered a "new SQL-server" on my PC. What is it for and what can I use it for??? Greetz, Els ...more >>

How do I disconnect a particular session without having to stop and restart the server? I read the article on the DISCONNECT statement in BOL but it takes as an argument a name, not a connection number. How do I know the 'name' of the connection? Is there a system stored proc that will do this, ...more >>

How can I specify the format in check constraint while creating a table like SSN format should be :- 000-00-0000 Thanks NOOR ...more >>

Is it possible to directly access a sql server 2000 (NO CE) database with my pocket pc?...more >>

Can any tell about the global cursor ? Thanks NOOR ...more >>

RAISERROR ('Error %d occurred updating Stock %d.', 10, 1, @@ERROR, @StockID) WITH LOG Can any one explain me about the above query like what WITH LOG do ? Thanks NOOR ...more >>

Hi, We have SQL Server 2000 Enterprise edition with SP3a and the latest patch on WIN2K OS with SP4. The database residing on the server is used 24/7, 365 days and lot of data manipulation happens on it daily. We have scheduled a job to rebuild indexes using Database Maintenance Plan W...more >>

I have been asked to move an access DB (DB1) to a SQL backend. I have accomplished this using the upsize wizard. I now have 2 tables in the DB1; Xref_Local and XRef (The newly upsized table). My problem arises when I try to use a different database (DB2) that has a table that links to...more >>

Hi Folks, I'm doing a SQL Server 7 to 2000 upgrade soon. What client-side issues should I be concerned about, e.g. MDAC, etc. I'll have access to the client PCs for a MDAC upgrade if necessary but I won't have access to the client apps source as they were developed externally in VB 6 approx ...more >>

I asked this question in several forums and could not get a good answer. What would be the best data access client for SQL Server 2005 that support most of the features provided by the server? The Books Online contain this statement: "SQL Native Client (OLEDB) is a low-level, COM API that is...more >>

Can any body explain about the Optimistic and Pessimistic Concurrency with practically good example. Thanks Noor ...more >>

hi all, mine is a finanicail project.in most of tables for dealing cash i am using money datatype.my problem is i am getting the data from user as 120.3214$ but i want to store it as 120.32$ only.the money datatype by default taking precision 4 only.if any idea please help thanks reddy ...more >>

Can any one explain me this "Option [hash join]".... what that Option [hash join] will effect in this query. select * from [group] inner join patientgroup on PA_PatientID = PG_PatientID Option [hash join] Thanks Noor ...more >>

You are a database developer for your company's SQL Server 2000 database. You update several stored procedures in the database that create new end-of-month reports for the sales department. The stored procedures contain complex queries that retrieve data from three or more tables. All tables in ...more >>

Hi, I'm trying field names from a table fields (stored as text), and then use the returned field name text in another query: SELECT table1.a, table1.b, table1.c FROM table1 WHERE ( (SELECT f1 from table2) = (SELECT f2 from table2) ) ; f1 in table2 = "table99.f3" f2 in table2...more >>

Hi, I have just imported my old access database into my new SQL database and have come over a few problems. All memo fields have been changed to "ntext" fields. This is no good for me as I have lots of text in the fields. When I try and change one of the fileds I get this error: 'creek_pr...more >>

Can any body explain me about the WITH CHECK OPTION and also give me some good example for that.. Thanks NOOR ...more >>

Hi, We are extending an existing sales application. Unfortunately the current deployed system's source code is not available and we have to make extension as a separate application which will update the backend database. The problem is the sales application runs on multiple clients. We w...more >>

Dear Guys. Can you guys help me regarding Database Server Clustering and Database server federation Thanks NOOR ...more >>

what is the best way to move data tables back and forth from a PDA using CE and a PC with SQL server 2k? thanks, mcnewsxp ...more >>

Hi, Im importing data from a file, and saving it into a table, nothing complex. The file contains fixed length fields, and the table is integers ( default NULL ). When a value in the file is NULL, it is simply a series of spaces indicating no value. When EM parses the spaces, instead of...more >>

Hi, I was wondering how, if possible you are able to access 2 databases on 2 different sql servers (7, 2000) concurrently? ...more >>

Dear professional In the stored procedure how can I make a single parameter as a Input and Output both ? Thanks NOOR ...more >>

Hi. I use a SQL file to create my tables. I would like to add field descriptions to each field, but cannot figure the format: CREATE TABLE t_012( field1 nvarchar(22) default NULL description='my desc goes here', field 2 integer default NULL ); Could someone please tell me the cor...more >>

whats the best method for deploying an sql application to a large number of clients what stages are required and how do you go about it...more >>

Very new to this so please be patient. I am thinking of using SQL as an application that will be accessed by 300+ users 24/7 and wanted to know what I would have to do for the clients. Do you have to install any client software, front end software and what is the best way to roll it out ...more >>

I'm looking for the quiet or unattended switches for the SQL2000 MS03-031 patch. Or maybe an unattended template file I can throw at the package. Can anyone assist?...more >>

Can any body explain about the concept of "Top 10 with Ties" .. Thanks Noor ...more >>

Connection failed: SQL State: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access den...more >>

Hi Does anyone know what are the changes maded to SQL Server Client tools in SQL SP3. DB Kid ...more >>

Hi, I was not sure what the best newsgroup was for this question. If the customer is running SQL server 2000 on a Windows box and his clients are Linux-based (maybe using some Open source ODBC libraries), do they need to buy Client-Access- Licenses (CALs) for each Linux node? Thank...more >>

hi all, i am using temporary tables in most of the procedures.to boost the performance i added primary keys and indexes to the temp table.for example CREATE TABLE #BillingUpdate ( PatientID INT PRIMARY KEY CLUSTERED, DOS DATETIME ) i thought it will boost the performance of the procedure.now...more >>

Hi all, Desperately hoping you can help, we run pentagon2000 on an SQL Server, which runs fine on W2K PC's, but on XP Workstations, when the Pentagon 2000 Software data is being added or modified from a station, and it sends the data to the SQL Server the status states in Task manager a...more >>

I need people's expertise on this. I'm currently at a crossroad with my Access XP dbs. We're planning on moving our access tables to SQL 2k. My boss wants me to look into options for the Front End. The dbs are mission critical (worked on 24/7) and would like to be more flexible in the ...more >>

I am trying to update a related table with a subquery. This is what I am using - update table1 set col1=col1+1 where ID in (select ID from table2 where status="Active'); But I get syntax error. I am not much of a database guy, so can't understand what am I doing incorrectly. Can someone h...more >>

The definition of a view queries 51 fields from 13 tables with nearly 10 joins(left, right and inner joins). This view is called by a third app that runs a select on the view but calls only 22 fields out of the total 51. Would it not be better to create a new separate query on 22 fields...more >>

I wanna know when the last back took and when last restoration took place of any database, how can I ? thanks NOOR ...more >>

Hi, never posted anything with "very urgent" in the subject but this time I'm having a serious problem. I've got a customer which called me to tell me that his sql server doesn't start. I had a look and decided to reinstalled the server and it works fine now. The problem has been somewhere in ...more >>

Hello all! I have installed SQL Server 7 Client components on a Windows 2000 Professional machine. I can start the Query analyzer and I can use it to connect to servers. However, when I try to start SQL trace, I am getting the following error message "sqltrace.exe, not a valid win32 ap...more >>

I have moved a database onto a new server. I have several queries that now seem to run forever and return no results. The queries are made up of 30 odd select statements joined with union all. If I run the selects individually they all run OK, ranging from 6 secs to 50 secs. I can run 10 or 15...more >>

Is it possible to use a SQL Server stored procedure as a datasource for MS Word mail merge? If yes then how? ...more >>

I have a query, written as a stored procedure, that takes one parameter and returns about 20 rows. When I run this from an Access project the results appear almost instantly, but when I run it from an ASP page it takes about 20 seconds. As a further check, I wrote a Delphi program to run the sam...more >>

I had a user that received an ODBC MS SQL SERVER timeout error. In my search to fix this I discover that if I went int cliconfg and created an alias to the server and place the port 1433 in the required field that she no longer rec'd the error and could access the data. I am glad this...more >>

Can any one explain this.. Enable the 'Allow database to assume primary role' Thanks NOOR ...more >>

You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform database maintenance tasks. You create a data transformation services package to populate the data warehouse. MAPI is not installed on the server. You want to schedule the DTS package...more >>

What is the major difference b/w Full Recovery Model and Bulk Recovery Model. Thanks NOOR ...more >>

I need to install sql 6.5 client on windows xp. anyone any experience of doing this...i have heard it is possible but I am having no luck as yet. any assistance would be appreciated...more >>

What is the difference b/w With No_Log and With No_Truncate.. Thanks NOOR ...more >>

Hi All Please can someone tell me if there is a way of changing the Licensing mode of SQL Server 2000 from Device/User CALs to a Single CPU License mode ? I ask because I am currently running Windows SBS 2000 and want to use the SBS Migration Pack to split it down to the separate packages. A...more >>