I have a relational data structure where I need to delete all data from all tables. However, constraints are defined on the tables, so I need to delete from bottom to top to avoid referential constraints. Do you guys have an idea of how to accomplish this? Thanks, :o) -- Jesper Sto...more >>

We have an standar 4-SMP MSSQL Server 2000. What impact has the option NT Fibers on performance? Under what circunstances is appropiate use it? Than in advance ...more >>

I will be installing the evaluation version of SQL 2000 to perform some testing. Can anyone tell me if it is possible to eventually upgrade this to an open licence version of SQL. I have read articles about upgrading to the Full Retail Version. Thanks ...more >>

Dear all, I have scheduled some jobs in SQL Server Agent to run some DTS packages. The original owner of these jobs is "sa". However, when I changed to the owner to be another SQL login id, e.g. myUser, the scheduled jobs failed. "myUser" has the "db_owner" role. The owner of DTS packages i...more >>

In the sql server 2005, why do I need to perform querying as followed "SELECT * FROM Productiion.Product" Why do i need to stick the prefix Production to the table named "product" in Adventurework sample database? Any idea would be appreciate. ...more >>

We have all the files in our database set to autogrow by 10%. During the day we encountered a 5 minute time period in which SQL activity seemed to come to a halt. I suspect that during that time period, one of the database files grew. Is there any way that I could tell this by looking at a c...more >>

What would you say is the niche of SQL Mail/DB Mail? Meaning, what is the one thing (or things) it offers that cannot be acomplished without it (besides agent alerts and such). Is it simply the emailing of resultsets from within TSQL logic (triggers/sp's, etc.)? I'm just trying to get at the hea...more >>

I have a table which already has over 7 millions records in SQL Server 2000, I drop an index of this table, but when I recreate the same index for this table. It will take long, long time because of the huge records. My question is if there is the better way to create the index for the lon...more >>

I just installed the developer edition and I can't find the sampels for the Notification Services Tutorial. There is no such folder: C:\Program Files\Microsoft SQL Server\90\Samples\Notification Services\tutorial ...more >>

i've got a query that uses the nolock option for all tables in the from clause. when i look at the locks/object section in enterprise manager, each one of the tables in the from clause have a lock type of TAB. not sure what's going on here. any help will be greatly appreciated. thanks, arthur...more >>

I have 1 sql 2000 server in place that has about 150 databases on it. Two applications work access those databases half are for one application half are for the other application. Since the server is becoming quite overloaded lately I've decided to take another server with sql 2000 on it a...more >>

I have unattached and taken some databases from an Enterprise version of SQL and attached them onto a Personal Edition laptop. Although I have deselected the auto shrink option, on a daily basis it reappears, shrinks my files and my data import crashes. So my quesiton is = Is there a ...more >>

Hi, I met a problem with charindex function. CharIndex can't find the char after 8000 in a text field. You can try the following script: create table #test (notes text) insert #test values (replicate('1',8000)+'2'+'111') select * from #test where charindex('2',notes)>0 drop table #tes...more >>

Hello, People! Good Morning! I have a plan to upgrade my SQL Server to WIndows 2000. Nowadays, my SQL SERVER is a Windows NT4 using two SQL Installation. The first installation is SQL Server 7 with to much DataBases. The second one is SQL SErver 2000. This is the first time that I will upgrad...more >>

I have a backup job that just hangs for days instead of finishing like it should on one of our SQL servers. Its a solomon database and is using SQL server 2000 standard. The system databases are not included in the backup its just the solomon databases. I am not getting an error or anything be...more >>

I'm at a site that is using a single SQL Server on an IBM x445 server. Everything was running fine for a while, and then IBM support made some changes to the client's environment. Now all of my data mart builds are taking longer to complete. Without modifying the SQL processes themselves....more >>

Does anybody remember what the command is to "truncate the log" in Sql Server 7.0. I usually use dbcc shrinfile, but that doesn't work in 7.0. It's been several years since I had a 7.0 database and I just can't remember!...more >>

I'm new in SQL server. How to sppol out a query result into a text file? thanks ...more >>

I have application that I'm trying to enhance database performance. One of the ways to enhance database performance is make sure that your cluster indexes and non-cluster indexes are using the correct fields. This cluster indexes were not set on the primary key for several tables. What...more >>

Hey, I realize that sqlmaint (and hence the maintenance plan wizard in EM) doesn't allow differential backups and deletes. However, what I'd like to know is why? Does anyone know of a document (or other) that explains why this isn't provided by Microsoft? Does anyone know of a good reason ...more >>

I just started getting this error. I am running SQL 2000 SP3 on a Windows 2003 server. Message: 17066 : SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447 Failed Assertion = ''m_SizeRec > 0 && m_SizeRec <= MAXDATAROW''. ...more >>

hi everyone i have one problem with mirroring/ SQL 2005 . i am trying to do microsoft's free lab on my computer. i used one computer 3 instances. principal,mirror and witness 1 - i restored database to the mirror instance. first it was seen 'recovering' now 'in recovery' 2- i created ...more >>

SQL Server 2000 SP3 One of our client has an issue where if they log in as a SQL user in say Query Analyzer and try to access a table that they own it will return an error (unknown object etc). eg Select * From TableName However if they prefix the table with their user name (even thoug...more >>

Hello, I am new to MS SQL Server and I am in the process of implementing a database system which introduces an interesting security issue that I was hoping some one could advise me on. BACKGROUND: I am developing a client / server application that which requires users to be able to downloa...more >>

I need to change DB recovery model from full to simple in existing DB. Of course i know how to do this from SQL manager, but is there any way to do this from sql batch ? I am using sql sript to restore db and i want to incorporate seting db to simple recovery mode straight into this script. ...more >>

We have a 32-bit edition today and want to secure the uptime by adding a cold standby. We want to purchase a new 64-bit machine with the 64-bit editions of OS/SQL. The 64-bit should replicate data to our "old" 32-bit machine. I have not found any information on MS-site about this, is this ...more >>

Running SQLServer2000 on Win2k. How can I determine the isolation level of a running transaction? Thanx. ...more >>

I have a job that I moved from one server to another via generate sql script. This job contains approximately 25 separate steps, where each step calls/executes a DTS package using DTSRun. The job is failing and I suspect that it may be attempting to call/execute the DTS package on the previo...more >>

is it possible to have an oracle server (runtime) and an sql server on the same machine, or better said, is it wise? the instance of sql server is not that heavily used, neither will the oracle server service more than 10 users max what issues could arise with such a setup thnx ...more >>

I have a table that contains fields such as: ---------------------------------------------------------------------------- --------------- CustomerID ProductName SmallDateTime AnotherID1 AnotherID2 Amount --------------------------------------------------------------------------...more >>

Hi, Where can I find a list of supported tape drives by MS-SQL? For example: DDS, DLT etc. Thanks -- Shiri Tzuk ...more >>

Is there any way to create databases that are hidden from SQL 2005 management studio? Alternatively, i noticed thata there is a system databases folder in management studio. Can I create my own folders and put decide what dbs to place in them Thanks in advance ...more >>

Can someone tell me what the record limit is or db size is for PE of SQL Server 2000. I'm trying to import 33.6 million records, and I keep getting an error message that says the data contains an extra column at 454K records. I've tried the HELP, but I only see the Terrabyte limits. Is PE l...more >>

what would be the licensing requirement for the following setup n-clients post data to a .net webservice on machine A volume of data is low so an MSDE (or SQLExpress) system would work if that is a permitted use of MSDE for incoming data this data is further processed and verified before bein...more >>

Hi all, I would like to be able to trace any activity against a specific table. I have tried setting up a trace (through profiler) using the "Objects" event classes, selecting the ObjectID and ObjectName data columns, and filtering for the specific ObjectID of the table I am trying to moni...more >>

Hi, I am trying to bcp data from a txt file into a temp table: CREATE TABLE #output (FIRSTNAME varchar NOT NULL, lastname VARCHAR(32) NOT NULL, state VARCHAR(14) NULL ) master.dbo.xp_cmdshell 'bcp #output in "c:\test.txt" -STRAVELLER -T -c' I am running this within the dbtemp datab...more >>

Hi, I have some tables which entries the enduser can give a new sequence. My current implementation is an extra column "OrderID" that keeps track of the sequence. Endusers will do a lot of CRUD in these tables and its a pain to keep this sequences up to date. A linked list would be much more co...more >>

MSAccess have build in Auto refresh ability, when the other user delete record from DB, you can see on your form <delete>. many time i have dream to add this ability to Dotnet. I think, that notification services is excellent for my purpose, but i dont sow any Exemple or Articlae about thi...more >>

I've a table that looks like this: CREATE TABLE [Rules] ( [RuleId] [int] IDENTITY (1, 1) NOT NULL , // lots more fields [Severity] byte, [TemplateRuleId] [int] NULL , CONSTRAINT [PK_Rules] PRIMARY KEY CLUSTERED ( [RuleId] ) ON [PRIMARY] , CONSTRAINT [FK_Rules_Rules] FOR...more >>

In the past, my short answer has been at least the local administrator on the machine running the DBMS. However I am encountering a situation on one system where the SA insists that I don’t and that Power User is enough. My role is expected to be both a system DBA and an application DBA. ...more >>

Can I export a table data into a script file contains INSERT statements in EM ? ...more >>

After being in the SQL Server 2000 Service Pack 2 and Service Pack 3 betas I was very excited to be accepted into the Yukon beta. I received my official beta1 goodies sometime around October 2003. After installing Yukon for the first time I was shocked and amazed. My traditional enter...more >>

Hi, I am currently backin-up my complete environment to foresee a crash recovery. My ERP 5Baan IV) prompts me to "back-up the registry keys which are specific of MSQL" with no more details. Could someone enlighten me on the subject? Thx in advance. (NTserverSP6a/MSQL7SP1) ...more >>

Hi I am attempting to transfer a database from my server to my customers server. I took the backup file on CD however when I try to do a restore with it I get the following error Microsoft SQL-DMO (ODBC SQLState:42000) Device activation error:The physical file name 'd:\sqldata\mssql\da...more >>

Is there any stored procedure for scripting the database? SQL 2K. Thanks, John ...more >>

Hi, I havent been able to figure out when a job is marked as not runnable. I have several jobs, some enabled, some disabled, but they are all marked as runnable. Someone who can tell?...more >>

Dear all, What would be the fastest way to add a new column (a timestamp column to be exact) to a table with about 15M records? We actually tried doing that earlier, but it was already running for 6 hours and the script has not yet finished executing. We had to kill the transaction as it w...more >>

Hello, I am new in SQL Server, I have to deal with this big database with many tables, is there any way I can get a list of all primary keys , foreign keys and indexes and on all tables? Thanks, ...more >>

Hello, What is the easiest way to move a database from one server to another with the all table structures, view and stored procedures? Thanks, ...more >>

We have two database servers. Apparently they are running two different versions of SQL Server 2000. Can someone tell me what are the differences between the two versions? Server 1 Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Cor...more >>