We've got a SQL Server 2000 to store the data. There are 2 offices, Office A and Office B. The primary server is hosted in office A and staffs in both Office A and Office B can modify the data in the system. We are planning to setup one more server in Office B in order to improve the performanc...more >>

I'm interested in writing a program that makes craete scripts for all views and stores procedures in a sql server 2000 database, like the ones you can get them from the Query Analyzer. Can I retrieve these create scripts using some SQL statement? Or do I have to use some special MS SQL Server ...more >>

We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now we are facing a strange case where when we tried to restore and overwrite a database, it always say database is in use and cannot be overwritten. I have tried to detach and even delete it but everytime it just said the ...more >>

I currently am trying to create a new account under security and logins but the option is greyed out. I am currently logged in as a Domain Admin. What am I doing wrong. Sorry if this question is a stupid question but I'm trying to learn SQL. Please help......more >>

Hi, We've been getting some deadlocks on our production box. I've turned on the 3605 and 1204 flags and I've found an error in the errorlog: I think the key lines I'm concerned about are these: Process 1 -> PAG: 7:1:784316 CleanCnt:2 Mode: IX Flags: 0x2 Proces...more >>

Using the dm_exec_query_stats in 2005, I know I can get the number of executions for a particular sql_handle, but is it possible to get the number of execs for a SQL in version 7 or 2000? Also is it possible to get reads/writes/etc in these early versions? Thanks. ...more >>

Using the dm_exec_query_stats in 2005, I know I can get the number of executions for a particular sql_handle, but is it possible to get the number of execs for a SQL in version 7 or 2000? Also is it possible to get reads/writes/etc in these early versions? Thanks. ...more >>

I am building an application with a SQL Server 2005 Express backend. I would like to create a secondary instance the database on another server that will serve as a fail-over in case the primary server goes down (there is only the Express version of SQL Server in this picture). I see that rep...more >>

Hey Guys, Does any 1 have the roadmap to MCDBA? If you have the document, please send me a link where I can download or please email the document to seelanr@hotmail.com Thanks ...more >>

I have an MSDE Suspect Database and I believe that it is suspect do to the 2 gig limit. Because the mdf is 2,034,112 KB. So I have shutdown MSDE database and copied the data files over to a SQLServer Standard database and have attempted to Attach the database files. But when I attach them I ...more >>

I have a database that for some reason has started requiring me to use the owner when refering to a table. Is there something I can do to make it stop doing this? There are no duplicate tables with different owners. I am running SQL 2000sp4 on Win2K3. Thanks ...more >>

I use a stored procedure to populate a table and it truncates the value to one character for the field eMail. you have an idea what is the problem? i have to say also that I have tried this and it works: INSERT VH_Data_NewsEmail (Id, eMail) VALUES (@IdMaxPlus, `string`) So it looks like t...more >>

I was wondering if anyone can point me in the direction of documentation on Best Practices for SQL Server service accounts. We have applications in our environment that utilize the service account password. After finding this out, I’m changing the account and it’s password to prevent our...more >>

Hi all, I'm somewhat new to managing an SQL Server installation. I've noticed that the log files for my database are getting quite large. The amount of actual data is quite small because a lot has been deleted recently, but the log files are now about 10 times the size of the actual data ju...more >>

Hello, Have a few questions regarding SQL Server 2005. (a) What is the maximum number of SS2005 instances that can exist on a single server. (SS2000 it was 16)? (b) What is the maximum number of active connections in SS2005 on Windows 2003 DC? (c) Processor and Memory affinity. Can these...more >>

I am defining a schema as below that basically defines a custom type. ************* create xml schema collection IntTypeDefinition as N'<?xml version="1.0" encoding="UTF-16" ?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="inttype"> <xs:restriction base="xs:po...more >>

Hi, I want an SQL Server errorcode to trigger an alert that will send an message to an operator. The message has low severity level so it does not get written to windows event log and therfore does not trigger an alert (at least it didn't for me). In SQL Server 2000 you could edit system me...more >>

How replication can be parameterized, let me clear what actually I want. From publisher side I want specific records synchronization with subscriber by passing parameter against that parameter publisher will fetch the records and replicate that records to subscriber. Is it possible in SQL Serve...more >>

I have just installed SQL 2005 standatd sent out with the MSDN Having installed everything ( I went into Advanced and ticked all options) I can not find Business Intelligent Development Studio. Have I missed something obvious? I got no errors. ...more >>

We are facing this error when we are trying to enable transactions on our DTS Package. We tested this by using ODBC Driver directly. It works. But when we are trying to use Linked Server, we get this error. Anyone pls help. ...more >>

We are going to be migrating an application and the first step is to migration the Sybase database to SQL Server 2005 database. Can anyone shed some light into this and help me understand the process involved? What are the possible pitfalls? What should the approach be? Thanks, Newbie...more >>

I enabled publishing on the SQL 2000 box so that I can do replication from 2000 to 2005. During the wizard setup, the 2005 subscriber gets this error: ----------------------------------------- Cannot connect to Server1. Additional information: Failed to connection to server Server1 (Microso...more >>

Hi, I have two database on my SQL Server 2000 (db1 and db2) I try to transfert some tables from db2 to db1 with Data Transformation Services, And the Copy Object options but after the wizard, the tables don't appears on db1. The tables I want to transfert don't exist on db1 What I do : ...more >>

How do I change schema on multiple tables ? ...more >>

Hi, I have my DAC enabled and I also configured remote access connection using sp_configure but i am "getting Dedicated Administrator Connection is not supported" error when i try to connect the instance from local instance where i try to use the DAC. Any clues appreciated. TQ...more >>

Hi, I've two sql Agent Jobs that are failing during execution on a SQL Server Enterprise Edition (64-bit) platform. If I run the same jobs manuyally everything runs fine... The error log contains the following error: [298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYST...more >>

Hi, I have an IBM x365, with RAID 5, Windows Server 2000, SQL Server 2000. I get this error on a Random basis, where it says that the Write on 'database name' failed, status=2. See the SQL server error log for more details. When I start the Backup it does for about 60% and gives this er...more >>

Hi, I'm attempting to use a UNC path within a Database Maintenance Plan, and receiving a 'cannot create' O/S error. The maintenance plan accepts the path to the server/share, but the subsequent SQL job fails with the above error. I believe maintenance plans can't use UNC paths. Is this true?...more >>

I played around with a SQL Server 6.5 evaluation copy a few years ago, but never had a chance to get involved enough in it to make myself professionally useful. One of the first things I dealt with after a day or two was login/password issues. Somebody eventually suggested using the string "sa...more >>