The sql-server-2005 tag has no wiki summary.
0
votes
0answers
9 views
SQL Server Table Size Discrepancy [migrated]
Hopefully this has a simple answer and I've missed something obvious. I have a table where the number of rows * the row size is much smaller then the actual data space used by the table.
If I run the ...
1
vote
0answers
7 views
Merge replication sync fails after ALTER TABLE… NOT NULL [migrated]
We have a SQL Server 2005 database that uses merge replication to sync to SQL Compact Edition subscriptions. We added a column to a table using:
ALTER TABLE Shifts ADD COLUMN StateOrProvince NOT NULL ...
0
votes
1answer
9 views
How to restore from SQL Server 2005 backup
I ran a backup of my SQL Server database using the backup utility in the Server GUI. The backup works fine and I can restore on that machine without issue. I cannot, however, restore the backup on ...
3
votes
0answers
37 views
Repair mssqlsystemresource.ldf
I accidently deleted mssqlsystemresource.mdf and mssqlsystemresource.ldf.
I undeleted them both, but the .ldf file is corrupted (bad FGID), and because of this I can no longer start up my database ...
-1
votes
1answer
18 views
SQL Server 2005 SP4 & VS 2005
We have SQL Server 2005 SP1 currently and VS 2005. We're planning on installing SP4 for Sql Server 2005.
Question: Are there any specific requirements for this install or known negative effects that ...
1
vote
1answer
34 views
What does SQL 2005 do with a dll provided when you register an assembly?
We inherited a legacy SQL 2005 database. Two assemblies were setup to be used by triggers in one of the databases (ouch). The folder/files were delted by mistake. They were installed by a previous ...
0
votes
1answer
99 views
SQL Server 2005 SP3 Failover Cluster Node Replacement Service Pack
2-node SQL Server 2005 SP3 (9.0.4226) Failover Cluster running on Windows Server 2003 R2 x64 SP2. My passive node suffered a RAID failure on the OS partition. I evicted the failed node, rebuilt it, ...
0
votes
1answer
19 views
High MSSEARCH Wait Type in SQL Server 2005
This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem.
The server had been running with no problem for several weeks until the other ...
0
votes
0answers
16 views
Sudden reduction in full backup size [migrated]
I recently repaired a single corrupt page in one of the tables in a 70gb database.
I had a backup which included the data contained in the page so I went about using DBCC CHECKDB with ...
0
votes
1answer
91 views
how to set up an production environment with .net 3.5, iis6, sql server express 2005 on windows server 2003?
I have a clean installation of windows server 2003. This will be my production environment.
I need to deploy an asp .net 3.5 project on this production environment.
But I don't know the installation ...
0
votes
1answer
28 views
Giant SQL Server 2005 transaction log, don't understand why
My SQL Server 2005 database is having a giant transaction log. The MDF file is 11MB. The log is 1.5GB. Shrinking didn't release much space (9%). I already killed all my connections so I guess ...
0
votes
0answers
7 views
How to check a properties for all replication on a server?
I have 15 database some of which are replicated.
Sometimes the replication on all clustered indexesfor all tables of one of my replication change its value to False.
I'd like to know if there is a ...
0
votes
0answers
16 views
Mirroring after restoring the database on a new machine [migrated]
We've had alot of problems with one of our database servers and two days ago the call was made to change a disk and reinstall the OS. Now this server functioned as part of a mirroring setup. Basically ...
1
vote
0answers
19 views
SQL 2005 Named Pipes Stop Responding
We have a SQL 2005 64bit SP2 server running on Windows 2003 R2 SP2. It also has Reporting Server installed and that serves as it's primary function.
Over the course of approximately a week, ...
0
votes
0answers
16 views
I'm trying to import from a table of a password protected Ms Access database by using
In Microsoft SQL 2005
I'm trying to import from a table of a password protected Microsoft Access database file, by using OPENROWSET command, but it's not working.
here is my code:
INSERT INTO ...
0
votes
1answer
17 views
SQL Server 2005 to Mysql Replciation DATA duplication
I set up Replication between SQL Server 2005 and Mysql 5 using following articles :
http://ratecontrol.blogspot.com/2010/12/one-way-transactional-replication-from.html
and
error setting up ...
0
votes
0answers
11 views
SSRS Dynamic Column Header Tabular Report from a Pivot Query
We need to create a tabular report in SSRS that uses data in a pivot query. The column headers in part or all of the table need to be defined when the report is created. Is there a way to do this in ...
1
vote
2answers
113 views
Distributing SQL Server on Internet regarding security issue
We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
1
vote
0answers
81 views
performance of Sql Server decreases as I add more vCPUs on ESXi 5 [closed]
Possible Duplicate:
Optimising MSSQL 2008 server inside VMWare ESXi
I have an 8-core system (two quad-core Xeon processors) with 8 GB of memory running VMware ESXi 5.
I have 3 VMs ...
1
vote
1answer
99 views
How to use AWE for Windows Server 2003 (32-bit) and SQL Server 2005 (32-bit)?
The server is Windows Server 2003 SP2 (32-bit), running SQL Server 2005 SP3 (32-bit). I believe the server has 4 GB of physical RAM. The machine has crashed twice in the last week and it is a ...
0
votes
2answers
45 views
NT AUTHORITY\SYSTEM cannot login to SQL Server 2005 databases
A custom service which runs as Local System on a Windows Server 2003 server needs to login to a database running on a local instance of SQL Server 2005. SQL Server services runs as Network Services, ...
0
votes
2answers
32 views
Native SQL logins timing out at login validation phase
The default SQL Trace of my instances shows the following issue for native SQL logins (non-domain accounts):
Network error code 0xe8 occurred while establishing a connection; the connection has ...
1
vote
1answer
47 views
SQL 2005 AD Group permission levels
I'm trying to give permissions to a (sql 2005) database app based on AD groups. The general idea is to require a user to have a membership to "app_users" to view anything, and membership to other ...
0
votes
1answer
103 views
Connect to SQL Server 2005 In Different Network
I need a help on SQL Server Remote Connection Issue.
I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which ...
0
votes
1answer
39 views
MS SQL Hardware Configuration
About to order a replacement mirrored database pair to drive our multi-user web applications and looking for some guidance on some aspects. I have read various feedback on other posts but finding it ...
2
votes
3answers
73 views
Optimizing Disk I/O & RAID on Windows SQL Server 2005
I've been monitoring our SQL server for a while, and have noticed that I/O hits 100% every so often using Task Manager and Perfmon.
I have normally been able to correlate this spike with SUSPENDED ...
0
votes
0answers
22 views
Large Buffer Pool Size in Memory and the page out issues in Sql Server 2005
When using Sql Server 2K5,I find that the process "SqlServer.exe" sometimes occupy high memory usage and suddenly drop to a low value by monitoring the "Windows Task Manager".
And the "Buffer Pool" ...
0
votes
1answer
71 views
DHCP address leases to SQL Server database?
Is it possible to store the DHCP address leases in Windows 2003 to SQL Server database??
1
vote
1answer
41 views
Can I install a 32-bit SQL Server 2005 alongside a 64-bit SQL Server 2008 installation?
The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC ...
0
votes
1answer
29 views
Unable to administer WSS 3.0 using SQL Studio Express
I have a WSS 3.0 running on Server 2008 R1. The log files have grown to almost 15GB and need to be compressed/purged as we are running out of space on the hard drive. I have connected to the ...
1
vote
2answers
34 views
SQL 2005 Deadlocks: Running Traces & Examining Logs
We have a 3rd party commercial application which we believe is causing deadlocks to occur on our SQL Server 2005 (64bit) machine. Coming away from a 1 & 1/2 day training with the software vendor ...
0
votes
2answers
59 views
Restore database to SQL server 2008 from SQL server 2005
I need to restore my database to SQL server 2008. Currently we are having our database in SQL Server 2005 in one server. We need to take the back up of that database and move that database to SQL ...
0
votes
0answers
25 views
Orphaned SQL Recordsets/Connections with IIS
I have an IIS 6 site running on Windows 2003 Server x86 with MS SQL2005 Enterprise edition running ASP Classic (no choice). The site runs very fast with about 8000 page views per hour. All of my SQL ...
0
votes
1answer
121 views
SQL Server database connections being dropped intermittently
Occasionally in one of our production environments (we have a dozen or so without different clients pointing to each) we get exceptions at different points in the process. The code doesn't do ...
0
votes
2answers
37 views
SQL Server 2005 Express over LAN - Login Failed for 'Servername\Guest'
Posted my question here because I'm pretty sure it's less of a program problem and more of a Server problem.
I'm developing a C# program that will access a database on a server. If I run the program ...
0
votes
1answer
34 views
Does Sql Server Express supports MSDTC
I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions.
I googled on MSDN and haven't got clear ...
0
votes
1answer
18 views
Error Connecting to server with SQL Server Management Studio Express 2005
Problem logging in with SQL Server Management Studio Express 2005?
When I try connecting to a server in SQL Server Management Studio Express 2005 with Server Name as PC-Name\MSSMLBIZ\SQLEXPRESS or ...
0
votes
2answers
36 views
adding columns to table results in 'low disk' error message
One table of our database has large amount of data. It has about 20 million records. We need to add 2 new columns into this table.
We have 15 GB space on the drive.
When we start the process to add ...
0
votes
2answers
41 views
Install SQL Server 2005 on computer with an existing SQL Server 2008 installation
I have a Windows XP 64 bit workstation. I installed SQL Server 2008 R2 Standard x64. After that, I installed SQL Server 2005 Standard x64. Installation completed with no issues, but no instance was ...
1
vote
1answer
158 views
Schannell: Certificate received from the remote server was issued by an untrusted certificate authoritythe
i'm not sure whether to ask this on dba.stackexchange.com or here.
Periodically following error is logged in Windows Server 2008 Administrative events:
The certificate received from the remote ...
0
votes
1answer
46 views
SQL Server 2005 Management Studio Language Settings
I'm working with a Korean language copy of SQL Server 2005. I'm not familiar with the software so I have to match buttons by hotkey, comparing with screenshots from tutorials when my limited Korean ...
0
votes
0answers
26 views
Does Database Engine Tuning Advisor support analyzing XPath queries?
I regularly use DETA to tune queries in SQL Server 2005. But when trying to analyze a query that contains one or more XPath queries, the recommendations page turns all blank. Existing indices can ...
0
votes
0answers
28 views
SQL Server 2005/2000 Linked Server Problems
I have the following configuration...
ASP.Net 4.0 Web Application (AppServer)
SQL Server 2005 (SQL2005)
SQL Server 2000 (SQL2000)
I have a linked query which links from SQL2005 to SQL2000.
The ...
2
votes
2answers
28 views
MS SQL 2005 - Backup “being used by another process”
I'm trying to create a backup file of a database in SQL 2005. When I try to execute the backup operation I get an error saying "cannot access this file, it is in use by another process". Any advice ...
3
votes
2answers
21 views
Windows Cluster - Can I failover without disturbing SQL?
I have a 3 node cluster.
All of the nodes are part of Cluster01 in what should be A/A/P mode.
Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows ...
1
vote
1answer
16 views
Can BES 5.0 Express database be migrated from SQL Server 2005 Express to SQL Server 2008 R2 Express?
Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general?
If the database is backup ...
0
votes
0answers
29 views
SQL Connection Error
I am getting this error while trying to access my website:
Exception information:
Exception type: SqlException
Exception message: An error has occurred while establishing a connection ...
1
vote
1answer
71 views
Powershell SQL results comeback in hashtable i just need the value
I have the following script that runs a stored procedure and returns a value. The problem is it returns a hash table and using result.answer returns nothing. How can I get the value without the hash ...
0
votes
1answer
25 views
About SQL Server networking
I would like to connect from client PC to SQL Server over the internet. I have installed SQL Server 2005. Can you guide me. I am new to this.
0
votes
0answers
23 views
sp_reset_connection
We recently moved physical database servers from our corporate office to a collocation facility, and brought up virtual servers to replace the web servers. We are now experiencing periodic system ...
