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

SQL Server blocking queries

My normal running SQL Server 2005 SP3 servers started experiencing random blocking issues over the past month. Each time it happens I run my blocking script to see whats blocking what (see code block below). I see SPIDs that are causing blocks, but…
David Mathis
  • 898
  • 2
  • 9
  • 21
0
votes
1 answer

Manament MS sql from one IP

I want manament ms sql 2005 server from one ip (my home) and denice all another ip. Guide me
hai
  • 1
0
votes
1 answer

Writing to a txt file by xp_cmdshell

I m trying to write query result to txt file. Here is my code: exec master..xp_cmdshell 'bcp "select * from Leasings" queryout "DHCPLog.txt" -c -t,-T MyServerIP' But the result is : And there is no row in DHCPLog.txt. Do you have any suggestion…
cagin
  • 101
0
votes
1 answer

Sql Server 2005 Service Pack 3 does not install

I'm trying to install SP3 on an install of Sql Server 2005 running on Server 2003 32 bit. When I run the installer it doesn't seem to recognize that I have SQL Server 2005 installed. The dialog box that asks what features should be updated doesn't…
John Hoge
  • 619
  • 3
  • 7
  • 14
0
votes
4 answers

Can I install SQL Server 2005 Express on a Windows Sharepoint Services 3 webserver?

I have a Windows Server 2003 machine that is dedicated to running Sharepoint Services 3. I need to host a new internal web application on this machine which requires SQL Server. I have already confirmed with the application developer that SQL…
Kyle Noland
  • 1,039
  • 3
  • 19
  • 21
0
votes
1 answer

SQL SERVER Query result performance question

When I run a simple query on server SSMS it takes 3 seconds. When I run the same query on my computer on SSMS it takes 35 seconds. What could be the reason? What should I check first? I tried disable the antivirus samething.
THEn
  • 137
  • 2
  • 8
0
votes
3 answers

Batch file function

I need to create a batch file that will purge data from an existing file. Basically SQL server management studios does not overwrite backup data; therefore after the backups have been run and the data transferred, I need to purge the file using a…
GMitch
  • 500
  • 4
  • 12
0
votes
1 answer

How do you backup CRM3.0 when the 'ftcat_documentindex' is offline?

My organisation uses Microsoft CRM 3.0, and I am attempting to backup the database. The following error is preventing me from doing so, does anyone know how to resolve this issue? Error: System.Data.SqlClient.SqlError: The backup of full-text…
Josiah
  • 269
  • 1
  • 5
  • 10
0
votes
2 answers

SQL Server 2005 Express on Windows 7: Service does not start during installation

During SQL Server 2005 Express installation on a computer with Windows 7 Home Premium x64, the installation failed upon trying to start the instance service. No log file was created in the instance log folder itself (.../MSSQL.1/MSSQL/LOG).…
Angel
  • 9
  • 2
  • 3
0
votes
1 answer

Error on creating job SQL Server 2005

Error on creating job: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo) SQL Server: Microsoft SQL Server 2005 -…
Kashif
  • 193
  • 2
  • 11
0
votes
1 answer

SQL 2005 Server memory requirements and performance

What is the risk involved in running on 91% RAM usage on Windows Server 2003 32 SP2 and SQL Server 2005 in terms of SQL Server performance? Server has 3GB and mostly sits at around 80% mark with peaks at 91% RAM usage. Also what are performance…
Andrew Douglas
  • 101
  • 2
0
votes
5 answers

Oracle to SQL Migration

I'm currently starting a project for an Oracle to SQL 2008 migration. Since I'm currently reading the official SSMA Guide to Migrating from Oracle to SQL Server 2005 i'd like advice and pointers from personal experience. Guides and articles with…
Paul
  • 714
  • 2
  • 6
  • 19
0
votes
2 answers

Why does the MSSQL stay at "restoring... " even after 2 hours?

I have backed up a database at my old server and restored it at the new server. I am totally new to MSSQL 2005 Server Express, so it took me quite a while. I spent 30 minutes to find out back-ups are stored at the Server, not at the MSSQL 2005…
ujjain
  • 3,983
  • 16
  • 53
  • 91
0
votes
3 answers

Memory settings for multi-instance failover clustering

When using multi-instance failover clustering (used to be called active-active) in SQL Server 2005 and 2008, I'd like to know what you configure the min and max server memory to. For a two-node multi-instance cluster (with two instances, one on each…
Paul Randal
  • 7,194
  • 1
  • 36
  • 45
0
votes
1 answer

MSSQL2005: is there a sproc to set the default distribution agent profile?

I'm trying to work out how to set the default profile for the distribution agent programatically using t-sql. I see there is the sp_help_agent_profile and sp_help_agent_default sprocs which allow you to find out what the default is, but they don't…
simon
  • 714
  • 1
  • 7
  • 21
1 2 3
…
71 72