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

Filter by
Sorted by
Tagged with
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 ...
dance2die's user avatar
  • 2,031
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? ...
Guy's user avatar
  • 2,678
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 ...
Vinko Vrsalovic's user avatar
  • 1,523
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 ...
Robin's user avatar
  • 827
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 ...
potatoMan's user avatar
  • 153
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): ...
user76678's user avatar
  • 349
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 ...
RateControl's user avatar
  • 1,207
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. ...
damitamit's user avatar
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 ...
Paul's user avatar
  • 714
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.
Kronass's user avatar
  • 197
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 ...
David Wimbush's user avatar
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 ...
user155695's user avatar
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 ...
Robin's user avatar
  • 827
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 ...
Shimmy Weitzhandler's user avatar
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 ...
user avatar
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 ...
Shantanu Gupta's user avatar
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 ...
Iain Hoult's user avatar
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 ...
user51361's user avatar
  • 131
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 ...
user avatar
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,...
Kashif's user avatar
  • 193
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 ...
user36975's user avatar
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 ...
Refracted Paladin's user avatar
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 ...
dance2die's user avatar
  • 2,031
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 ...
Even Mien's user avatar
  • 657
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 ...
Byron Sommardahl's user avatar
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 ...
Dwight T's user avatar
  • 209
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 ...
Ian Boyd's user avatar
  • 5,373
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 ...
Saif Khan's user avatar
  • 1,965
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, ...
Moo's user avatar
  • 2,264
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 ...
user80994's user avatar
  • 131
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 ...
Chris Kemp's user avatar
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 ...
David W's user avatar
  • 91
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 ...
MetaGuru's user avatar
  • 916
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 ...
chobo2's user avatar
  • 481
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 ...
Attila Csipak's user avatar
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 ...
damitamit's user avatar
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 ...
Mostafa's user avatar
  • 145
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 ...
Refracted Paladin's user avatar
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 ...
user avatar
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 ...
FullTrust's user avatar
  • 185
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 ...
Rick Schummer's user avatar
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 ...
user23996's user avatar
  • 191
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 ...
user21004's user avatar
  • 153
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 ...
Jeff Meatball Yang's user avatar
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 ...
Cragly's user avatar
  • 163
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 ...
Geo's user avatar
  • 3,081
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 ...
Kevin Wiskia's user avatar
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 & ...
Chris W's user avatar
  • 2,670
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 ...
CWilliams's user avatar
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, ...
Max's user avatar
  • 365

1 2 3
4
5
22