This is a semi-crosspost - tried it on comp.databases.ms-sqlserver, but haven't made any progress. Meanwhile, I'm getting desperate....Client wants some changes to an app and I can't get the thing running. I guess my primary quesion has become: "How do I confirm that Provider=SQLOLEDB.1 us ...more >>

I am trying to create a flat file from SQL server and here is what my query looks like: bcp "select intakeid from tblintake" queryout d:\out.txt -c I got this error: "Line 1: Incorrect syntax near 'queryout'." when I run it in query analyzer. Can anyone please tell me what I did wrong?...more >>

Greetings. I'm trying to plan an upgrade of my current SS 7 installation to SS 2000 (Win2k3 OS environment). I've reviewed the docs on the various SS2k licensing models, but still have some questions about what my best option is. I plan to use a single SS2k instance in both intra- and ex...more >>

Hello All, Is there any assignment (kind of workbook) available for SQL Server? I have finished reading a book on SQL Server now I want to take up an assignment to practise the things which I have learnt. I will be very gratefull for any help. regards, Abhishek. ...more >>

I have a database on one SQL server. I have backed up the database and then restored it onto another SQLServer. I have the following SQL statement: exec myStoredProcedure 'stress', NULL,NULL, 1, -1 When I run it against the database on serverA it works, but when I run it against the...more >>

Hi and thanks for reading. I used to duplicate my production environment by doing a backup/restore every night. Today the restore failed with Server: Msg 3270, Level 16, State 1, Line 1 An internal consistency error occurred. Contact Technical Support for assistance. I am using MS-SQL 20...more >>

I have created a DTS Package on a new SQL 2000 SP2 Server running Win2K Advanced. I am trying to import an 11GB user DB from a SQL 7 NT4 Server, copying all DB objects, overwriting any existing DB objects in the destination server. I scheduled it to run when there were no users in either DB ...more >>

Hello I have a ML Proliant 350 with 2 Gigabytes of Physical RAM and configured with: 1 gig Virtual memory for drive C: 2-3gigs of Virtual Memory for drive D: I am running Windows 2000 Server w/ SP3, SQL 2000 with SP3. Can anyone tell me why the SQlserver.exe process is using 1.4 gigs of...more >>

We are implementing a history server that will mirror our production machine. Can anyone steer me toward articles on copying a full database. I would like to set up a job that will copy new data which we capture in our production database to our history server. On this box we will be ru...more >>

I have a process that can potentiall affect alot of records. I was testing this out and it seems that when I let it go on a large number of records it takes along time. The time it takes seem to start of linear until you get to a point and then it becomes an exponential increase in time. I was...more >>

HAVE A HAPPY AND A SAFE NEW YEAR MSW ...more >>

I have found that the Log File for my database gets bigger and bigger over time. At one time, it used up all my disk space so I had to detach and delete the db and reinstall the original db file. I went in and adjusted the size growth parameters for this db and setup a backup maintenance...more >>

I have two servers running SQLServer2K. With both of them stopped, I accidently copied one database file (and log) from one machine to the other, overwriting the database file on the 2nd machine. When I tried to restart and connect the 2nd server I get the following error: Cannot open...more >>

I'm running QA on my local PC and going through an ODBC connection, I've been able to connect to SQL servers on our network and execute TSQL statements. Suddenly, last week, the green button is grayed out. No matter what server. Everything else looks ok. All features in EM seem to work. I...more >>

Hi - I am a relative newbie to setting up and configuring servers so am a bit baffled by all the server techno-speak. My issue - I have a client who is based about 40 miles away who want me to do some database work for them. I am a freelancer and he is a small company who relies on a non sql ...more >>

Thanks for reading To work with a duplicated environment I do a full copy of the database and restore it on another server everyday Since yesterday when I try to restore the database the usual way, I get a message saying there is not enough disk space The message reads Microsoft SQL-DMO (ODBC...more >>

Hi A file has been generated in my MSSQL\backup directory called [myDB].ckp. It's only a 6K binary file, but I've no idea what it is. Any suggestions? Thanks Griff ...more >>

I've been trying to do this on and off for over a month, just can't seem to get it. I have a table that looks something like Name Activity ==== ======== Mike Arrest John Victim Fred Suspect John Suspect Mike Victim John ...more >>

I cannot figure out why my sqlserver uses that much VM. Ok, this server is no dedicated SQLServer, but it only logs machine signals (scada). I ran profiler and over an hour, it recorded 724 sp_cursoropen and only 670 sp_cursorclose statements. I hope someone can clarify what is goi...more >>

I am adding two 75 GB hard drives to my SQL server (mirrored). I want to move the contents of my "E" drive (all SQL databases) from its 8 gb partition to a new 40 gb partitiion on the new drive. Can this be done with a simple copy? Do I need to detach each of the databases (about 15 in al...more >>

Hi all, Happy New Year I' am having a problem with the attach statement. we normally detach the database, delete the log files, then run the attach statement like below: sp_detach_db @dbname='rms' sp_attach_db @dbname='rms', @filename1='e:\rms\retension.mdf' We do this s...more >>

I recently restored a database from tape. However when I go into SQL Enterprise Manager, I see the recently restored database showing "loading". I assumed that this was a good indication however it has been loading now for the last 12 hours. The database is about 17 gig. Is this normal or ...more >>

Is there an API or library available to directly monitor SQL Sever events? In essence, I wish to write my own SQL Profiler client to perform automated auditing tasks for our SQL Servers. I have a solution in place that utilizes scripted server side traces, but working with the generated ...more >>

Please Advice. I run a SQL 2K SP3 on WIN 2K SP3 Advanced in an Active/Passive Cluster configuration. I notice when I ran DBCC CheckDB on one of my Production databases the available RAM Memory decreases and fails to return on completion of the command. Please help. ...more >>

Hi Does anyone know where the physical location on disk of the sql server error log messages redisde and the System Event Viewer logs on a WINDOWS2000 system? Do they live anywhere as text files? I have a plan to ftp the text log files back to a monitoring machine for viewing. e.g. view...more >>

http://support.microsoft.com/default.aspx?scid=kb;en-us;179158&Product=sq I found the above article which shows a stored procedure for SQL Server 6.5 which documents all permissions for a particular Database Is there a way to document permissions on SQL Server 7 and 2000 instances??? Thank you...more >>

Hi, We have a 20 GB table, and because of this size, the query performance is getting affected. We planned to partition the table into 4 tables (5 GB each), so that the load on the single 20 GB table can be minimized. My question is, what is the best method to partition the table (with already e...more >>

Hi, I found this KB312839 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839 It works for sending out email from sql, but how can I use it to send a result from another query or SP? Is it possible to use it to send attachment? Here's the sample code for calling the SP and i...more >>

Are there situations at times when even after imposing query hints in your query, the optimiser might choose to override it ? Has anyone come across it or is it known ? Using SQL 2000 ...more >>

when i disabled the BULTIN/admin user in SQL 2000 i could start SQL Server service, but i couldn't start SQL Agent Service does anyone know how to slove this prob I also wanna know is it suitable to disable the BULTIN/admin user in SQL 200 than ...more >>

Hello, We have numerous SQL Servers that we backup using Veritas Backup Exec with the SQL Server Agents. We have changed all of our database backup models to FULL. We backup the transaction logs a few times through the day, and do a full database backup once a night. A few of our servers, t...more >>

I have a column of salary that is in money datatype and i want to format it so the $ shows up in my table???? Thanks S. ...more >>

Hi, I got this message "SQL server Alert System: 'Demo:Sev. 20 Errors" occured on \\xxxxx The description was 18453 The comment was (none) The Job Run: (none) I have not been able to find out whether or not this is something to worry about or if it is something that happens from time ...more >>

I had to uninstall a SQL Server 2000 installation. Before I uninstalled it I copied the Data directory to a different drive. After I reinstalled it I copied my user databases back to the new Data directory and re-attached them. My problem is I can not find a way copy the system databases back ...more >>

I know the select distinct TOP 10 returns top ten highest price items but what about top 10 lowest priced items??? Thanks S. ...more >>

I have several databases which have become suspect. I run sp_resetstatus on a database called "test" and this successfully resets the status. However, when I reboot the server and it tries to restore the database, I get an error in the error log: the LSN (85:208:1) pass to log scan in databa...more >>

Hello, Thank you in advance. I plan to buy SQL 2000. My situation is: two IIS boxes ( dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they are all running in Windows 2000. Those two IIS boxes have some other VB applications (<15) may access database. Question: which licence mode...more >>

We have a situation where a large DB(150GB) has mostly static data in it. We were considering a filegroup solution that locates the static data in one(or more) files and the dynamic content is stored in another but it seems that any file/filegroup restore requires a transaction log restore to compl...more >>

How do I tell if I've got 64 bit or 32 bit SQL 2000 installed? Thanks, Don ...more >>

I am getting following errors in log file. ======================================================== SQL Server Assertion: File: <"xact">, line = 2151 Failed Assertion = '!m_parNestedXactCnt' Trying to use the transaction while there are 13 parallel nested xacts outstanding. *Dump thread -...more >>

SQL Server 2000 Our server froze up and forced a reboot. When the server came back online, the database was no longer listed in EM as a database but the datafiles themselves still exist. In addition, it appears that SQL Server may still be "holding on" to the data files since when I t...more >>

Hi, I have a problem in that when I perform a "Select Count(*) from table1" I receive a different value than "SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table1') AND indid < 2". Is this to be expected? Can anyone help? Thanks, Joe ...more >>

I am not familiar with SQL Server 6.5 and need some help. The transaction log on our db will not truncate. I have tried the following: 1. Dump the db then dump the tran log. 2. Dump the tran log with truncate only. 3. Dump the tran log with no log. 4. Expand the tran log (This did not work...more >>

Hi I'm passing the following SQL statement to my SQLServer: RESTORE DATABASE myDB FROM DISK 'd:\mssql\backup2\myDB.bak' WITH MOVE 'myDB' TO 'd:\mssql\data\myDB.mdf', MOVE 'myDB_log' TO 'd:\mssql\data\myDB_log.ldf' However, when I run this, I get the following error: Server: Msg 3234, ...more >>

I'm currently evaluating SQL Server VDI or Named-pipes for Backup/Restore. One issue that I've come across with VDI (& Named-pipes) is that there is no way to send user-related meta-data while doing the backup. For instance, - If I create a simple VDI client and register my client. - I then...more >>

I have been having a problem with the microsoft sesarch service failing on boot up. All that I get from the event logs is: Event ID: 7009-"Timeout (30000 milliseconds) waiting for the Microsoft Search Service to connect." and Event ID: 7000-"The Microsoft Search service failed to start due to the...more >>

From a cmd prompt I am trying to DTS data out of an old version of Btrieve to SQL Server 2000. It does the work just fine. The last thing it displays is DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account] Step However, at this point it just sits there and never comes bac...more >>

sql2k sp3 The latest of my saga. Thanks again to Tom for all the help yesterday. Im trying ultimately to truncate a tlog on a replicated db. The sp_replicationdboption '<publicationdatabasename>', 'sync with backup', 'true' is on. So heres what happens. First some data modifications. Th...more >>

When setting up a DB Maintenance plan, what do users normally do with the options in the Optimizations tab? Does it matter what application is using the database? (In this case, it is Microsoft Business Solutions- Solomon.) Thanks....more >>

I am going to be using our SQL Server to manage a project database. SQL Server is installed on our Windows 2000 server using SBS. Currently there is a named instance "SERVER1\BKUPEXEC" that is being used by Backup Exec. Do I need to create a new named instance to use as for my database man...more >>