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

vCenter 4.0 vim_vcdb database datafile size. How big should it be?

How large should my vim_vcdb database datafile to be? How much daily change should I expect to see? Should I be looking into some type of data archiving/purging? I have 9 hosts and 198 VMs. Vcenter is a VM, DB is a physical -SQL2005. Currently my…
Alan
  • 856
  • 1
  • 9
  • 18
0
votes
2 answers

why does my sql2000 database perform worse in sql2005

We have a sql 2000 database thats about 1.2 gb big and a website pointing at said database. We are looking to upgrade to sql 2005 and are in the process of testing this transition. we took the mdf and log files from the 2000 instance and copied them…
Dave
0
votes
1 answer

reporting services 2005 with sql server 2008

Can you have Reporting services running on a SQL 2005 server connect and retrieve data from a SQL 2008 server, both x64 ?
ixul
0
votes
2 answers

Realtime MS SQL Database transfer

I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime. Is there any way to do it?
user34402
  • 271
  • 1
  • 5
  • 10
0
votes
1 answer

Unable to connect to a remote SQL Server instance 2005 over a VPN

I'm running SQL Server 2005 on two different servers running Win XP. The two servers are in different physical locations and are connected via a dedecated point to point data link in a virtual private network(VPN). Im only able to connect to the…
Jack Njiri
  • 145
  • 5
0
votes
1 answer

SQL Server 2005: Cannot install database diagram support objects

I have run into a "good old" problem on SQL Server 2005 Express. When I select the "Database Diagrams" node in SSMS, I get the message: Database diagram support objects cannot be installed because this database does not have a valid owner…
Tor Haugen
  • 449
  • 4
  • 6
  • 14
0
votes
3 answers

How SQL Server place the data to disk

Hey, does anyone know a good site that shows how SQL Server place the data to disk?
eriksv88
  • 135
  • 1
  • 3
0
votes
1 answer

How to resolve "Outdated system drive that can cause paging detected" in SQL 2005 BPA?

New installation of SQL Server 2005 (9.0.4035) with Windows 2003 (SP2) on a HP DL360 G5 with the latest ProLiant support pack. I get the following "critical message" from the SQL 2005 Best Practice Analyzer: Outdated system drive that can cause…
Richard Slater
  • 3,228
  • 2
  • 30
  • 42
0
votes
1 answer

How to DENY access for a particular database for login "sa" and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create another login called "AuditLogin" which should be able…
Jey Geethan
  • 775
  • 1
  • 6
  • 11
0
votes
1 answer

Get SQL Server Response Time

How do you get the average response time for query a SQL 2005 server?
Sam
  • 2,020
  • 1
  • 16
  • 22
0
votes
1 answer

SQL XML to Unicode no encoding

I want to export a varchar(max) column (SQL 2005) to an xml UTF 8 using BCP out to a file. I tryed using the -w option for BCP but so far it encodes my special characters in strings like – Is there's an option to skip the special characters…
Paul
  • 714
  • 2
  • 6
  • 19
0
votes
1 answer

SQL SERVER Express Connection String for User Instances same on SQL Server Standard

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access: Data Source=.\SQLExpress; AttachDbFileName=|DataDirectory|\dash.mdf; Integrated…
Justin
  • 189
  • 1
  • 8
0
votes
2 answers

SQL Server Partial Backups

We currently distribute snapshots of our database to our stores by using rdiff on compressed backups of the entire database. In order to optimize how long it takes to both create these backups, and each store download them, we're looking to leave…
Matt
  • 142
  • 1
  • 8
0
votes
1 answer

What is the performance impact of changing the DB Owner in SQL Server 2005?

If I have two accounts, where: both accounts have DBO level access (use the DBO schema to log in, and are part of the owner group) one of the accounts is listed as the "actual owner" both accounts are currently in use, and will continue to be in…
blueberryfields
  • 757
  • 1
  • 7
  • 17
0
votes
1 answer

How to remove database backups 2 days or older through SQL Server 2005 Integration Service?

I have a simple Integration Service package which has one SQL Task as shown below; WLSTAGE Bakup using Red Gate: Calls master..sqlbackup to backup database Here is the SQL to run the actual backup exec master..sqlbackup '-E -SQL "BACKUP DATABASE…
dance2die
  • 2,011
  • 7
  • 32
  • 41
1 2 3
…
71 72