The sql-server-2005 tag has no wiki summary.
1
vote
1answer
78 views
SCOM 2012 - SQL Server Monitoring
I have been tasked to see whether SCOM 2012 is the right tool to do the following which has been asked of me:
Find out what are the longest running queries
Find out the number of locks
Does ...
1
vote
2answers
39 views
Migrating to a new SQL Server machine: should master database be restored?
I'm currently working on a migration plan to migrate our SQL Server to some new hardware.
The current installation is SQL Server 2005 standard: it used to be clustered but the node got removed at ...
0
votes
0answers
12 views
Scripting database with condition
I want scripting database,and want to run that script on live database..But I want add some condition while creating script.For eg.I want to script data from 1or more table with condition.how can i ...
0
votes
1answer
22 views
SQL Server Expensive Select Queries from unknown source
When viewing Queries by CPU usage with Performance Dasboard, I notice a great deal of queries like "Select * from dbo.sometable". What is the best way to go about tracking the source of these queries? ...
0
votes
1answer
33 views
Execute Stored proc for 10000 times [closed]
I want to call a stored procedure for 10000 times and I want to pass different values for the parameter everytime.
Can some one help me to do that
For example
I want to call/execute " EXEC ...
2
votes
2answers
35 views
Cannot rebuild index because row above maximum size (Microsoft SQL)
I'm trying to rebuild a clustered index on a SQL Server 2005 table, and I keep getting the error:
Cannot create a row of size 8078 which is greater than the allowable maximum of 8060.
The command ...
1
vote
2answers
48 views
Stored Procedure taking more time to execute (Sql Server 2005)
I have a stored procedure implemented and calling of this stored proc from web page is taking more than 300ms,
But when write the script in the web page and call the url, it is executing in 50ms
...
1
vote
0answers
27 views
Full Text Search query elapsed time varying wildly
Database Version:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 ...
0
votes
2answers
59 views
How to move the files of a replicated database (SQL Server 2008 R2) to a different drive
I would appreciate if someone could help me with the following problem:
We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable ...
1
vote
0answers
50 views
What does the error message “Communication link failure (SQL-08S01)” actually mean?
Our application is running on dozens of servers and only a few get this error message. What is worse, is that the SQL query that causes this error message seems to be executing. The application is ...
2
votes
2answers
65 views
Why does SQL 2005 SSIS component install fail?
I am trying to install SSIS on our production SQL 2005 SP2 box. Each time I try, the install/setup screen results in failure, starting with the native client, and moving on down. Screen shots below ...
0
votes
0answers
31 views
implement weekly full & daily differential
Using SQL Sever 2005, this should be a trivial task, but I cannot seem to figure out how to set this up. I was able to find all sorts of guides on how to manually perform full and differential ...
0
votes
1answer
28 views
MSDTC - COMException
We currently have 4 load balanced web servers connecting to a SQL 2005 database server. On the web servers is IIS 6 which has our Dot Net web services installed and Dot Net COM+ components also in Dot ...
0
votes
1answer
32 views
Automate install of SQL Server 2005 Express Service Packs
Is it possible to perform an unnattended install of service packs (SP4 is the latest) on SQL Server 2005 Express?
The only way I have found is to download the SQLEXPR32.EXE containing SP4 and run it ...
0
votes
3answers
57 views
SQL Server claims that transaction log is full, but it's not?
I'm trying to do a large INSERT operation from a database to another. But I get an error message:
Msg 9002, Level 17, State 4, Line 1
The transaction log for database '_ARCHIVE_mydatabase' ...
0
votes
0answers
16 views
sql 2005 p2p replication, why does sp_helppeerresponses show a server that has been removed?
On a test rig, I have set up 4 SQL Server 2005 VMs to replicate a single db using peer to peer replication.
I removed one of those servers using SQL management studio, deleting the subscribers from ...
0
votes
1answer
57 views
SharePoint Sites go into read-only when SQL Server Backup is running
I have SharePoint 2007. When the database backups run using SQLCMD, SharePoint sites go into read-only. Users can't add anything to the sites and the buttons are grayed out. On the backend the ...
0
votes
1answer
43 views
dotnet framework 2.0 sp2 breaks CLR integration in SQL server
It appears that CLR integration does not like Dotnet framework 2.0 sp2. I am getting the following error message when trying to run code that depends on the clr.
Msg 6510, Level 16, State 11, Line 1
...
2
votes
1answer
30 views
Can I restrict how many CPUs SQL Server 2005 uses?
I have a SQL Server 2005 instance running on a production server. CPU load is relatively low in part thanks to some recent improvements in the code. I'm trying to work out if I could safely reduce the ...
1
vote
1answer
147 views
Add SSH host key to another user's PuTTY cache
I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly.
Then I log into my SQL Server Agent and add an extra ...
0
votes
0answers
39 views
sql server peer to peer replication - have the agents running as NT AUTHORITY\NETWORK SERVICE?
On a test rig, I'm trying to get SQL Server 2005 peer to peer (transactional) replication working, with the replication agents running under the NT AUTHORITY\NETWORK SERVICE account.
Before this I ...
1
vote
1answer
91 views
Remote Performance Monitoring SQL Server
I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor).
On my machine, I have an instance of SQL Server ...
0
votes
1answer
80 views
How to configure a trusted connection between IIS 7 and SQL Server 2005?
How do configure a trusted connection between IIS 7 and SQL Server 2005?
My webapp was working fine with Windows Authentication enabled in IIS. Now, in order to solve a problem, we need to use a ...
0
votes
1answer
19 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 ...
4
votes
0answers
87 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
32 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
62 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
139 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
2answers
66 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
1answer
99 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
38 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
25 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 ...
1
vote
0answers
22 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
24 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
26 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
65 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
146 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 ...
0
votes
0answers
107 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
211 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
65 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
60 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
76 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
137 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
46 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
117 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
49 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
124 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
62 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
93 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
56 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 ...
