Server Fault Stack Exchange
Server Fault Stack Exchange

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

1072 questions
0
votes
1 answer

Is it possible to move sql server databases (physical files) without detach/attach

I want to move physical location of all my databases (around 20) to new location. sys.master_files (physical name) column gives me path of databases. If I copy physical files to new location and change path here then databases will be moved to…
Kashif
  • 193
  • 2
  • 11
0
votes
1 answer

Connect to SQL Server using Windows Group Authentication

I've got this SQL Server 2005 Express installation that's got a Database I'm trying to connect to through a software that gives me the error "cannot connect using the user 'mydoimain\myuser'. Meaning, it's trying to connect using my domain user as a…
Kenny Bones
  • 119
  • 2
  • 3
  • 14
0
votes
2 answers

Windows 2003 Enterprise Server becomes unresponsive occasionally

We're experiencing issues with our Windows 2003 server, which runs SQL Server 2005 SP1. We notice that sometimes the entire server becomes unresponsive and I captured a screenshot of the task manager when this happened. I noticed that the processes…
Derek Ivey
  • 1
  • 3
0
votes
2 answers

SQL Server 2005 version 9.00.4035.00 vs 9.00.1399.00

I have two servers with the versions above (9.00.4035.00 vs 9.00.1399.00), but we installed from the same source. Now some projects don't open. How can I solve this - applying Service Pack 3?
Thomaz Portella
  • 1
  • 1
  • 1
0
votes
2 answers

SQL Server 2005 Developer Edition in Hyper v client

I am running Hyper V with a 3 servers. I added a new server with Biztalk 2006 R2 and it requires SQL Server. Can I install the SQL Server 2005 Developer's edition? Whould this cause a hugh performance hit to my hyper v server? This will be used for…
Saif Khan
  • 1,945
  • 2
  • 20
  • 25
0
votes
2 answers

how do you install SSIS on a cluster environment

I'm running SQL Server 2005 enterprise edition on a 2 node active-active cluster windows 2003 server. I go to add/remove programs, click on SQL Server and then the link for "to install a new component, click here". It then says enter the location.…
phill
  • 327
  • 3
  • 13
  • 20
0
votes
2 answers

what type of replication transaction should I use?

I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different sql servers which are located in different parts…
RaymondMorphy
  • 1
0
votes
1 answer

How to config a Linked server?

How do I config my linked server to connect to the other database with following properties: ServerName:saleh user:sa password:.... Computer IP address:192.168.100.146
Raymond Morphy
  • 121
  • 2
0
votes
1 answer

How to change the email address where SQL Server sends log shipping warnings to?

Years ago, I set up log shipping in our main database. I'm sure that I had to enter my email address somewhere, because every time when something bad happens now (for example, when the secondary database is not in sync), SQL Server sends warning…
Christian Specht
  • 121
  • 5
0
votes
1 answer

I/O error in database restore

I am getting the below error while I am trying to do a restore. Can you please suggest a fix? Backup,Unknown,During restore restart an I/O error occurred on checkpoint file 'd:\dwd\smot\res.CKP' (operating system error 3(The system cannot find the…
user387268
0
votes
3 answers

About is downgraded or replacing SQL Server 2008

SQLServer2008 is on a PC. When we upgraded to SQLServer2008, an ODBC error started to appear: State: 37000,Native: 155,Origin: [Microsoft][Sql Natize Client][SQL Server] 'TRUNCATE_ONLY' is not recognized as a BACKUP option. Now this is error…
freddiefujiwra
  • 1,667
  • 5
  • 25
  • 34
0
votes
2 answers

insert bulk statement - SQL 2005 - not "bulk insert"

I am trying to look for the process/processes that is causing the transaction log to grow out of control. I have tried setting the DB to Bulk-Logged and it seems to still be growing. When set to Simple when the process/processes finish it clears.…
CWL
  • 11
  • 1
0
votes
2 answers

Is it possible to change a cluster that is dependent on a domain?

Recently we received (2) Poweredge 6850 and (2) PowerVault 220s from our managed server company. These two servers hosted SQL Server 2005 with our SQL database on it. The cluster was dependent on their domain. I did not have any of their passwords,…
Jacob
  • 443
  • 1
  • 9
  • 23
0
votes
2 answers

SQl 2005-2008 vs. SQL 2000 maintenance

At my company we've been using SQL Server for quite a while and have followed the recommended upgrade path. I've noticed that over the last couple of years I'm spending way more time rebuilding indexes and doing general functional maintenance than I…
Bob Par
  • 1
0
votes
1 answer

Data Type Error - Merging columns in a new view using SELECT AS

I have a [TABLE] with 3 columns like this: [Column1-smallint] [Column2-nvarchar] [Column3-nvarchar] I would like to create a new view with only 1 column like this: [Column1 & Column2 & Column3] If I try: SELECT [Column1 & Column2 & Column3] AS…
Level1Coder
  • 245
  • 2
  • 10
1 2 3
…
71 72