We have winxp workstations with a client software that connects to a win2k3 server with sql 2k & sp3 installed to access a medical database where we pull up the patients information. About a week ago 2 of the stations became slower then normal when searching information from the database cause n...more >>

If your database is very large and very busy, multiple files can be used to increase performance. Here is one example of how you might use multiple files. Let's say you have a single table with 10 million rows that is heavily queried. If the table is in a single file, such as a single database...more >>

I did not yet find out how to change options so that I can copy & paste query analyzers output into Excel or Outlook. In Excel, I need the Columns Headers, they never appear. In Outlook or word, I'd like a tabular form, not just plain text. I have checked the Option "print column headers"...more >>

Can any one let me know about SQL Server dedicated server. Like I have installed SQL Server on the dedicated machine and configuration are as follows. RAM : 8x 512KB Hard disk : 2x 36GB Hot Swap CPU : 3.06GHz I need to ask one question like what best practise I have to adopt f...more >>

I was under the impression that the Client Connectivity install was required for every machine on a LAN network that wanted to connect via OLEDB to an sql server database. However, I recently created an adp project in MS Access that seemed to connect without any problems, even though the Client ...more >>

Can any one let me know like I wanna save the text file into text column and see the data through select statement....more >>

Can we do point in time recovery if I have a full backup... I don't have a log backup....more >>

In our current scanario log and data file on the same drive, I want to move the log file into another drive for optimization and database is in use. how can I Current Scanario :- MyDB1_DATA 1 C:\MSSQL\data\MyDB1.mdf MyDB1_TLOG 2 C:\MSSQL\data\MyDB1.ldf Desiring Scanario MyDB...more >>

Where exactly does one find the installation package for Client Tools for SQL Server. SQL Server 2003 running on a Win2003 server. Workstations now need console, etc. ODBC links from the workstation to the server work fine. Thanks....more >>

Hi All, I have installed the Developer Edition on my computer and have been using this SQL database for my project. The SQL server Standard Edition is installed on the server and I need a SQL client to be installed on my PC to be able to communicate with the SQL Server on the server. Th...more >>

My SQL Server hold entire memory, can any one guide me how can I release memory from SQL Server? Farhan Iqbal...more >>

hi how can I look my registered servers on Enterprise Manager via query? Farhan Iqbal...more >>

Can any one let me know after executing the Statistics of stored procedure I got the following information, can any one tell me which column and which value I have to check for optimization and fine tunning point of view. Duration CPU Reads Writes 0 0 0 ...more >>

When I use TSQL Debugger it will open three windows... I wanna ask about the second windows. it gave me output like that Name (Globals) Value (Globals) Type (Globals) @@connections 38 int @@transcount ...more >>

I just wanna know what is the optimized way for fast retrieval if there are billions of rows in a single table. Can any one let me know any idea except table partitioning for the fast retrieval of data Thanks in advance. ...more >>

Hi I recently installed the Feb 2005 CTP on a desktop that already had SQL 2000 on. I installed 2005 as a named instance, thereby wanting a side-by-side installation. My problem is that Query Analyzer now is no longer applying the colors to keywords. Irrespective of what I set the colors to be...more >>

We are developing a portable gaming device for use in casinos and bingo halls. We use SQL Server (2000K) as the backend. The gaming device software is a Windows CE application written in C/C++. We do not use any framework as we needed maximum graphics speed to spin reels and do other anim...more >>

Hi, In SQL Server Enterprise Manager > Space Allocation. I can not reduce the current size. I can restrict the to current size but I can not reduce it. This lay person very much appreciates your help. regards S --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus...more >>

I'm trying to use PHP to connect to SQL Server on a local computer via IIS. I've installed SQL Server, runs fine. IIS runs fine. Any suggestions on intalling PHP. Thanks!...more >>

Hi there, Been using EM for a few years now, most of the time without any problems. Every now and then however I get stuck with this problem that seems to persist for some time and then disappears again: Connected to a remote SQL Server (at hosting provider), when selecting the databases...more >>

I want the replication b/w Access to MySQL... can any one let me know the tool ..... ...more >>

Can any one let me know the process of Replication b/w access - SQL Server and Access to MySQL... Thanks and waiting for your reply ...more >>

Can any one let me know about the Migration tool from Access to SQL Server. Thanks and have a nicey Day. Noor ...more >>

What is CAL not required for HTTP? Clarification, what is CAL not required for HTTP, is this a web interface, or if I have canned queries for users via a web site, CAL is not required? Or, do I need CAL license for the server or the max. number of users at the same time? Thank you...more >>

I am trying to create a record number. Don't ask why LOL. Below are the items I need in my record number. Here is the format I'm looking for. I am also having problems trying to get it to display zeros before numbers such as 1. Ex. 1 should be 01. This would be stored in a text field. ...more >>

Hi All, I have a datetime column in a table on the SQL database. I need to insert values into the datetime column from vb.net code. Here is my code: dim nameval, str, qry as string nameval = "abc" str = "2005/03/16 14:20" qry = "insert into tab1(name,dateval) values(" & "'" & nameval & "',"...more >>

When I want to view the Taskpad for a certain database, I get an error: Internet Explorer Script Page: An error has occurred in the script of this page Unspecified error...more >>

I am trying to update my table. below is the code is used SqlDataAdapter ioSimpleDA = new SqlDataAdapter("Select * from myDatabase,dbo.IoSimpleCard",myconnect); myconnect.Open(); string qrycmd = ("UPDATE myDatabase.dbo.IoSimpleCard SET Name = @name,Description = @desc,CardDefinitionName...more >>

I am trying to start a remote DTS package from code and I am getting the following error: Description='[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.' Error=-2147467259' Source='Microsoft OLE DB Provider for SQL Server' When I run the code from the local machine it ...more >>

I've been using MS Access 2000 for a while and have recently switched to MS SQL 2000. When creating a primary key I am used to MS Access ability to auto matically enter a number in the ID field when I enter data into my tables. Does MS SQL have a feature similar to this? I checked all the data...more >>

Hi, when i select a table from Enterprise manager and select return all rows. earlier i got the error. "The query cannot be executed because some files are either missing or not registered" i found KB article (Article ID - 315868). but now i am gettong a new error "Provider cannot be foun...more >>

What is the difference b/w Database Architecture, Database Designer and Database Developer ...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

If we want someone to use Query Analyzer only, is it necessary for us to install "Client Connectivity" ? Thanks...more >>

If we want someone to use Query Analyzer only, is it necessary for us to install "Client Connectivity" ? Thanks...more >>

I wanna do DB infrastructure setup so can any one tell me what sort of step I have to do for setting up the database. Thanks JOHN ...more >>

I have about 180 databases for Solomon 5.0 with application connectivity from two Metaframe XP boxes. I am having intermittent latency issues in the Solomon application with functions that correspond to SQL activity. Resource-wise, everything looks good on both the SQL cluster and the Term...more >>

Hi, I want to know if the is a way to prevent the newline if you copy an value from the grid to the editor window. Michael ...more >>

Hi, Currently it is running on SQL 7.00.623 on Winnt 4.0+SP5. Now i want to upgrade this with SP 4. As i follow the installation procedure according to Microsoft SQL7SP4 readme help, It hangs during the installation of Mdac_typ.exe. Don't know where and whats went wrong with the p...more >>

I am doing research into how to best allow developers to visually add views to a database using our in-house system (.NET Windows apps + SQL Server back end). Since Enterprise Manager's Access-like "New View" component is easy to use, I thought that might be nice to integrate into our system. ...more >>

Is there any optimized way for updating all the rows in single table if there are millions of record and I want to update whole data in single table and this is a transaction table. Thanks in advance. John ...more >>

Can any one let me know the migration tool from Oracle to SQL Server ? Thanks in advance. ...more >>

I just installed SQL Server 2000 Developer Edition on Windows XP SP1, then applied SQL Server SP3a. I registered my local database with EM and a database on another computer. The local registration is via Windows Authentication, the other via SQL Authentication. When I attempt any of the Ope...more >>

1) Defaults are applied before transactions. Defaults incur more overhead than constraints but less than triggers. Defaults are less functional than constraints or triggers. 2) Defaults are applied after transactions. Defaults incur more overhead than constraints ...more >>

I have task in regards of synchronization of databases. Scenario is: I have 4 databases and 1 web server. When ever I lost connection due to any reason from any database, I want to switch automatically to other databases which are synchronizing each others. One other thing is, how I can synch...more >>

I have a Samba server set up in an all Windows network and 2003 AD domain. The server works and I can see the shares...no problem there. I also have MySQL up and running and know how to populate the databases manually and do queries and so forth. But what is the best way for users to acces...more >>

My db is on a shared server with two hundred tiny databases. Query analyzer connects very fast, buty Enterprise Manager stupidly reads the schema for each of the 200 db's while it is loading the GUI. Sadly, it freezes up for about ten minutes while loading all that stuff. I love the way EM mak...more >>

1) Which one of the following is NOT a SQL Server page type?=20 Index, Table, Data, Text /Image, Global Allocation MAP, 2) Which one of the following is a characteristic of a Keyset-Driven = Cursor?=20 Order is Dynamic. , Values are Dynamic., Membership is Dynamic., = Keyset is built in...more >>

I am having a problem inserting data into a database table. There is a stored procedure that is attempting to insert data into several tables, if there is a duplicate entry already exists in the table then a unique key violation is thrown back from sql server (2000) to the data access layer. The...more >>