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
6
votes
3 answers

Can I view my MSSQL connection string from within SQL Server Management Studio?

I'm using SQL 2005, and was helping someone debug a connection issue today. I thought that I could view my current connection string from inside SQL Management Studio, but can't seem to figure out how to make it happen. Is this possible? Google…
Ducain
  • 483
  • 2
  • 10
  • 20
6
votes
1 answer

Send sql server job alert only when a query has rows to return

I have a query that checks if we've made sales of a particular stock item select * from merchand_history where stock_code = 'zzz007' and create_timestamp >= getdate() order by create_timestamp desc I'd like to have a sql job that emails a user (I…
Paul D'Ambra
  • 1,082
  • 1
  • 13
  • 22
6
votes
2 answers

Testing that SQL Server 2005 is listening for FreeTDS

What is the best way to test that SQL Server 2005 is listening on an IP and port? Some Background: I'm trying to connect a Unix box to SQL Server 2005 using freetds. However tsql keeps telling me that "Adaptive Server is unavailable or does not…
Patrick McNally
6
votes
2 answers

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. The next hurdle I am trying to tackle is adding…
Refracted Paladin
  • 345
  • 7
  • 20
6
votes
12 answers

Move SQL-Server Database with zero downtime

Is it possible to move a sql server 2005 db to a different server running sql server 2008 without any downtime? The system is 24/7 and has to be moved to a different server with different storage. We tried copying the database, but that does not…
kcode
  • 1,825
  • 4
  • 19
  • 21
6
votes
2 answers

What are the basic tasks that need to be done to keep an SQL Server 2005 database healthy

I have a SQL Server 2005 database that is large in every sense. It is complex, it has a lot of data (relatively, but given the lack of blobs, it is still quite large) and it is heavily accessed. What are the basic administration tasks that need to…
Yishai
  • 708
  • 1
  • 6
  • 15
5
votes
6 answers

Sql Server huge tables with no rows

I have a Sql Server database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on…
Mike Gates
  • 185
  • 1
  • 1
  • 3
5
votes
2 answers

Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases

I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL Server authentication (username+password). When I…
Kjensen
  • 1,039
  • 10
  • 28
  • 39
5
votes
5 answers

Login failed--password of account must be changed--error 18488

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was. SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: The password of the account must be changed.…
Bill Paetzke
  • 855
  • 4
  • 12
  • 19
5
votes
2 answers

SQL Server - list all tables without a primary key

Is it possible to produce a list of all tables within a specified database that don't have a primary key? This is SQL Server 2005.
Martin
  • 572
  • 4
  • 14
  • 26
5
votes
2 answers

Running SQL server 2005 and 2008 on same machine?

Running SQL server 2005 and 2008 on same machine ? Is this possible/practicable ? It's only for developers and not very resource intensive - is there anyone out there who's done it ? Would be interested to hear of experiences or known gotchas. (I…
shearichard
  • 153
  • 1
  • 5
5
votes
3 answers

How to search an entire MS SQL 2005 DB for a value?

How can I search an entire MS SQL 2005 DB for a value? For example 'ABC12345'. Thanks.
Techboy
  • 1,550
  • 7
  • 31
  • 49
5
votes
2 answers

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still waiting to hear back on whether it's a full edition…
link470
  • 75
  • 3
  • 7
5
votes
4 answers

Upgrading Sql Server 2000 to 2008

At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no longer supports them. Has anyone done this…
Terry
  • 1,073
  • 1
  • 11
  • 17
5
votes
3 answers

Discover intended Foreign Keys from JOINS in scripts

I'm inheriting a database that has 400 tables and only 150 foreign key constraints registered. Knowing what I do about the application and looking at the table columns, it's easy to say that there ought to be a lot more. I'm afraid that the current…
Jason Kleban
  • 806
  • 3
  • 9
  • 20
1 2 3
…
71 72