Questions tagged [sql-server-2005]
Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version
1,071
questions
3
votes
2
answers
6k
views
How to determine Read/Write intensive table from DMV/DMF statistics
This is a follow-up question on Stack Overflow question
How to find out SQL Server table’s read/write statistics?
The goal is the same as the previous question
The goal here is to find out ...
3
votes
2
answers
355
views
Can I still use WMI to manage SQL Server 2005 and 2008?
I've seen some articles on how to use WMI to manage SQL2000 servers (after installing SQLWMI80.msi manually) but I've not seen anything about this for SQL2005 and SQL2008.
Has this been depreciated? ...
3
votes
1
answer
648
views
windows server 2003 monitoring software combining SQL Server monitoring with CPU-IO stats
I'm aware this type of question has been asked many times before:
How to Monitor Bandwidth usage in real terms
Network monitoring
application monitoring tools
Network Traffic Monitoring
...
3
votes
1
answer
1k
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 ...
3
votes
1
answer
155
views
sql server 2005 encoding problem
Ive got text file with utf-8 encoding with more then 2k lines of insert command. Now I would like to execute it as a sql script to insert data into database.
There is greek text with which there are ...
3
votes
1
answer
2k
views
sql server limitation of data size
This question is related to my SQL Data type size
A varchar(max) seems to be able to store up to 2GB.
What I can not understand though is that in this link sql row overflow MS says (my emphasis):
...
3
votes
1
answer
2k
views
One way replication from MSSQL2005 to MYSQL 5.x
I have a mysql database acting as our websever backend. We have our production mssql server that we would like data pushed from, to our mysql server.
I have successfully made the mysql server an ...
3
votes
2
answers
2k
views
SQL Server backup maintenance plan (full, trans log backups)
I've set up a maintenance plan to carry out:
a nightly full backup (overwrites file)
a 2 hourly transaction log backup (appends to 1 file separate to the full)
The database is in Full recovery mode.
...
3
votes
1
answer
642
views
Overflow when converting int to datetime
I'm currently importing a table from MYSQL to MSSQL. There's a column there for storing date, only it's stored as an number. When i import it to MSSQL i get it in as an int data type.
When i try to ...
3
votes
2
answers
172
views
High availability in SQL Server
How can I implement High Availability in SQL Server 2005/2008 Standard.
Some people Recommended me to use third party tools such as double take.
What do you think.
3
votes
2
answers
8k
views
Give developers read-only access to schema
We have a staging server where we do final acceptance testing before we go live. It's a copy of Live where devs have no more privileges than regular users. I'm trying to give the devs read-only ...
3
votes
2
answers
10k
views
SQL Server : Restore Database; Failed. "error not found"
I have just installed SQL Server 2005 on a fresh machine, and I'm trying to import 2 databases from one of my servers. This has worked fine for a box that I did this morning but now I'm getting some ...
3
votes
4
answers
14k
views
SQL Server Maintenance Plan failing - Failed to acquire connection "Local server connection"
I've got a recently installed sql 2005 database server (an upgrade from 2000 on the same machine), I'm trying to get maintenance plans set up to reindex etc but they are constantly failing. This is ...
3
votes
7
answers
8k
views
Unable to connect SQL Server instance from Visual Studio 2008 SP1 on Vista x64
I installed on a Vista x64 machine Visual Studio 2008 SP1 (with integrated SQL from the installation package) and when I try to add an MDF file to a project or to the App_Data when working with web, I ...
3
votes
2
answers
682
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 ...
3
votes
1
answer
2k
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 ...
3
votes
1
answer
9k
views
What happens when tempdb can't grow any more?
I have run into a problem where a tempdb database set to have unrestricted growth has used up all the available disk space (10x its norm). I am considering setting a maximum size limit, something big ...
3
votes
2
answers
2k
views
SQL server 2005 attach without transaction log - urgent !
We had a crash in the sql server and the database remained in inconsistent mode.
We lost the transaction log file and the last generated backup is too old.
I googled this issue but mostly relevant ...
3
votes
3
answers
2k
views
SQL Server 2005 SP3 on Windows 7 - No Management Studio
I've been trying for a day and a half now to get SQL Server 2005, DEV edition, to work on Windows 7, 64 bit prof.
I install from the disk, then run SP 3. I get a failure on the Client Components ...
3
votes
1
answer
5k
views
Trigger is not working on LInked Server. Both servers are SQL Server 2005
I have link a server with another server. I can access records from linked server and I can also insert record using INSERT statement like
INSERT INTO [LINKED-SERVER-IP].MyDb.dbo.Customer (CustomerId,...
3
votes
3
answers
141
views
Allowing Remote Access to SQL Server but still keeping it protected?
I work for a company with a pretty standard internet presence. One dedicated webserver and one dedicated database server colocated at a datcenter. We are a MS house running Windows Server 2k3 and ...
3
votes
1
answer
3k
views
Replication sync failing; Publisher out of Identity ranges
I have Merge Replication set up with a SQL 2005 Publisher/Distributor and roughly 100 SQL 2005 Express Subscribers. Everything was working fine for months and now all of a sudden everyone is getting ...
3
votes
2
answers
9k
views
SSIS: How to create and export data to Microsoft Access 2003 database?
Goals
- Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package)
There is no "Access DB Destination" in BI ...
3
votes
1
answer
109
views
What replication options exist between SQL Server 2000 and 2005?
We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances.
The business partner databases that we need to ...
3
votes
1
answer
356
views
Why might login failures cause SQL 2005 to dump and ditch?
Our SQL 2005 server began timing out and finally stopped responding on Oct 26th. The application logs showed a ton of 17883 events leading up to a reboot. After the reboot everything was fine but we ...
3
votes
2
answers
819
views
How can I reindex sql server tables remotely?
A production database was moved to a SQL Server 2005 cluster, I only have dbo rights to the DB and do not have access to SQL Agent. I do have access to the older SQl Server 2005 system which I could ...
3
votes
2
answers
2k
views
SQL Server Management Studio not scripting all objects
i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some.
i can provide detailed screen shots
the ...
3
votes
5
answers
475
views
Executing SSIS package
I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business ...
3
votes
4
answers
2k
views
Unix and Triggering MS SQL Server Integration Services Jobs
We have an AIX server which contains a lot of data, and once a night we dump that data to CSV for import into MS SQL Server for reporting reasons.
At the moment, each step in the process is unlinked, ...
3
votes
1
answer
249
views
Uninstalling SQL Server 2005 express - blue screen
Few months ago, I installed sql server 2005 express edition. When I am trying to uninstall it, it keeps throwing a blue screen saying, the subsystem system has terminated unexpectedly 000x...Is there ...
3
votes
3
answers
1k
views
SQL Server won't let me log in
I have installed SQL Server 2005 (Developer edition) on a Windows 7 machine (I know - it wasn't my choice!) Machine is named user-PC, and has only one user: user no pwd.
I am trying to connect to ...
3
votes
1
answer
173
views
Script to mirror MS SQL Server databases between 2 servers
I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others)
One server is production and the other is primarily there as a backup.
We're rebuilding all of ...
3
votes
2
answers
1k
views
Why does my server lose SQL connection every 2-3 days (reboot fixes)?
Every 2-3 days, my Windows Server 2003 R2 Enterprise box which is hosting a .NET web app will start having an issue. The .NET app stops being able to connect to the SQL server with this error:
An ...
3
votes
2
answers
8k
views
Database mail won't send emails
I am trying to setup database mail in ms sql 2005. I setup but everytime I try to send a msg through their email tester it fails and I get this msg.
Date 7/7/2010 10:54:12 AM
Log ...
3
votes
1
answer
5k
views
What are the possible disadvantages of enabling the "data access" server option in sys.servers for the local server?
We plan to change the default server options of an SQL2k5 server instance by enabling data access.
The reason is that we want to run SELECT * FROM OPENQUERY(LOCALSERVER, '...') - like statements on ...
3
votes
4
answers
3k
views
How to export SQL Server data from corrupted database (with disk write error)
IT realised there was a disk write error on our production SQL Server 2005 and hence was causing the backups to fail. By the time they had realised this the nightly backup was old, so were not able to ...
3
votes
3
answers
15k
views
Installing SQLServer 2005 on Windows 7 64bit
It's 3 days I'm trying to install SqlServer 2005 under Windows 7 64 bit on my computer.
First let me tell you what I've done and what I've got till now .
1-I Installed Windows 7 64 Bit on my computer ...
3
votes
1
answer
1k
views
Alter Stored Procedure in SQL Replication
How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication?
I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so ...
3
votes
3
answers
165
views
Issue with corrupt 1tb volume: can we rescue SQL databases?
We have an instance where some how a 1tb volume has become corrupted. There are Event ID 55 errors in the system event viewer. When running chkdsk, it gets to 47% verifying indexes and returns to the ...
3
votes
1
answer
714
views
MSSQL 2005 migration to 2008 Express Edition - Any complications?
I've developed an application that uses ASP.NET, Linq-to-SQL and MSSQL 2005. However, I would like to migrate it to MSSQL 2008. I don't have MSSQL 2008, so I was wondering if it's possible for me to ...
3
votes
1
answer
177
views
SQL Server Performance Drops
One of my customers has a SQL Server 2005 Standard Edition with the current service pack. Over the weekend the Windows 2003 Server had some Windows Update (all security patches) applied. Performance ...
3
votes
2
answers
191
views
Mirroring database in sql server 2008
When pricipal database is having less changes than mirror database i.e mirror_failover_lsn is greater than mirror_end_of_log_lsn of principal server, the mirroring session got suspended nad couldn't ...
3
votes
1
answer
709
views
SQL SERVER 2005 with Windows 7 Problems
First of all I restored the database from other server and now all the stored procedures are named as [azamsharp].[usp_getlatestposts]. I think [azamsharp] is prefixed since it was the user on the ...
3
votes
4
answers
2k
views
Using linked servers to query across database servers?
We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The ...
3
votes
1
answer
583
views
SQL 2005 won't fully uninstall
I am trying to uninstall my default instance of SQL Server 2005 from my Windows 7 machine but having a few problems. Everything uninstalls as it should using Add/Remove programs but for some reason I ...
3
votes
3
answers
107
views
How to bring DB Engine Security together with Database Security MSSQL 2005 Express?
When we restore a backup created with the command below we get all the security settings on the database level but the users on the engine level are not created.
osql -s myserver -E -Q " BACKUP ...
3
votes
4
answers
2k
views
Setting up ASP.NET Membership provider for an application
I recently downloaded DotWiki which I plan on using for a support section for my companies website. The application itself has two different security modes "simple" and "full". Full uses an ASP.NET ...
3
votes
3
answers
653
views
SQL 2005 Diff backups failing - no full backup exists?
I have a SQL 2005 SP 2 server running a maintenance plan that performs full backups every day at 22:00, diff backups every 4 hours and log backups every 30 minutes. The plan backs up all system & ...
3
votes
1
answer
45
views
SQL Server 2005 global slowdown
Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
3
votes
4
answers
238
views
After upgrade to SQL Server 2008, database log file grows disproportionaly
After upgrading from SQL2005 to 2008 SP1, we're suddenly observing disproportional expansions of the database log file during large transactions.
Example: inserting 75 million rows into table B, ...