I currnetly have several SQL Server 2000 tables linked into an MS Access database application. When tryingt o update NEW records created using Access, the operation fails stating another user has made changes to the record. However, if i update a record that was alreayd in the database, the ...more >>

Please forgive this very newbie question but.... I've played with mysql and used tools such as mysql front and sqlyog I'm currently going through a teach yourself asp.net (which comes with a copy of sql server) and was wondering if there are any free tools to connect to sql server. I've t...more >>

Hi, I want to store data on my Pocket PC in an SDF file and then use ActiveSync (4.0) to have that SDF file synced to the sdesktop. Now, I need some way to read that SDF file on the Desktop and populate and Access database. My users do not and will not have sql server or any internet...more >>

Is there any way I can search text in whole database? Thanks in advance. Noor ...more >>

I'm not able to edit the database structure of a SqlServer 2005 database from Access XP (Access complains about not understanding the SqlServer structure...which is not suprising). The alert messages suggest looking for a patch from Microsoft to correct the problem. Is there such a patch? Or ...more >>

Hello everybody I have stored procedure SP1 (sql server 2000), that calls stored procedure SP2 and SP3. SP2 has 10 queries in it. In most cases SP2 runs without problems, however sometimes 9th query(insert query) fails and it doesn't go to 10th query and it does not go stored procedure SP3 ...more >>

We recently linked two of our SQL servers and I was looking forward to the luxury of querying across them. However, I am getting the following problem: Cannot resolve collation conflict for equal to operation. I understand this has something to do with Collating, but don't quite know how tha...more >>

Is there a way so that when I click on a stored proc it would default to the modify option? Or when I double click on a table it would just open a query window and show all records? It would be great to be able to override the current default nature, for I rarely need to see the params of ...more >>

I had an issue with indexing a BIT column in SQL Server 2000. Every book and newsgroup I read said that you cannot do this. But you actually can! Refer to this website: http://www.aspfaq.com/show.asp?id=2530 ...more >>

My apologies if this is the wrong newsgroup... I couldn't find the most appropriate one. Does a client access license allow a user to access any # of SQL Servers deployed in my enterprise or do I need a CAL / user / server? Thx. ...more >>

Periodically I get this error and from that point Summary view displays no info. If I restart the SQL Management Studio than Summary view works until the next crash: Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this er...more >>

I would like to select multiple obects in the IDE for scripting purposes, say all my sps so I can pump them each to separate files, is there a way to do this in 2005? Thanks in Advance! Regards, Adam...more >>

hi I have implemented merge replication on my machine my question is that my database log size is growing very rapidly. Can any one help me in this regards why the log size grows in GB within 3 to 4 hours. Waiting for reply anxiously Farhan Iqbal ...more >>

I get the following error when trying to run Query Analyzer: SQL Query Analyzer requires ODBC Driver version 3.7 or greater and ODBC manager version 3.5 or greater. Incompatible version of odbc32.dll and/or sqlsrv32.dll are installed on this machine I am running the SQL Server 2000 Client ...more >>

Is there any way we can create the Excel File on the run time through any SQL Command or any script. Thanks ...more >>

I have searched a number of places for this answer so I apologise if this has been covered and I just couldn't find the content. I am just starting to look at the new version of SQL Server 2005. One thing that I am finding very frustrating and that I cannot seem to get around is that each ...more >>

I am having a problem with a query statement when I try to use sum( ) on a field in the query. For example: select somast.fsono, somast.forderdate, somast.fcompany, sorels.fduedate, sum(fnetprice) from somast inner join sorels on somast.fsono=sorels.fsono where somast.fstatus<>'CANCELLED' ...more >>

I am relatively new to sql server 2000. I have a transaction log that is 98 gigs in size that has never been backed up. This transaction log file is too big and needs to be decreased in size. Can you tell me how I would make my first full backup of this transaction log file? To shrin...more >>

I have a data like .... ID Alias Date 45 Order 1 12/01/2005 49 Order 2 12/01/2005 46 Order 3 12/01/2005 50 Order 4 12/02/2005 55 Order 5 12/02/2005 I want to add one column at the above result ...more >>

For performance reasons we have (successfully) used pooling in our apps and services on almost one hundred installations, NT 4.0 to 2000 servers (SQL 7.0 - 8.0), NT 4.0 to XP workstations without a problem in any combination. Now with 5.2 (2003) server a local client is unable to connect and...more >>

My logincheck.asp Page were working well in SQL 7 but , When I try to run my logincheck.asp page after installing SQL 2000 I get the follwing error . Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied. /pts/logincheck.asp, lin...more >>

Hi, I am writing a Real Time monitoring application which will use SQL Server. The database will reside on the same PC as the monitoring app. My question is :- will having SQL Server on the same machine as the monitoring app affect the performance of the monitoring app? Will SQL server u...more >>

Can any one explain me about the most secure authentication mode and why ? Thanks in advance. ...more >>

I wanna ask one question regarding SQL Mail.... I wanna use xp_sendmail stored procedure in user defined stored procedures, but the question is that what would be the connection string. We have a three websites running and all three have different Users and Password, but the problem is that I ...more >>

sql 2000 on 2003 server standard, only 2 out of 10 users (xp pro clients) trying to access sql program are asked to login to database, server name, database, login id, password to TableName: datatable. Is this an xp client issue or sql issue....more >>

Hi, Iam new with SQL 2005, iam trying in the lab to create a mobile Application with SQL mobile,i used the SQL server mobile Tutorials, every thing went fine but When i try to create new subscription in SQL 2005 i reciecve this Error: Synchronizing Data (100%) (Error) Messages Initializing...more >>

For a small company, I need to come up with backup and restore procedures for a sql server 2000 database. This company will not consider using sql server 2005 until the end of 2006. Thus I am wondering if you can give me a script and/or point to me to a url that that I can use as an example...more >>

I'd like to know if SQL 2000 client and SQL 7 Server are compatible. I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as you it is not possibile to install SQL 7.0 Client on the Windows server2003. Tx Suzana ...more >>

I have a large number of text files that I want to import into a database. I have created a DTS package that knows how to import and transform the data so that it can be imported but that seems to be hard coded to a particular file. Doing this by hand 18 thousand times is not something I want ...more >>

Where's the best place(s) to ask questions about SMO? -- Lee ...more >>