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
2 answers

Migration Windows 2003->2008, SQL2005->2008

We have some servers with Windows 2003 and SQL Server 2005 and would like to upgrade them to Windows 2008 and SQL2008 because of the new cool features. How can that be done? Anything in particular to think about?
Max
  • 365
  • 2
  • 5
  • 17
0
votes
2 answers

Can't connect to MS SQL Server database using SSMS

I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will…
user43633
0
votes
3 answers

How to prevent a database from being restored?

Is there a way to prevent a database from being restored with a DDL trigger or something? The background is that I would like to prevent restoring a database on a test server by a colleague. So far I had a look a DDL trigger but didn't find the…
André
  • 123
  • 4
0
votes
1 answer

Schema changes with replication

What are the steps to make a schema change to a SQL Server 2005 database using transactional replication? I'm trying to add a database column. I thought if I removed the article for the table, made the schema change, and then added the article for…
Even Mien
  • 657
  • 2
  • 12
  • 19
0
votes
1 answer

Reccomendation for tuning 100's of SQL Databases

I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the data differ quite a lot from database to…
wayne
0
votes
1 answer

SQL Server 22005: Top 1 * for a unique column?

I have data in a table (below), and I need to select the most recent update from each user. Here the data has been sorted by date, so the 'SomeData' column of the most recent unique value of each user. Top 1 SomeData isn't going to work because it…
Echilon
  • 105
  • 3
0
votes
1 answer

Do I need to recreate statistics if I had to drop them to add a foreign key

I have a database which had all it's foreign-key relationships dropped at some unknown time in the past (don't ask). I have an old copy of the database which isn't good to restore from, but the schema has the relationships. I'm working from that…
Adam J.R. Erickson
  • 147
  • 2
  • 6
0
votes
5 answers

How can I disable the windows authentication mode of SQL Server

How can I disable the windows authentication mode of SQL Server and restrict it to ask for username and password every time, with no windows authentication?
Azhar
  • 115
  • 3
  • 4
  • 10
0
votes
1 answer

Which features does SQL Server need for SharePoint 2007

The title says it, I searched the net but not even in the microsoft technet they mention what features I must activate for SQL Server 2005. Can someone help me out?
elhombre
  • 435
  • 1
  • 8
  • 18
0
votes
2 answers

How do I change the Web Service Account for SQL Server Reporting Services?

I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy
CodeFirstAndy
  • 158
  • 5
0
votes
1 answer

SQL Script fails with error: The login already has an account under a different user name

I have a script that creates a user associated with a login for SQL Server 2005. It does this immediately after creating the database and the login. One user of the script reported the following error: The login already has an account under a…
Rock Hymas
  • 103
  • 1
  • 3
0
votes
1 answer

SQL 2005: Backup database but ignore FTI Catalog

Folks, Apologies for aksing what might be a very simple question, but can I backup a database and ignore the databases FTI catalog? These backups will be restored to a different server and the FTI Catalog isn't…
Binary Worrier
  • 133
  • 1
  • 6
0
votes
1 answer

A different interface for the Sql Server Reporting Service?

I have a SQL Server 2005 SQL Reporting Services implementation. It seems that the only way to actually access the reports is for the users to use Internet Explorer. The web page uses an ActiveX control to do its printing (and probably other…
AngryHacker
  • 2,877
  • 6
  • 32
  • 33
0
votes
1 answer

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, but that creates A LOT of files on the file…
Adam J.R. Erickson
  • 147
  • 2
  • 6
0
votes
1 answer

After adding data files to a file group Is there a way to distribute the data into the new files?

I have a database in a single file group, with a single file group. I've added 7 data files to this file group. Is there a way to rebalance the data over the 8 data files other than by telling sql server to empty the original? If this is the only…
Blootac
  • 177
  • 1
  • 2
  • 9
1 2 3
…
71 72