How can I set the default recover model as Full Recover Model thanks in advance. Noor ...more >>

My SQL server client runs Ok until this morning. When I tried to open Enterprise manager, it gives error message: MMC can't open the file SQL server enterprise manager. msc the files may not exist or you don't have rights to access the file. I log in as the same username in the works...more >>

Is there any way to give a client the ability to write his own queries without using query analyzer. If not, is there anyway to lock down query analyzer so the user does not see the object browser, and can not see the Master Database in the Table Drop down box? TIA...more >>

I am creating a table in query analyzer on an XP client. However, when I use enterprise manager to check the tables, the new table is not there! The scripts execute correctly, the correct database is being used and I refresh the database before checking if the table is there. The only way I ...more >>

How do I change the Primary Group of a database, as I am getting an error suggesting that the group is full. What does this mean and how do I deal with it. Thanks a lot, John Hollister...more >>

I have a few tables in my database that are 1.6million lines long. I want to blow these up to at least 5million to test speed. I have already copied my original database to another one called test2. What do I do to test2's tables to make them at least 3 times bigger? skc...more >>

When composing SQL scripts that contain special=20 characters, e.g., '=A3', '=AC', '=A9', '=AE', it has been found=20 that different versions of SQL Client treat the characters=20 in different ways specifically SQL2000 to SQL 6.5. This=20 can result in these characters being translated to produc...more >>

I am trying to format the date in an SQL Select Statement and I am not having any luck. SELECT * FROM baby WHERE date Between #8/01/03# and #8/31/03# ORDER BY date it is displayed like "8/01/31" but I need it to look like "August 1, 2003" Thanks, Jamie ...more >>

We are having problems with data loss from a text field. The client application connects to a SQL 2000 database, and was originally written for Access 2000 and has been recompiled for 2002. The problem occurs intermittently when users change data in a memo field and then save the changes. ...more >>

My company is working to have a SQL app running on our website & I am not sure how the licensing works for something like that. Since only one computer will actually be using the SQL app (the Web Sever) does that count as just one license or would it go by the actual amount of users that u...more >>

Dear Professional Can u help me out in describing for what the triggers are used Thanks Jayshri ...more >>

HI We have an app using SQL odbc driver 200.80.528.00 connecting to SQL2K sp2. On the W2000 pc floats return maintaining the precision but on the NT4sp6 PC the float is rounding up or down losing its precision. Any ideas, anyone? NT4 has celeron400 CPU Our App is built using Omnis737...more >>

Hi, I have a store proc with an input parameter runs very slow. However, if I set the parameter inside the stored proc or just run the sql script, it runs very fast. Seems the query plan is different between using input parameter and using variable inside the stored proc. When using ...more >>

Hi, I am running SQL 2K I have a DB that is 6GB. out of that, 5.5GB is the Trans Log. I did a backup of the Data and the log. Now it shows 5.3GB unused, but I cant get that free space to go away! When I creaded the DB it was 10MB? so I know that is not the problem ...more >>

Hi All, I am having serious problem since last couple of days with my SQL server 2000 version. on one of my table I have 1788653 records and I am unable to manipulate data into it. whenever i tried to insert any more record, SQL server will give me error: ------------------------------...more >>

I have installed SQL Server 2000 client connectivity only (no client tools) on WinXP clients using an unattended install with an ISS file. The XP clients all have XP Service Pack 1 installed. This works perfectly. We have applied SQL Server 2000 Service Pack 3a to the server and now I wan...more >>

Dear Professional Can any body explain me about the fillfactor, I took help from Book online but failed to understand about FillFactor. Waiting for your reply Noor ...more >>

This update gives an error message on machines that don't have MDAC installed. What happens if in the future one of those machines downloads the MDAC, will it then require the patch, and how will I keep track of that.... We use an application that requires MDAC and then asks the client ...more >>

I have an Access application that connects to a SQL Server database. Several times a day I get a situaion where one user seems to be able to lock up the database, and until they exit the application no one else can edit any records. When I check the proces information I see hat that user will ha...more >>

I'm trying to install only enterprise manager on a terminal server that has MDAC 2.7SP1. When I do the client only install, it tries to install MDAC2.6 over MDAC2.7SP1. How can I just install the enterprise manager without installing the old version of MDAC. I'm worried that if 2.6 installs ...more >>

I am new to SQL2000 and I have a database (built in Visual dBase) which I successfully imported into SQL 2000 using DTS. The database is 1.1GB and I contains a table which has around 1.5million records. What I want to do is replicate the data so that I have around 5million records. This...more >>

I have been having a problem with SQL 2000 Server for some time. When I connect to the server with Enterprise Manager and open the database folder, it takes upwards of 30 minutes or more, and sometimes it simply hangs. This problem is discussed in KB article 282416 "FIX: Opening the Data...more >>

I am having difficulty understanding permissions when using Access 2000.... I created a Windows authenticated DSN, when I link to SQL tables they are updateable, however, a view which simply contains 4 coulmns from one table is not updateable from Access. Anyone know why ? I have also ensur...more >>

Hello - I'm new to supporting SQL servers and the client tools so I hope I'm in the correct community. My user is complaining when she shuts down the Analysis Manager using the x in the upper right hand corner or file, exit - the system does not shut down. It simply hangs until she Ctrl+...more >>

How can a DBCC shrinkfile of a datafile cause a deadlock ? I can never seem to make it work. Always results in deadlock ...more >>

hi, I am not able to connect my SQL Server 2000 Machine, from client, EM & QA both are giving following error. A connection could not be established to [Server Name] Reason: Data source name not found an dno default driver specified. I am not able to understand before few minutes I was c...more >>

Have a client that needs to do an "on demand" back up of a database. How can this be done ??? The database in question is used by the accounting department and the application uses the SA login to access the database. Any insight would be greatful. TIA ...more >>

How can I convert datepart(week,getdate()) back to the last date of the week? Example, 8/13/2003 is week 33. How I get the first and last date of the week from the 33 returned?. Can I set the week to run from Sunday to Saturday?...more >>

How do I generate a query/pivot table view to group data in a table by date range? The table contains product id, date sold, quantity and amount. I want to be able to generate a query/pivot table view to show the data on a weekly basis (Sunday to Saturday), using the Saturday date as the r...more >>

would like to test a connection on my laptop to ms sql server on my laptop i would like to test a tc/ip connection like this. I have check ms sql server network utility and found that tc/ip is set = as a protocal as well as named pipes how do i find the ip address ? anyone help? s...more >>

hello all, I have the .sql script file that I need to run to update the SQL 2000 database. How do I run the script file? thanks....more >>

I am trying to register a SQL server in Enterprise Manager 2000 and getting this error. I am on a LAN behind a Linksys BEFSR41 router and attempting to connect to a SQL server on a remote network via the Win2k vpn client software. I can map drives on the remote server. I can connect to web a...more >>

We are trying to distribute the OLE DB provider for Oracle but are not = sure what support files are needed to make it run properly. Does the = Oracle clients need to be installed first before the MS OLE DB provider = for Oracle will work?...more >>

Hello, I am trying to use Enterprise Manager on XP Pro to connect to a remote MS SQL server. When I try to run the Enterprise Manager I see the MMC process appear in the task manager but the window never appears. I've uninstalled and reinstalled and still no go. Right now I am downl...more >>

Hi, I have MSDE 2000 installed on a laptop and I am able to connect to it by using SQL Sever 2000 client tolls installed on the same machine but not able to connect from other machines or from the application that used OLEDB. Any idea ? help is very much appriciated. Thanks Srini...more >>

Hello I am a novice in using SQL Server 2000 enterprise edition I am trying to copy a Database (through scripting) which has relationships I created using Diagram. When take this generated script and run on destination server, I do NOT see any diagram under newly created DB. Is there a...more >>

Hi! In our company we want to build our dedicated server to put it in a collocation company. I'm very unclear with the licensing programs that Microsoft has. What license should I need to run SQL Server in a web server?...more >>

Hi, I have SQL server 7 at a remote site. I am using a ODBC to connect to the server. I can ping the server name and have checked the firewall the ports are allowed. I get the following error. Connection failed: SQLState: '01000' SQL Server Error: 1703 [Microsoft][ODBC SQL Server Dri...more >>

i am trying to install SQL Server 2000 client tools on my computer. I get all of the way through the setup and then when i click the finish button to actually perform the install, I get an error. I can't find any information on this error. I'm hoping that someone here can help me. The...more >>

My company is in the process of migrating a FoxPro Application's data to SQLServer2000. We have recompiled the FP code with VFP 8.0. I have tried the upsizing wizard in VFP 8.0 and it fails on a large table with an message of "error #43 in genbulkinserttextfile(0). there is not enough memor...more >>

While in the past Analysis Manager had no problem viewing cubes, building mining models, and running in pivot table services, it started missbehaving recently. I have done a new install and updated the service pak, no luck. Specifically, Analysis Manager is unable to browse cube data ("uns...more >>

Is there anyway to speed up the timing out of an ADO Connection. VERY FRUSTRATING! I have found three different properties that reference timing out. Set them all to 5. Still takes about a minute to timeout. And worse yet, after it times out it tries to connect again automatically, now waiti...more >>

I am new to SQL Server and have a question. I am using SQL server 2000. When, in diagrams, you create a l link between two tables are you actually creating a real link between the two tables or just a diagram that visually shows you a link between two tables? ...more >>

Can someone tell me how to add licenses so that I can add users to my server. Your response will be greatly appreciated. Thank you, Thaddis Creamer...more >>

SQL Expert, FYI: SQL Analyzer Hang! I am running SQL 2000 Personal Edition with SQL2K Service Pack# 3a on a Windows XP 2000 Professional OS Service Pack# 1a. SQL Server 2000 Version PE: @@Version reported: ******************************************* Microsoft SQL Server 2000 - 8.00.760...more >>

I am using SQL Server 2000 Client (Personal Edition) with Service Pack# 3a. My OS is Windows XP Pro. SP1a. In the Sql Analyzer, previous versions remembered where I left off (sql script folder). Sql 2000 always starts with My Document folder. How can I configure iSQL so that it remembers my last ...more >>