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
Questions tagged [sql-server-2005]
1072 questions
0
votes
1 answer
About SQL Server networking
I would like to connect from client PC to SQL Server over the internet. I have installed SQL Server 2005. Can you guide me. I am new to this.
Abdulla
- 1
0
votes
2 answers
AWE turned on but still not using memory
I do have a server 2008 64 running a SQL server 2005. I do have 8GB on the server and I want SQL to use most of the memory on that server. I have turned the page-locking on for the account and also turned AWE on. See the result below:
Configuration…
Ridvan
- 1
0
votes
1 answer
SQL server 2005 Slow access
I got reports from users that the access speed has dramatically slowed down, when they try to access the database.
Perfmon states:
Cpu ~20% usage.
RAM (3,5gb) 2.1gb in usage, 1.7GB for SQL
HDD Disk avg read is above 22 up to 40 and has 104GB…
Seb
- 1
- 1
0
votes
3 answers
New SQL Server User cannot view databases when logging into SSMS
I am using SQL Server 2005.
I set up a new user on my development SQL Server, and made him an owner on a specific database. I can log in as him, see all the databases, and open only the database specified.
I set up the user on my production SQL…
Mike Cole
- 203
- 2
- 5
- 15
0
votes
1 answer
SQL Server 2005 Configuration manager services list empty
I have just installed SQL Server 2005 on a Windows 7 Home Edition system. I am planning to use the server from a .NET Application. Now I want to start the local database engine service.
I read here and found out that SQL Server Configuration manager…
Mostafa Mahdieh
- 103
- 5
0
votes
1 answer
log file problem after query execution
Can someone of you experts please advise me on this situation:
I have a dedicated hard drive. It contains the database and log file. I have run a query over night and the log file maxed out the size of the drive (500k left). The query did not finish…
cs0815
- 183
- 7
0
votes
2 answers
SQL Server: How to edit a view without scripting it?
How can i edit the definition of a view without having to "script" it in SSMS?
The previous easy-to-use tools from Microsoft let me:
Enter
wait a moment
Make change
Carefully move mouse to large OK button
Click OK
Down Arrow
goto 1
With SSMS i've…
Ian Boyd
- 5,293
- 14
- 60
- 82
0
votes
1 answer
What Steps are Required to Restore SQL Server 2005 Master Database used with Sharepoint 2007?
The master database on our SQL Server 2005 instance appears to be corrupted. Since this database powers our MOSS 2007 installation, what steps must be taken to restore master and ensure that MOSS 2007 is restored as well?
Thanks!
SidC
- 369
- 3
- 9
- 23
0
votes
3 answers
How to manage more than 1000000 rows in a table in SQL Server 2005
I am working on an application in C# .Net, my backend is SQL Server 2005.
I am developing a sale point form, in my table tblInvoice and tblInvoiceDetail may be added 10000 rows per day .
This is a heavy volume of data, please guide me when 6 months…
Haider Ali Wajihi
- 101
- 2
0
votes
3 answers
DBO role in SQL Server 2005 versus DBA role?
What is the difference between DBO role versus the DBA role?
shamp
0
votes
1 answer
How was the MSSQL Server database erased in the production server (that is a different version? )
I'm asking for help understanding what happened in my situation or what and if I did something wrong.
I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app (production server). I was told to prepare a test…
Feiticeir0
- 434
- 3
- 11
0
votes
1 answer
I need options to query multiple SQL servers
In recent months, we have converted to a new software application. The migration team (vendor) left the old database intact. They converted some of the old data to an "archive" database using the new-vendor's database structure. (That way the new…
0
votes
3 answers
Can I change the memory allocation settings in SQL server 2005 through a registry or config file change?
I'm building VMs centrally and distributing subtly tweaked versions to different people. I've been doing this by mounting the virtual hard disk and editing files. I'm pretty confident I can do something similar with the registry. The next subtle…
Dave Gregory
- 143
- 3
0
votes
1 answer
SQL 2005 Replicated Database Indexes
I have setup a SQL 2005 database replication (transactional) between two servers. I have noticed today that the non-clustered indexes do not seem to have gone across to the replicated database.
I have had a look round sql management studio and cant…
beakersoft
- 997
- 15
- 29
0
votes
1 answer
Network Service account cannot see SQLServer performance counters on Windows 2008 R2
I have a service running on a large number of servers, that logs Windows Performance Counters to a central logging system. The service is written in .Net, and runs as the build-in account "Network Service".
This works fine on Windows 2003, but on…
