Hello, While trying to backup SQL2000 DB thru VBS, I'm getting the followin error: -"incorrect syntax near '2' ". The DB name is sql2kdb, however, script works fine if the DB name has no numeric digit. Any help will be greatly appreciated. Thanks carlos ...more >>

Is there a way to copy a database without all the data? I want to end up with the same database but "empty". Thanks ...more >>

Hi, There is any way that I could compare tables' schema between 2 databases(prod and develop). or any free tools? Thanks ...more >>

Is there a way to query to find the user that the service account is running under?...more >>

Hi Everyone, I have a query that needs to pull data out of 3 tables. Nothing to hard so far. Here the query: SELECT Patients.PatientId, TERMINATION.DOA, TERMINATION.DOT, PATIENTS.PatientID, PATIENTS.LastName, PATIENTS.FirstName, PATIENTS.COUNSELOR, PATIENTS.MEDICAID_ID, PATIENTS.DOB, COUNSEL...more >>

I am trying to set up a linked server on a 64 bit Itanium SQL Server 2000 server to access a 32 bit SQL Server 2000 server. When I run a query in query analyzer accessing the linked server I get the error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' reported an er...more >>

I'm unable to shrink my log file. The databse is about 2 GB & the log file has grown to 11.5 GB. I've run transaction backups every 3 hours, but the log won't shrink. I need to reduce the size, to free up space on the drive. I've tried to shrink the file & it says it is successful, but I canno...more >>

what we got 31 columns most varchar(50) some even varchar(max). Data in those large columns are not huge however the datatype of max is desired for text search possibilities. 2 columns as the primary key 95,000 records total. Select and Insert statements are very quick and we have no troubl...more >>

SQL2K SP4 Howdy all. I'm using OSQL through a .bat to run a bunch of Insert/ Update/ and Delete (IUD file) commands. I call the .bat from a Stored Proc (SP) on the Destination SQL Server. Here's the configuration: Location1; 1; Destination SQL Server. 2; Fileshare server that holds the .ba...more >>

Quick question. DB in Full recovery mode. Last full database backup was at 1am, last TLog backup was at 2am. At 3.30am Drive containing .mdf fails, drive containing .ldf is OK. If I restore the 1am Full backup and the Tlog backup from 2am, is the .ldf file from the other working drive any...more >>

I have a simple database with two tables. Table "A" contains approximately 1.75 million records, increasing approximately 150K records per day. Table "B" contains approximately 260K records, increasing approximately 5K per day. I don't believe these numbers are excessive. I have an unremar...more >>

We have been writing a nightly bak file to our backup server without a problem. We are now getting Error = 5 Access is denied. BACKUP DATABASE [ABCDE] TO DISK = N'F:\LNCENTER\C$\AURIOBAK Backup files\MP100BACK.BAK' WITH NOINIT , NOUNLOAD , NAME = N'MP100', SKIP , STATS = 10, NOFOR...more >>

In short, we are sending several statements to the database from one source (my application). When this application is running nobody else will be accessing the database. If I do a table lock isn’t it still releasing that lock after each statement? I ask because each update I send to the d...more >>

I know I should know the answer to this question, but unfortunately I do not. We have a SQL Server 7.0 production database (will be upgraded soon). I am attempting to restore this database in my development environment which is running SQL Server 2005 developer edition. The restore appeared ...more >>

I've been using SQL2k for awhile now and have a VS2005 project I want to deploy with SQL Express. Anyone have a link to the shortest, easiest method of deploying everything needed? ...more >>

My company has a software designed in Visual Studio 6 using DAO and ODBC, this software is opening too much connections to SQL Server and maintaining them openned during too much time. So, how can I kill the inactive connections using T-SQL? ...more >>

I'm trying to run this query with an ASP script SET DATEFORMAT dmy declare @d datetime set @d = '30/06/2006' select * from orders where @d between start_date and end_date although get the following error. Operation is not allowed when the object is closed. The odd thing is it runs w...more >>

Hi, I have Clustered SQL Serevr instance named BOLLEANSQL. when i try to connect it through EM it shows me an error. " Connection couldnot be established to BOOLEANSQL. Reason: Timeout Expired Please verify SQL Server is running and check your SQL Server registration properties (...more >>

Hello, I need to install a MS SQL 2000 Cluster server which will include 2 nodes (setup as standard). Where can I find a step by step documentation about that and hardware/software requirements? Thanks, Don Diego...more >>

Hi Folks.. We have a transaction based system on our main SQL Server. Currently we are finding that this server is having resource issues due to the reporting system also accessing this main server. We want to implement a second server that the reports will execute off. It seems there ...more >>

How do you re-index in SQL 2000? Thanks. ...more >>

Hello all, Running windows 2003, SQL 2000 on a 2-node cluster. Every 3 days or so we get the following error: ClusSvc 1055 Cluster File Share 'xxxx' has failed a status check. The error code is 1450. All share resources fail and we have to fail over to the other node manually. We h...more >>

Hi , Is it possible to get the user's permissions to each table i.e user can select , delete , insert , update , execute , DRI what does DRI means and what is it used for ? and also it it possible to get the permissions up till the column-level ? what are the tables that these info are...more >>

I installed the SQL Server 2005 Express edition in my XP system. Is there a tool like Service Manager in SQL Server 2K that enable the manual control of starting and stopping the Express Server? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606...more >>

I have a new Windows 2003 64-bit server on which I'm running a 32-bit SQL Server 2000. I backed up the database on the old (Windows 2000 SQL Server 7) server, copied the backup file across the network, and restored it on the new server. I'm finding in some cases that I'm getting very, very p...more >>

SELECT * FROM OPENQUERY(ADSI, 'select * from ''LDAP://DC=PI, DC=GLOBAL''') Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "select * from 'LDAP://DC=PI, DC=GLOBAL'" for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI". ...more >>

Hello, I'm trying to use ActiveX from SQL to save an Excel file. I use the following code: Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Open("C:\Report.xls") ' make some changes here to the file ... xlWb.Save Since the file already exist and I am maki...more >>

Hi, Hopefully someone can point me in the right direction on this one. I'm running a Windows 2KSP4 server with SQL 2K. My problem is when I try to install SQL SP4 on this server I get the following error "A service control operation failed for MSSQLServer service 1460. This operation ret...more >>

Hi All, I'm not sure how to approach this problem so if anyone could advise me how to do it I would be very grateful. I have an app that calls a web service. The webservice returns an array of business objects. So I have a collections of objects that might be, say, 10000 objects in si...more >>

I'm a little uncertain of which SQL Server 2005 exams provide which certifications. I think this is the complete list of database related exams. 70-431 Implementation and Maintenance 70-441 Designing Database Solutions 70-443 Designing a Database Server Infrastructure 70-444 Optimizing an...more >>

I have a mini .net application that I have created to make some pretty complex transformationsdatabase. All the code, .net datatables and logic etc takes 3 minutes to run on the entire database. However, when I put in the update statements the same process takes 3 1/2 hours! So I know its ...more >>

Hi all, I am running a DTS script on a SQL server installed in 2003 Enterprise edition environment. When I run the DTS package, I get this error: Step 'DTSStep_DTSExecuteSQLTask_4' failed Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description:CREATE DATABASE f...more >>

Hi, I have a database. 200GB. I need to do reindex. --- there is any way that I could estimate the time that it need to complete the reindex? Thanks ...more >>

I want to write a stored procedure that accepts any number of strings and returns a table that contains any record that contains any of those strings (in a certain field). How would I do this? For example, if the Procedure was passed "KS", "NY" it would return all customers that live in th...more >>

Thanks to those who responded earlier. If someone would check my commands below, I would appreciate it. Again, what I tried to do is create a new database from an existing template database. To do this, I tried (in Enterprise Manager) to restore from the template to a new database name. ...more >>

I've got SS 2000 on Win 2000 and need to do some o/s scripting to interact with HP Openview for monitoring purposes. What I want to do is 1) pull the location of the temp mdf using sp_helpfile and then 2) feed that into Openview or just get the size directly using sp_spaceused and feed that i...more >>

My company has no DBA, and we are running PeopleSoft on Windows Server and SQL Server 2000. I have worked with the PeopleSoft Customer Support and have not found a PeolleSoft answer for this issue. I am posting here to see if by chance it could be a SQL Server issue. We have 8 PeopleSoft ...more >>

Recently we lost our DBA. When trying to restore a database from one physical server to another, the master will get updated, correct? We are doing a restore audit on our databases / SQL 2000 SP3. The plan was to restore from tape to a server which worked BData_Bat.BAK was the restored databa...more >>

I tried to use the Activity Monitor in my SQL Server 2005 Managment Studio client to see if I could monitor activity on a SQL Server 2000 instance. I received the following error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested d...more >>

Hi! How do we enforce Sql authenticated logins, the domain password policy? It looks like by default (once you check the enforce policy box during new login creation) it uses password policy of local machine, not the domain policy. My server is in the domain and its running Windows 2003 sp1 a...more >>

Hi, My production DB transaction log has grown to 25 GBs. (It was <8 Gbs yesterday). DBCC Reindex was issued against all tables as part of monthly DB maintenance. Since then I have performed a full DB backup, have performed log backups, then performed log backup with truncate only option,...more >>

I have a couple of sites that are running MS SQL 2000 Service pack 4 that are stopping (apperantly randomly) and restarting itself. This is causing great havoc on some of my applications that are attached to this database. The server is dedicated for this purpose only and is hosting only on ...more >>

I need to log user disconnects for a specific DB. I do not know how to do this relabily. The application owner is under the impression that our SQL cluster is disconnecting their users. Which I am fairly confident is not the case. Any ideas on how to do this? Specifically disconnects that ...more >>

Hi! I've got a problem with several databases on my SQL 2000 Ent. Cluster. The integrity of the DB structure seems to be breaking away. A user called me because he was missing some data he just inserted into the database. I then asked some other users and they had the same problems with ...more >>

We are using 26 databases in our Sql server 2000 on a fast machine. When we try to access our sql server from intranet with Enterprise manager its so slow on opening databases list or getting list of tables etc. How can we speed this up? Our machine has 3GB memory and 3Ghz cpu speed with 1MB c...more >>

I change pipe name in Configuration Manager and restart serwer. But mew = = name is wrong, and server can't start. I try go back to old values, but if i try start server, its faild and = parameters are restored to wrong wersion. My serwer work in failover cluster. error messages from...more >>

Hi! I'm trying to set up a new Maintenance Plan for a new MS SQL Server 2005. And would like some input on my backup plan. Background The server is a database development server where databases are added and deleted on a weekly basis. All the newly added databases has to be backuped with...more >>

Hi, I have an application on my LAN that connects to a SQL web server. The web server allow limited IP to connect to it to run stored procedures. I have recently found out i may also need to expose the Distributed Transaction Coordinator to these limited IPs. Can someone explain to me wh...more >>

Is there some database option in SQL2005 how to suppress Informational Messages ? I don't want that SQL SERVER 2005 sends informational messages -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1...more >>

The partner transaction manager has disabled its support for remote/network transactions. I have tried this but did not work: First verify the "Distribute Transaction Coordinator" Service is running on both database server computer and client computers 1. Go to "Administrative Tools >...more >>