We are intermittently getting this error on our SQL server. The front end is access and this happens every so often causing the users to have to exit out of access and reconnect. I'm by no means a SQL expert, and our programmer who manages this database isn't sure what it is either, he says it...more >>

Hi, I'm just in the planning stages of upgrading a small bunch of databases to MS SQL Server (2003). The current databases are very poorly designed, so I'm basically starting from scratch. The databases will grow to be quite large over time, and we have plenty of space for it. Currently the n...more >>

Hi, I have a problem. My problem is : I have two tables reprezentoing a tree, first table representing nades, and second representing links first - ID, Name second- ID1, ID2,weight --------------------- ---------------------- | 1 | name 1 | | 2 | 1 | ...more >>

Unable to restore User database from One Server to another server, when ever I going to restore database it’s giving following error Server: Msg 3132, Level 16, State 1, Line 1 The media set for database 'Vacancies' has 2 family members but only 1 are provided. All members must be provide...more >>

Is there any way to deploy System DSNs to multiple PCs? I'm in a windows xp client environment with sql server 2000 running on a windows server 200 box. Thanks for any help....more >>

When in the sql enterprise manager, if you right click a table and go to open table--> select all rows, does that "lock" the database? As in if you select all rows will someone else trying to read the data (via app or web interface) and update it be locked out of it? We're often told that we s...more >>

declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'SRVDB1@mydomain.com', @TO = N'gmatteson@mydomain', @priority = N'HIGH', @subject = N'Process Success', @message = N'Database Backup Succeeded.', - Rather than putting Database Backup Succeeded, I would like to put "@...more >>

Running Windows 2003 Server with SQL Server 2000 w/SP3a This is the message I recieve when I go to add the profile to the server and click Test. Any ideas? Thanks, - Gabe xp_test_mapi_profile failed with mail error 0x80040111 ...more >>

Can any one guide me like what I have to do for setting up my tera bytes database in SQL Server. Any helpful article. Thanks ...more >>

I wanna save IP address in database in Int format. Let's assume the ip is... 219.25.12.0 Can any one give me the idea like how I have to parse and save it into the database in the int format and again parse for displaying in the origional form. Thanks in advance. ...more >>

Provider: SQLOLEDB Version: SQL Server 2000 8.00.760 Script for creating table: CREATE TABLE [dbo].[ADRVERTRETER] ( [ROWID] [timestamp] NULL , [ROWVERTRETER] [int] NOT NULL , [FIRMA] [smallint] NOT NULL , [VERTRETER] [int] NOT NULL , [NAME] [varchar] (20) COLLATE Latin1_General_C...more >>

On a Windows 2000 pro workstation I am using SQL 2000 enterprise manager I am trying to return all rows, I get the error message "An unexpected error happened during this operation. [MS Design Tools] - Class not registered." I have reinstalled the client tools, reinstalled service pack 3a, ...more >>

I've been working on an Access 97 database that's pretty much reached it's limit in terms of performance and reliability. Although it supports relatively few users (5-10 concurrent) it contains a lot of data (around 30 tables, some with several million records) plus a lot of forms and reports. ...more >>

I have successfully migrated an Access 2003 database to SQL server - at least all the tables and queries that resolve into views migrated successfully. I also sucessfully migrated all my forms and code into an ADP project. Everything works with one HUGE exception. All my tables on the SQL serv...more >>

Let's assume I have to go for setup of sql server and I have a 20 GB database and daily transaction is around 200 KB size. Can any one tell me what I have to do for setup sql server like what are the configuration and what are the step I have to consider. Thanks John ...more >>

This ought to be easy. But I can't figure out how to do it. Using Enterprise Manager in SQL Server 2000, I point to a table, select it, right click and choose Open Table-> Return all rows. Now I have the table open and I can edit to my heart's content. How can I do the same thing in SQL ...more >>

Hi, I'm forever running around updating\ change client libraries and aliases on client machines using the cliconfg.exe utility. Does anyone know how I could automate this? Ideally at login users aliases are created or updated? Would this involving scripting and registry modfications? ...more >>

We have Windows XP workstations and I'm trying to figure out what this Client software is? Can anyone give me some information on this? Installing MSSQL Client Software Before installing the application, you will need to install your MSSQL Client software that matches the version of your M...more >>

Is it possible to take backup of database for 1 day change? also possible to restore it back for the particular date? for example.. In one month data of database I want to take a backup for changes in 13 of the month. if required restore it back. -- WM_QUIT RLN...more >>

Dear Professional, I am encountering one error while the data is going to be replicated. Here is the detail ! Last Command : {CALL sp_MSins_Master (16, 'Okie', 1, {5575376A-73CB-419C-9175-F6662FB115B7})} Transaction sequence number and command ID of last execution batch are 0x0000000B...more >>

I have written a VB.Net application using a SQLConnection to connect to a SQL 2000 database. The application uses an update statement in a SQLDataAdapter to make changes to a table on the server. The problem is that one client is getting an error with the update failing due to string trunc...more >>

What is the best tool for migrating the database from access to SQL Server or vise versa. Thanks ...more >>

Can any one tell me about the Archiving the database concept. How can we do archiving in SQL Server. Thanks ...more >>

Hi, I connect AccessXP to SQL2k (.adp) and I would like to protect my work. I noticed that the forms and reports created can be easily imported into a new project. Howto prevent / block it? TIA ...more >>

Sp_Monitor Here I have a following information about Statistics but can any one let me know either this is ideal one or not. last_run current_run seconds ------------------------------------------------------ --------------------------------...more >>

I am using the Performance Monitor so can any one tell me about the average speed of Memory, Physical Disk, Processor. I just want to make sure due to SQL Server it performance is not going to degrede so can I one let me know the counter values. Thanks and have a nice day ! ...more >>

hi, do you have to be a local admin on a windows 2000 box in order to view and execute any NT scheduled tasks? I have delelopers that shouldn't be local admin on our production sql server, yet, they need to view and execute some NT scheduled tasks on the server. I've granted their dom...more >>

Is there a way to import or copy the odbc drivers from my server to my client without having to go through the process of setting up a new driver, defining the format, etc... on each client machine. -- -------------------------------------------- Yes, I searched first :)...more >>

We are working with 10 new XP Pro clients and a new SQL Server 2000 install. It is a workgroup environment. Each client has SQL Client Network Utility run on it with a Server alias set up using TCP/IP pointing to the correct server. 8 out of the 10 clients work perfectly attaching to the ...more >>

I'm running SQL Server 2000 under Windows 2000 Advanced Server. Authentication is set up as Windows Only. The Administrator account for the server is set up as an SQL user (this is done by default). I'm using the following ASP code to log onto a sample database (for which the Administrator has...more >>

I have a database that has strings in a description field. I need to be able to search this description field with another text string.. For example, in the second sentence above say I want to search the description field for the string "able to search". This is how i have been trying to do...more >>

Is there already a stored procedure which simply lists all user tables with their corresponding number of entries? If not, did anybody write this by any chance? I would appreciate any pointers, thanks. ...more >>

I'm using Visual C++ to insert records into my MSDE database. I'd like the user to be able to view the data via Access projects. In my application, is it possible to configure the connection settings for an Access project to connect to the MSDE database? For example, if I were to click the Vie...more >>

When we migrate database from SQL Server 7 to 2000 so which doesn't migrate to Sql Server 2000 like we have to do manually ? All Index migrated ? Thanks ...more >>

Can any one tell me any website from where I can get the sybase book online like sql server book online. Thanks ...more >>

We have an old server 6.5,After we rebooted the server. Try to login to EM and try to connect get the following Error: SQL Server Error [DB Libraray] Unable to connect: SQL server is unavailable or does not exist; Severity level 9 MsgNo 10004 OS Error 53 ConnectionOpen(CreateFile()) ...more >>

Hello, I have two workstations that run an application that uses SQL Server. The OS on the workstations in W2000 and there are no SQL server tools installed. When the workstations connect to the default instance of SQL Server (for instance M1_DEV), there is no problem. But when the wor...more >>

I have a question about the "Connection Timeout" from the client to the Sql server. Everything works fine when I change the "connection timeout" property in the connection string for the scenario: "the machine is alive but the sql server is down" but in the scenario that the network connec...more >>

I'd like to be able to present my user with a tree view of the devices and directories a remote SQL Server machine can access. What I need to do is what Enterprise Manager can do: if I connect to a SQL Server database on a remote machine to do a backup, when I come to select a filename the...more >>

I need to find a way to upload an Excel file into an MS SQL database using a web control front end. I have my ASP.Net control (using C#) uploading a file to a directory, but the server people now tell me that I cannot have a writeable area for the web and have a DTS see it as this is too much o...more >>