I want to Insert data from another table, I use the statement: insert into YearsClass (Years,Class) (Select distinct Years, ClassID from St) but it fail. How can I do? ...more >>

Is there a freely available version of SQL Server Enterprise Manager which will allow me to connect to existing SQL Servers (for SQL Server 7.0)? ...more >>

Help! It was determined today (without my presence) that my SQL cluster would begin doubling as a file server of Rich Text and HTML files. There's lots of politics as to why they wont be stored as Blobs in SQL, so I'm not going to go down that road. I will be in a meeting Monday morning "discu...more >>

Hi: Which is the preferable driver to connect to the latest SQLServer (SQL2000) ? I have an application written in vb6, some of the data entry screen hang (but most of the time it work perfectly), we have to clear off all the sql connection from Enterprise manager and relogin into the syste...more >>

I have a SQL 2000 Server with a msdb database status of SUSPECT. I already found a way of reseting its status in the master database, but still can't recover it as it is in use. I tried to stop the server and remove the mdf and ldf files in to another directory so that I could run a script th...more >>

I have Sql Server 2000 and Word from Office Xp. Since a few weeks, I cannot import Data from my database towards a Word document. I follow the procedure, but at the end, it tells me Word cannot find the data source. If I use Excel, well it works perfectly. What is the gig? thanks ...more >>

I can use a key in subquery, like Select * from Employees where key1 in (Select key1,from SalesPerson) But if I have two keys like Select * from Employees where key1 and key2 in (Select key1, key2 from SalesPerson..) The above is wrong, but how can I do it? ...more >>

Hi, I want one of the column in a table to not have duplicate values(it's Varchar) but it's not the primary key column which is a auto-generated id column for the table. Thanks, Alpha...more >>

Hi All, I hope I can explain this well. I have an sp that populates certain tables with historical data and I've scheduled a job (using EM) that runs this sp on the first day of each quarter. My question is, within the sp, if anything goes wrong, I do a rollback and issue a Return(5). Will ...more >>

We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran the DBCC Shrinkdatabase command last week. Now, the database is slow when I open one of the work orders. Do you have any recommendation on how to fix the slowness? Am I doing something incorrectly? I ran the followi...more >>

When the SQL Server SP4 was released I was informed it had some issues with AWE. Is those issues are still exist? Is it safe to installs SP4? My SQL Server installation left with default AWE settings (value of 0). Since AWE is not enabled, applying SP4 should not be any issue in my case. ...more >>

I'm writing a simle utility. I'm given two sql scripts. The first returns a result set from a database (database A). The second script uses the result set and executes sql using each row of the result set for another database (database B). Database A and B are NOT linked servers and they w...more >>

I am periodically getting the complaints that SQL Server is slow. As a performance improvements I decided to run the defrag utility. Never run on this server from years. How to know that defrag need to be run? How to prove there is an excessive physical file fragmentation on a Windows 2K? SQL ...more >>

Hi experts, What AD query I should run to encounter all sql instances registered and running in our domain? What tools I should use for sql instances search in AD? Any conserns queryng all AD? Thanks in advance ...more >>

Hi! Is SQL Server 2000, just a toy? Accordind validation tests it needs 30.000 connections to move 170 rows from Linked Server. Jack ...more >>

Tab1 and Tab2 has the following info.ID column in Tab1 and Tab2 has matching values. Tab3 should have the info as below. Tab1 ------ ID Val1 Val2 1 qqq sa 2 aaa fa 3 ddd we Tab2 ------- ID F1 1 A 1 B 1 C 1 ...more >>

Hi All, I have about 60 or so SQL Servers to register. I don't have the option of importing from another machine. I think I maybe able to do this via SQL-DMO but not sure how to get started. Does anyone have any ideas about doing mass SQl Server registrations? Thanks....more >>

I'm running SQL Server Development edition on my Xp SP2 machine and its having 'difficulties'... SQL Enterprise manager periodically loses connection to the local server and recently i tried to restore a reasonable size database using enterprise manager and kept getting timeout expired messa...more >>

In the event viewer: In Application Log properties, there are options on what to do "When maximum log size is reached." I set it to "Overwrite as Needed", but the next day it is changed to "Overwrite Events Older than 5 Days." Why does it do this and how can I make it stop? It has been g...more >>

I need to change the port number for a SQL Server DSN - is there a way to do this on the command line so I can have everyone run a batch file? I tried odbcconf.exe but it doesn't seem to allow for a port parameter? Thanks...more >>

Hi: I have a 10 GB log file that has remained exactly the same size even when database was only 2GB. Now database is 9GB. I noticed that log file was not alloed to grow in Enterprise Manager and that our recovery mode was full. My Questions are My SQL server recovery is set to full. What s...more >>

I am converting an Access DB to SQL2000 and opne of the queries uses the Format$ function. How should the syntax be for SQL? Access: Format$(TimeTrackerEntry.EntryDate,'yyyymm') AS EntryMonth...more >>

I have come across the error "INSERT EXEC statement cannot be nested" when trying to store the results of a stored procedure in a temporary table. I understand why this is happening - because there is already an INSERT EXEC in the stored procedure I am executing - but I need to be able to store...more >>

Hi, Since we upgraded from SQLServer 7 to 2000 we get deadlocks that we didnt get before. After upgrading we did a transfer of the database, rebuild indexes, update statistics. As much as I know, nothing has changed in our application code. Maybe someone can help? Here is an example: ...more >>

I have message (from DB CHECK job): DBCC CHECKDB (KXP) executed by NT AUTHORITY\SYSTEM found 10 errors and repaired 0 errors. Where can I read description of this errors? Best regards Wacek (sorry for my 'african' english) ...more >>

How can I move scheduled jobs and DB Maintgenance Plan from one server to another? Thanks Emma...more >>

I have message (from DB CHECK job): DBCC CHECKDB (KXP) executed by NT AUTHORITY\SYSTEM found 10 errors and repaired 0 errors. Where can I read description of this errors? Best regards Wacek (sorry for my 'african' english) ...more >>

We are trying to publish our VS.Net Report project and VS.Net is erroring out specifying that the IIS Site can't be contacted. When we browse to the IIS site and try to access the home.aspx page under Report Manager we receive a 404 error. We have ensure that the verify if file exists isn...more >>

Hello, I am using SQL server 2000 with SP4. I am running create table and index as below CREATE TABLE dbo.ttcmcs045777 (t_creg CHAR(3) NOT NULL,t_dsca CHAR(30) NOT NULL,t_Refcntd INTEGER NOT NULL,t_Refcntu INTEGER NOT NULL) ON TEST CREATE UNIQUE CLUSTERED INDEX Ittcmcs045777_1a ON dbo.ttc...more >>

Hi all, I like to access a production database server from my development database, I need to count how fast one table in the production table grows, is there any way to do it without actually getting on the production server? linked server? Thanks....more >>

Good morning all, I want my server restart every sunday at 12 am, is there any one knows how to make the schedule (in Windows I believe)? Thanks a lot....more >>

The DCMARCH1.ldf file got corrupted I only have DCMARCH1.mdf file. I have a full-backup on tape. space required on disk is 98GB and space available on disk is just a little bit more (maybe couple of mb's) than 98 GB. When doing a restore from tape I can see the 6 GB Mdf file being created a...more >>

Hi, I'm trying to copy the data of a table into another table in another database. I.E. Copy contents of database1.table1 into database2.table1 I've got a table in database2 that lists the tables that need to be copied. I'm running a store proceedure that reads each record in the table a...more >>

Hi I have to run EOD i.e End of Day, a VB 6.0 Application(ADO 2.6) with SQL Server 2000 I want to lock the Database, full/complete Database, there are more than 100 tables so locking them one by one would not be the ideal solution(i think) the requirement is i - all currently logged i...more >>

Hi all! I'm trying to set the value of @d to a value from col1 in tblTest. I have tried the following code but it didn't work. DECLARE @d VARCHAR(25) SELECT * FROM tblTest SET @d = tblTest.col1 Someone please help me! Thanks! ...more >>

Hi all, Can anyone tell how to join two tables where first table is in db1 and second table in db2.. Looking forward for ur response.. Thanx in advance... ...more >>

Can I administrate a remote SQL Server 2005 from my machine after installing Native Client tools only? Is there any "Enterprise-Manager" like environment after installing client tools utility? I'm also running SQL Server 2000 on my machine. Any problems here or incompatibilities with 2000 and ...more >>

Hi group Working with backup exec 10, sql agent and advanced open file options included to backup our databases. We have 11 SQL databases varying in size from 200 to 5000mb. There is one new dbase which is the database for a website that is now not being backed up (size, approx 1.5 GB), thi...more >>

I have a database with 1 filegroup (PRIMARY), I have a backup of this database and I need to restore it to a different server but it should have 2 filegroup, 1 for each for each of my 2 drives. Possible? How? Thanks in advance -- .......more >>

Does point-in-time restore only for full recovery model? and if i use a full - backup then can i restore in any time or just the backup time? or if use transaction log , it can only to restore to the time of transaction log, can i restore one minutes before the transaction log...more >>

When i use point in time restoration, it show error STOPAT , restore og terminates why? and i can restore it without use point in time restoration!...more >>

Difference between Full recovery, Bulk-logged, Simple recovery...more >>

what is the difference between Full recovery, Bulk-logged, Simple recovery...more >>

Can we use form authentication with Reporting Service? Is it more convenient to do with form authentication if I use Report Viewer in webapplication? ...more >>

I can Install SQL Server 2005 (not Express) in Windows XP But I can't find Reports Virtual Directory in IIS. Can we install reporting(Sql2005) Service in XP? ...more >>

I did a DTS insert from a .CSV file and loaded 10 million records into a table. I am doing a full text index on 3 columns in the table. The full text index has been populating now for 24 hours continuous. How can I tell if it's hung, or is it possible that it really takes that long to run? ...more >>

Hi all group I can't post any comment in my MSDN GROUP (spanish): http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsoft.public.es.sqlserver&SLCID=ES&sd=GN&id=fh;ES-ES;NEWSGROUPS Always send me an error like this: "Sorry, the page you requested is not available...more >>

I have users who are running large SELECT type queries in Access against a SQL Server via ODBC. What happens is that the c:\documents and settings\<username>\Local Settings\Temp on the SQL server itself gets filled until the drive starts running low on space. Other than to free up space ...more >>

I cannot get the following stored procedure to accept dates in the format dd/mm/yyyy. alter proc usp_test @FirstName varchar(30), @DateOfBirth datetime AS set dateformat dmy INSERT INTO tbl_test ( Name, DateOfBirth) Values ( @FirstName, @DateOfBirth) GO exec usp_test 'D...more >>

Our current system is dual 2.4GHZ Xeon with 4 GB of RAM. Data is configured in a RAID-5 Array with 4 73GB Scsi Drives running windows 2000 server(not Advance). I ran bunch counter for 2 days. Looking at our peak times Memory: Page/Sec was between 80 - 90 (multiple hours at a time). It an inter...more >>