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
3
votes
3 answers
How to bring DB Engine Security together with Database Security MSSQL 2005 Express?
When we restore a backup created with the command below we get all the security settings on the database level but the users on the engine level are not created.
osql -s myserver -E -Q " BACKUP DATABASE MyDB TO DISK =…
Geo
- 3,071
- 11
- 42
- 52
3
votes
3 answers
Run a SQL Server 2005 Job as Administrator on Windows Server 2008
I have a job, C:\foo.bat.
When I run the job from windows explorer it fails. When I right click on the file and click "Run as administrator..." the job passes.
Now when I setup the job in SQL Server Agent, it fails. I can't figure out how to run…
John Oxley
- 278
- 1
- 6
- 19
3
votes
1 answer
Why won't SQL Server use an index seek when running a parameterized query?
When I execute the following query in SQL Server 2005 it uses an index seek, as verified by viewing the execution plan.
SELECT *
FROM Account
WHERE Number = '123456789'
But when I run the same query, but use a parameter, it uses an index…
Stefan Moser
- 177
- 1
- 9
3
votes
4 answers
SQL Server Maintenance Plan failing - Failed to acquire connection "Local server connection"
I've got a recently installed sql 2005 database server (an upgrade from 2000 on the same machine), I'm trying to get maintenance plans set up to reindex etc but they are constantly failing. This is the message I get, I presume some permission for…
Robin
- 817
- 3
- 11
- 20
3
votes
2 answers
ShareWebDb_log.ldf is 97GB - How to reduce?
We run an SBS 2008 server with WSS. On the drive I have set aside for WSS, I'm fast running out of space due to the ShareWebDb_log.ldf file:
I've tried doing to do what I've read online - change the recovery mode, backup and truncate - but I can't…
pierre
- 189
- 6
- 17
3
votes
3 answers
Simplest way to shrink transaction log files on a mirrored production database
What's the simplest way to shrink transaction log file on a mirrored production database?
I have to, as my disk space is running out.
I will make a full database backup before I do this, so I don't need to keep anything from the transaction log…
MGOwen
- 307
- 2
- 4
- 11
3
votes
2 answers
How do you backup a database within SQL Server 2005 from the command line?
I need to create a scheduled task that will backup a database within a SQL Server 2005 instance.
Is there a command line argument that I can use to achieve this?
Josiah
- 269
- 1
- 5
- 10
3
votes
2 answers
Can I still use WMI to manage SQL Server 2005 and 2008?
I've seen some articles on how to use WMI to manage SQL2000 servers (after installing SQLWMI80.msi manually) but I've not seen anything about this for SQL2005 and SQL2008.
Has this been depreciated? Or is WMI now installed as standard with 2005 and…
Guy
- 2,668
- 2
- 20
- 24
3
votes
3 answers
Queries run extremely fast locally, extremely slow on remote machines
We have a query that take takes anywhere from 24-38 seconds to run when you run it from SQL Server Management Studio from a remote machine, but <1 second to run when it is run from the machine locally using SQL Server Management Studio.
SQL Server…
nvahalik
- 203
- 1
- 2
- 6
3
votes
2 answers
Cannot rebuild index because row above maximum size (Microsoft SQL)
I'm trying to rebuild a clustered index on a SQL Server 2005 table, and I keep getting the error:
Cannot create a row of size 8078 which is greater than the allowable maximum of 8060.
The command is just a standard ALTER INDEX ON …
