Using t-sql, what's the easiest way to append one table to another where the structure of both tables is precisely the same? Also, can this be set up to append only those that meet a certain criteria, such that a 'where' clause could be used for the append? Thanks for any help. Bernie Yaeg...more >>

I am trying to do something very simple, that is to reindex table in a database with the following command in SQL Query Analyser; dbcc DBREINDEX (activitylog, '', 0) I get the following message: Server: Msg 2501, Level 16, State 1, Line 1 Could not find a table or object named 'activit...more >>

I have an error like this : [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'. Can anyone explain to me ? what does it means ? How...more >>

How to determine if SQL server is Desktop Edition installation? How to do it remotely? T-SQL solution preffered (to be used with ADO)....more >>

If i have a query such as delete from table1 where col1 = 200 Say i had a non clustered index on col1 and thats the only index that i have... 1) Can the execution plan include a non-clustered index scan if the selectivity is low ? 2) If it does use a nonclustered index scan and maybe...more >>

SQL Server 2000, SP3a) Hello, all! We have several large tables (under a million rows) that seem to have a lot of "empty" space. When I do a: execute sp_spaceused MyTable There might be several hundreds of megabytes of space in the "unused" column. I thought that maybe doing somethin...more >>

We are running SQL 2K Cluster (sp3a with hotfix031) running on a win2k server. We have a Non system admin scheduled to run a dts package. The job runs succesfully on node2. On Node1 we are getting the following message A problem occurred while attempting to logon as the Windows use...more >>

Dear Group, Can someone please help me with this problem. I'm trying to add a new User to a particular database but keep getting the above error, telling me that the user already exists in the current database. When I look in the Permissions in the database Properties, the only user/rol...more >>

Dear subscribers, In SS 6.5 SP5a (NT4 SP6a) I got these: Descriptor for object '-2497' in database '2' not found in the hash table during attempt to unhash it. EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump ***BEGIN STACK TRACE*** 0x00405337 in SQLSERVR.EXE, getdes ...more >>

can someone point me to the Status code used in the master..sysdatabase TIA ...more >>

Hi This query is about using table hint WITH (LOLOCK) in select query. In the following 2 sql stmts using WITH (NOLOCK) hint after Table2(in SQL2)..would it increase the execution speed of the query in anyway? What is the best method to make a select query faster if query involves many t...more >>

Is there any mean to lock a database from all users in the way that nobody can: 1. read/write 2. write except one dbo (or some other user)? ...more >>

I have a web application which has been developed to use the SQL server's default language to determine the formatting of dates when stored. The SQL server language is set to English (United States), the sql users are set to British English and the workstations are set to use Regional Settings ...more >>

I posted this question long ago to several groups but it didn't generate a lot of interest so I thought I would try again. I have been looking for books on database design and or modeling but can't determine which method or approach would best suite my needs. I guess this comes from the fact...more >>

Ok, anyone know anything about MySQL? The only way I see to use data within tables for use in MySQL is to export as text file but I dont see a way to import the data from the MySQL Console Manager. Then my next consideration would be a query to create the tables and insert it into te MySQL datab...more >>

I have a VB 6.0 project that uses ADODB. Friday, it worked fine; Monday it started generating the following two errors, one right after the other in the order in which I've listed them: -2147217885: Cursor operation conflict 2147217887: Multiple-step OLE DB operation generated errors. Check...more >>

Hi all, at the end of the germany daylight saving time we turn the clock back from 3 a.m. to 2 a.m. But what happens, if we need to restore a LOG archive and the SQL Server will find during the restore older transactions? Could the SQL Server handle it? Or is it recommended to shutdow...more >>

[298] SQLServer Error: 207, Invalid column name 'job_id'. [SQLSTATE 42S22] (ConnCacheAlerts) I get the above error in my sql agent log. Do I have a corrupt msdb? Any ideas on repairing this issue? ...more >>

I have a stored proc where I want to pass a path as a parameter and then concatenate that parameter with a known file name in a BULK INSERT statement within the stored proc. I have tried various things and end up with errors. How is this done? Thanks, John ...more >>

In Performance Monitor, I can't see any of the "SQL Server:*" in Performance Object field, but the database runs fine. What happens? Thanx. ...more >>

Hi people, I have a big problem here. I have one database with the following configuration: 1- Primary FileGroup - teste.mdf 2- Secondary FileGroup - teste.ndf My trouble is: I lost my datafile that belongs to Secondary FileGroup. I don´t need to recover my data in teste.ndf, ...more >>

Why would i change the Reserve Physical Memory setting in SQL? ...more >>

Hi, Is there a need to backup the master database with my other databases? Hagay. ...more >>

please, i am receiving an error in log shipping of sql server 7.0. the message is "could not redo log record..." i found this message at microsoft, and it says that it is a bug that ocurs when toy make index operations in the same time you are making log backups. it talks about a fix, but i...more >>

I'm trying to use the CDW to copy a database from sql 6.5 to sql server 2000 from the 2000 server. Somehow, whatever password I use doesn't seem to work. Is there something wrong I'm doing? Does anyone has any idea on what I should do?...more >>

Hi, all I setup an alert in sql7 that sends me an alert if the DB size rises above 8.5 GB. I check db allocation size is 8.5GB and data size is 6.5GB. means 2GB free allocation space available. But the Alert keep sending me warnings : The SQL server performance counter 'Data File(s) Sizes(...more >>

...more >>

Hello, I've some doubts about the best backup/recovery strategy with MS SQL 2000. I want to perform a full backup once a day and then every hour only backup the log or differential. But exactly here's my problem. Should I better use: 0 - dump database abc to disk="abc.mdf 1 - dump log abc ...more >>

I am running SQL 7 Standard on a W2K server, both at the most current service packs. After applying the lastest security update to Windows and rebooting the server, SQL has suddenly fogottern its name - SELECT @@SERVERNAME returns NULL. In conjuction with this loss of identity, various mai...more >>

Hello all... Not sure if this is the right location to ask or not could not find a "Great Plains" newsgroup. Any way here goes We are looking into maybe purchasing Great Plains which utilizes Sql Server. One of the other guys here found a document called "Microsoft Great Plains Hardware Recom...more >>

I have a job set to execute every 3 minutes. Only one instance of the job should be running at any given time. If execution time exceeds 3 minutes - job should not start. Currently I have a flag in a user-defined table that is set to 1 by the SP that is called by the job when it begins, and r...more >>

Hi, I'm using SQL Server 7 and I need to make a view using 2 sources for my data: One source is my actual SQL Server Database and the other source is an Access Database. Is it possible to make connections between those two? Thanks ThunderMusic ...more >>

When I run perfmon against the sqlservr.exe process, its percent of processor time goes over 350% percent. Is this a bug in perfmon. If so, how do I report it? We are running a 4-cpu box, WINNT 4 with SQL2K sp3a. ...more >>

Hi all. I setup a scheduled job to copy a file to diff server on daily basis, exec xp_cmdshell 'copy \\NYC\FS\TEST.RPT \\nyc1\share1\ it overwirites everyday. How do I rename the file after copy or any other way that I could do to avoiding overwriting. Thanks, ...more >>

On occassion I have to set close to 100 seperate permissions on various objects, and obviously that gets tedious with enterprise manager. In my Oracle days I would 1) create a SELECT statement that prints out the GRANT statements 2) output the SELECT to a file, and 3) execute the file in t...more >>

Is there a way to move backup devices (i.e. BAK files on the hard drive) to a different hard drive? I am in the process of adding another array to a server and would like to move all my backup devices to this new array, but would like to not have to delete them and then recreate them one at a ti...more >>

I have an application to support in the future that will require a 600GB and larger database on SQL 2000. Does anyone have any recommendations on the best way to set this up for scalability and best performance. I'm new to databases of this size and need to make sure I can support it. Than...more >>

I have just finished my install of SQL2K on Win2003. I want to make a complete backup of the server. Do I back with the SQL services running, or do I stop them?...more >>

Hi, I have a database in full mode, can i issue a delete command that deletes a single row bypassing the transaction log??? Thanks in advance Miguel...more >>

Hi, Recently we upgraded from an Access database to a SQL Server 2000 database. Everything imported fine. However in our applications, we used to use an auto number field which was automatically incremented by Access. After import into SQL Server, the field with Autonumber got imported ...more >>

Hi All, I have the following case. I have two databases in the same server. First one: OTG second one: OTG_MA Both are backed up in the same drive with name as OTG.bak and OTG_MA.bak But I had the situation to restore the OTG_MA database from the OTG.bak file. When I used the...more >>

Recently i am having a huge problem with my SQL server 7.0 sp4 on Windows NT4.0 sp6. The SQL server service stops. When i see the event view i got the followind two events 17052 and 17055): 1. DATE/TIME: 29/09/03 6:30:04 AM DESCRIPTION: Error: 1203, Severity: 20, State: 1 Process ID 21...more >>

Hi, I am running SQL Server 7.0 on a Windows NT 4.0 server computer and the transaction log (LDF) file for one of the databases somehow got deleted. It happens to be the default connect-to database. Now when I try to connect to SQL Server, all I get is an error message telling me that I...more >>

I am using SQL 2000. Can I execute a DTS package from a stored procedure or from a TSQL script? Thanks....more >>

Hi! I have a view defined in MANAGE database as: CREATE VIEW dbo.sysdatabasesview AS SELECT * FROM master.dbo.sysdatabases WITH (nolock) GO Trying to place a trigger on it: CREATE TRIGGER sysdatabasesview$onDelete ON [dbo].[sysdatabasesview] FOR DELETE AS Declare @...more >>

In SQL 2000 I'm getting a timeout on updating a table. To get rid of the deadlock I'm checking the SysLockInfo table and killing all processes causing deadlocks on my table. However, when the job finishes the procedure is in error and when I run the task as an agent job the procedure work...more >>

There is a SQL Server 2000 running on Windows 2000 Small Business. About once a day SQL Server shuts down. Application log shows 2 errors: 1. SqlDumpExceptionHandler: Process 2088 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. and ...more >>

Hi, I've got a weird problem with SQL 7.0. I have to load several large textfiles into SQL 7.0. The files are 250 Megs +. I couldn't get the totals straight. If I summarize the CSV-files before I DTS the files to the SQL server I get a certain amount. If I then DTS the files to the SQL server...more >>

I've got some problems to get the transaction files under control. For example: I have a database wich is 1 gigabyte and the transaction log is 4.5 gigabyte Databases are made with automatically growth file enabled en recovery model set to full. I shrunk the database with the enterprise mana...more >>

Hi! I'm in big trouble. To make a long story short, I changed domain and after that can't access the SQL Server at all. I get this message: "A connection could not be established to GWEN - [SQL Server]Login failed -User:sa Reason:not associated with a trusted SQL Server connection" The S...more >>