Hi All, the size of my temp db has increased drastically. I would like to reset it to the original size. I tried restarting the sql server but it is not reset. How can i reset it to the default size (8 mb for the data and .5 for the log files) Rgds, Anu...more >>

We encounter a problem that our memory usage always run at peak, so as CPU usage. We had dual 1.8GHz Xeon processors and 2G of RAMs. We ran both web server & sql server on the same box. The database has 65 tables, 109 SP. Will anybody point me what cause the problem? Do I need to upgrade RAM...more >>

Hi all, I'm in the process of researching a fast disk array for our new database server. I've been looking at SATA RAID 5. I found a review on Tom's Hardware: http://www20.tomshardware.com/storage/20040831/sata-raid-controller-18.html A 12 Disk RAID 5 array is only able to handle 6MB/S...more >>

I thought I understood what was happening - obviously not. Here is my problem: Using windows integrated security. No users should have access to the table directly. I have a UDF that I have granted select, insert, update, and delete on to a created roll that has windows users added to it....more >>

Bonjour à toutes et à tous, Je voudrais savoir si il existe une documentation claire et précise sur l'installation et la configuration de SQL Server 2000 en cluster (Cluster MSCS 2000).. Existe-t-il des pièges à éviter ? Merci de m'indiquer tout cela . Merci. Houdini....more >>

The following SQL statement returns 38 records: SELECT Base_Contacts.ID_Contact AS CONTACTS FROM Base_Contacts LEFT OUTER JOIN Base_ContactAttributes ON Base_Contacts.ID_Contact = Base_ContactAttributes.ID_Contact WHERE (Base_ContactAttributes.ID_Level_Value IN (10150, 10153)) GROUP BY...more >>

Table X has column MYID as type IDENTITY (1,1) and MYVAR as varchar(255). The application is trying to run this insert into the table: insert into X (MYID, MYVAR) values (null, 'test'). This error is being returned: Cannot insert explicit value for identity column in table 'X' when IDE...more >>

Can someone tell me how to make the data portion of the msdb database smaller (SQL Server 2000). It has grown to 662 MB in size. I do have a lot of DTS packages and have several Jobs that run nightly. I have tried DBC SHRINKDATABASE but that did not do anything, Microsoft certainly doesn't make ...more >>

Hi, While executing select * from fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc', default); query simulateneously from multiple clients, only one of them succeeds and all others give the following error message: File 'C:\Program Files\Microsoft SQ...more >>

Dear all I have read the BOL section on this and would really appreciate it if someone confirmed my understanding of this for me with the following scenario Imagine that I have a database that has two sets of tables: The first set contain what could best be described as the product portfo...more >>

I've got a satellite group that acts as their own dba's on a 7.0 server. They claim that they cannot kill certain connections, i.e. they typed in kill and nothing happened. I have seen that happen with web-based connection pooling apps but not with a regular app that they're working with...more >>

I have a numeric column whoose precision is 7 and scale is 3. My first question is how come the length is reported as 5 in Enterprise Managaer? Secondly, whilst trying to update values in these columns I get Server: Msg 8115, Level 16, State 8, Line 1 Arithmetic overflow error converting ...more >>

We have a ton of jobs that we run from time to time and I am trying to figure out a way to let me know who executes a job and when. Would anyone have any ideas they would be willing to share? Thanks, Jeff ...more >>

Hello all- We have a two databases, BoxA and BoxB. BoxA is the live production server and BoxB is a backup server that we do log shipping to. Every couple of hours we ship logs from BoxA to BoxB. BoxB is a warm standby SQL server. We would like to backup BoxB, the warm standby, however we...more >>

I have a user who is running SQL Profiler on their client machine. During the devlopment phase of this project they used profiler to help with their coding. Now that we have taken the project to staging and production they no longer have the necessary rights to run profiler. Here is the...more >>

Hello, would someone be able to tell me how I can restore a SQL 2000 database from a tape drive that is located on a remote server without dumping to a network disk? I am really looking for the least expensive solution - I understand that there are 3rd party tools that will do this, but I am a l...more >>

I have an Identity field in a table with many records. Since the database is corrupt, I recreated the table and loaded the original data back into the new table. I want to make sure the Identity field keep incrementing its value from the max value instead of starting from 1 again. Here is w...more >>

Hello, Can anyone tell me the types of locks happening during a maintenance plan? I have an update process that is running from an sql server through a linked server. And that linked server is running a maintenance plan created through the wizard. When you view the table that it is currently ...more >>

(SQL Server 2000, SP3a) Hello all! I've got a database that is the secondary server in a log-shipped pair. Whenever I try and do a BACKUP on this database, I get an error message that the database is in a READ-ONLY STANDBY mode. Is there any way to circumvent this, temporarily, and mak...more >>

SQL Server 7.00, Service Pack 6 I had an insert statement that stopped working the other day. I figured out that it had to do with the fact that "space available" on the database was very small. I had "automatically grow file" on the db set to 10%, and I had plenty of disk space. I think t...more >>

Hello! We work with MS SQL Server 2000. And it works not so fast as it desired. The question is : How to designate - is it not enougth of hardware or the software works incorrectly? One more phrase - the software not MS SQL Server but the software is the system of our vendor built on MS SQL...more >>

Hi, I'm new to MSSQL world and I have a little question: I have just added a new field to a table containing some 3000 rows... The new field has the same value for all the existent rows... How can I automatically update all rows ? I would like to put "EN" string in all rows... What to...more >>

For the last two days I've been getting this error whenever I click on a Job in Enterprise Manager: Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. Any idea what is causing this? Agent appears to be running - it is performing the assigned tasks ...more >>

I have SE SQL2K sp3a running on a Win2K 4 processor server with 3GB of memory. The server is set to dynamically manage the memory on the server and this machine is used only as a DB server. There are databases on the server that are ~ 30GB big and some of the reports we run can require going thr...more >>

Hello, I inadvertently installed Enterprise Edition instead of Standard Edition. I need to uninstall Enterprise edition and install Standard edition. Can someone point me to necessary steps to accomplish this? I am sure I am not the first person to do this! Although the instance is not...more >>

Hi everyone. My turn to ask a question. Is there any gotchas setting up log shipping in a clustered environment. Environment: Active/Passive SQL Server 2000 cluster (2 nodes), several databases = involved in the log shipping. Development SQL Server 2000 on a standalone machine (2 insta...more >>

Hi, I need an expert help on this, i have this query, but it seems to trigger the parallelism on execution, i want to get around that and have a more efficient query, can some please help me with this query. thank you in advance. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET NOCOU...more >>

Looking to learn more about the correct way of backing up a SQL Server DB using the Veritas BackupExec 8.0. Both questions are related to the Veritas Selections screen: 1. Do we need to backup the "flat file" or is it enough to have selection done via the MS SQL Server section? Ex...more >>

Hello, I am studying for my exam and I have a question. I have a sql server in a domain and when the domain administrator tries to access it, he has no problems!! But in the literature it says that a domain administrator must be in a group that has access to the sql server in order to conne...more >>

Hello, SQL-Server 2000: how can I remove server registrations from enterprise manager, when the servers are no more available? For example there are several registrations from servers running under a virtual pc (for developer purposes). Others are there from remote support sessions. I'm ...more >>

Is there anyway to detach a database when the database no longer shows in enterprise manager? I am assuming that their may be a sp_detach or something, is this correct. Thanks in advance...more >>

hi, i am using sql server 6.5 and i want to see the diagram of my tables and relationships of them. how can i do this? ...more >>

I have set up SQLXML 3.0 on a Windows 2003 server. I have created a virtual directory with a Template virtual name as well. It works fine when I access a template in the virtural directory from the localhost. However, when I try to access it accross the internet I get an error page that say...more >>

Ok this morning one of the IT guys deleted the LDF file from the server for a particular database. The file was 45 gig, he stopped the server then deleted the file, without detaching the database. We tried running sp_attach_db @dbname='', @physname='' filling in the blanks but that refu...more >>

Dear All, We are getting a lot of sleeping (and orphan) connections to our database, so I would like to create a script to kill them based upon them being sleeping for over 2 hours. Can anyone point me to the table that holds this info ? I don't want the script as I will be trying that my...more >>

Does anyone know how i can find out the size of a file using transact sql. The xp_getfiledetails is not working. Any ideas? Thanxs...more >>

from PC is uninstalled SQLSERVER2000 and related files mdf and log without to execute backup database. With a tool of recovery file deleted *.mdf and *.log, we have recoverd files. How to do you to recovery the database from mdf e log file?...more >>

Hi, the size of the tempDB increased drastically all of a sudden. How do i find out the cause for the same thnks anu...more >>

We have log shipping from a primary to a secondary for warm standby and reporting. After a reindexing job that caused a particularly large log backup to be created (9,141,927,424 bytes), the secondary appears to have pre-allocated the disk space required to copy the file over (the file has a ...more >>

Hi , During a DTS job what are the actions that cannot be done on a table ? i.e DELETE/TRUNCATE , UPDATE , INSERT ?? i am doing some migration using DTS job but the current database is still being used by users thks & rdgs...more >>

I just found one of my sql query doesn;t work properly, and it seems it is not that simple, the query is like this: select 'lock'=dbo.uGetAttribute3(l.attribute,'lock'), 'priority'=dbo.uGetAttribute3(l.attribute,'priority'), r.nickname from object1233 r,h2r l order by dbo.u...more >>

I've been given the task of determining if this framework would have been better if we would have used tables instead of roles. If they change it they will most likely implement a similar system using a table instead. About a year ago I was asked to create a new security framework for one of ...more >>

Hello: I'm experiencing this problem with SQL 2000. I have a large DB (7 GB) and fromtime to time every statement trying to insert or update data gets blocked and dies with timeout. Looking for more detail I have found that this happens when SQL server is growing its files. The DB is configure...more >>

I am using DTS to import csv files that I receive from a third party. Each day I receive many file which I import into many different SQL Server tables depending on the name of the file. I am doing this as part of a larger automation process written in C#. Due to the csv file names differing ...more >>

SQL Server 2000 SP3 running on Windows Server 2003. The machine is a quad-Xeon 2.2 GHz with 4 GB of RAM. The SQL Server instance has 4 non-system databases, including the SharePoint Services content database. We've been running, at 2:00 AM, weekly complete backups and nightly transaction...more >>

Hello Is there a way in Sql Server to prevent a user from modifying tables or data but allow creating and modifying store procedures? thanks!! ...more >>

Hi I have a simple question... how does one copy a LARGE table (say 100m rows) from one database to another in SQL Server 2000? Using the copy table feature in DTS is great - but can it be done from a T-SQL interface (say a stored procedure or something)? the bulk insert/copy features see...more >>

Does anybody have any recommendations of good training courses available in the eastern NY, northern NJ, western CT areas? I'm a DBA looking to take a High performance database Tuning class. I would really prefer one with an intructor with real world experience over those who follow a standard...more >>

I have a corrupt table in a 320 MB database. Is it better to restre the entire database than to restore a particular table that is corrupt in sql server 2000. How do you restore an individual table....more >>

What do I need to set in SQL Server to enforce user logon and passwords. I move a copy of the db to local SQL Server for a demo and every time I login to my app it will not accept the user name and password but will except trusted connection. When I execute the app and point to my server...more >>