I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs:”There are multiple accounts with name MSSQLSvc/…..”
I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs: “There are multiple accounts with name MSSQLSvc/…..”

Answer Question   |  June 22, 2008  2:44 PM
SQL Server 2005, SQL Server errors

I am using SQL Server 2005, I keep receiving the following error message:The following error keeps occurring every 30 minutes in error logs. “The specified user account has expired”.
I am using SQL Server 2005, I keep receiving the following error message: The following error keeps occurring every 30 minutes in error logs. “The specified user account has expired”. Has anyone ever come across this error message?

Answer Question   |  June 23, 2008  2:42 PM
SQL Server 2005, SQL Server errors

Describing several performance monitoring counters
Could you please describe the following performance monitoring counters, what they mean and the range to which they are acceptable? Full Scans/sec Checkpoint pages/sec Transactions/sec User Connections Average Wait Time (ms) Lock Waits/sec Number of Deadlocks/sec Target Server Memory(KB) Total Server Memory (KB) Batch Requests/sec

Answer Question   |  June 25, 2008  8:16 PM
Performance counters, Performance monitoring, SQL Server

Installing SQL Server Enterprise Edition on Windows XP
I have two questions. First, how do I install SQL Server Enterprise Edition on Windows XP? And second, how can I find the SQL password without using an application?

Answer Question   |  June 19, 2008  8:13 PM
Installation, Password, SQL Server Enterprise Edition, SQL Server installation, Windows XP

Copying a SQL Server stored procedure with a query
I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?

Answer Question   |  June 19, 2008  8:11 PM
Query, SQL Server 2005, Stored Procedures

Archiving databases on SQL Server 2000
Could you help me to estimate how long it takes to archive 400 GB records from one of our test databases located on SQL Server 2000? Also, what would be the best approach?

Answer Question   |  July 4, 2008  8:02 PM
Archiving, Database, SQL Server 2000

Table size in SQL Sever 2000
Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

Answer Question   |  June 19, 2008  2:18 PM
Database, Database management, SQL Server 2000

SQL Server transactions in ASP code
Can we create sql server transactions in asp, if so how can we manage transactions in asp. Please suggest me, how to do it.

Answer Question   |  June 23, 2008  1:46 PM
ASP, SQL Server, SQL Server transactions

Stopping transactional replication from skipping a block of records
Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across just fine. Do you have any advice on either completely resetting the [...]

Answer Question   |  June 18, 2008  7:31 PM
SQL Server 2005, SQL Server snapshot backup, Transactional replication software

Implementing row level security in SQL 2000
Is there a way to implement row level security in SQL Server 2000?

Answer Question   |  June 18, 2008  7:27 PM
Implementation, Security, SQL Server 2000, SQL Server security

SQL Server DB Backup
Hello, I am a new member and would like assistance understanding why when I attempt to schedule a SQL Backup it doesn’t seem to stick after I close and reopen it. I am doing the following: Windows Server 2003 – Enterprise Edition/SQL Vs. 8 1. SQL Enterprise Manager 2. SQL Server Group 3. Open the [...]

Answer Question   |  June 24, 2008  7:04 PM
Backup, backup database, SQL Server, SQL Server backup

Consistent error occuring in SQL Server 2005
I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error [...]

Answer Question   |  June 18, 2008  5:29 PM
SQL error messages, SQL Server 2005, Windows Server 2003

Finding the appropriate settings for copying tables within databases
I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: “Could not allocate space for object ‘ChangeInsuranceTxnHistory’ in database ‘CC_CCAR’ because the ‘PRIMARY’ filegroup is [...]

Answer Question   |  June 18, 2008  5:14 PM
Copy error, Database issues, SQL, SQL error messages

rpg sql
I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option [...]

Answer Question   |  April 27, 2010  4:33 PM
Dynamic SQL, RPGLE, SQL

Eliminating duplicate rows in SQL Server 2000
I have a database I recently inherited in SQL 2000 that contains some duplicate rows. How can I identify the tables that have this problem (duplicate rows meaning ones that have the same “time_stamp” value, and “time_stamp” being used as a raw identifier)?

Answer Question   |  June 23, 2008  3:56 PM
SQL Server 2000, SQL Server database

Trouble opening an inaccessible table in SQL Server 2005
A client of ours is running SQL Server 2005 with PS2 on Windows Server. His database size is about 5 GB. Every now and then something happens and one table (the most important) becomes inaccessible. When we try to open the table, it gives a “SQL time out” error. This sometimes happens twice a day, [...]

Answer Question   |  July 1, 2008  3:10 PM
DBCC, SQL error messages, SQL Server 2005

Restoring SA access to SQL Server
I have somehow removed my SA permissions from my SQL server. I do not know the SQL SA password. Is there any other way to restore my SA access to SQL? I am a local admin on this server.

Answer Question   |  August 11, 2008  2:56 PM
Permissions, SQL Server, System administration

Syntax to reference a table on a database residing on another server
I have the following insert statement: insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID) select N’SS’,Social,Full_Name,DOB,DL_Number,N’TX’,Change_User,Change_Date,Change_PropID from N’haa-sql1.imisTest.dbo.Resident’ I’m getting an error on the N’haa-sql1.imisTest.dbo.Resident’ This string refers to the sql server that resides on the server named haa-sql1 (default SQL 2000 install), database imisTest,setup by dbo, table Resident. I’ve tried importing the table using the wizard. This doesn’t work [...]

Answer Question   |  June 20, 2008  10:14 PM
Distributed database, INSERT statement, SQL Server 2005

T-SQL how to identfiy tables that have dulicate roaws
I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

Answer Question   |  June 18, 2008  9:44 PM
SQL, SQL Server 2000, T/SQL

i have windows 2000 server and isa server 2000 and we have some problems one is when i connect cmd then the command is arp -a then ip and phisical add
i have windows 2000 server and isa server 2000 and we have some problems one is when i connect cmd then the command is arp -a then ip and phisical address show butt ip is different and mac address is same

Answer Question   |  June 17, 2008  11:33 AM
Address Resolution Protocol, Arp, ISA Server 2000, MAC address, Windows 2000 Server