As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 6 years ago. Improve this question I am having some issues with my DB autogrowing because of transaction log sizes. I have implemented a DB maintenance procedure where the … Read more
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
When monitoring the Transactions/Sec using perfmon on one of my SQL2005 replicated databases – I’m seeing the TPS increase to 1000 and then immediately drop back down again – this happens every 5 seconds. I’m not sure what’s causing this – is this something to do with replication? We also have asynchronous statistics set on … Read more
I’ve got a Linked Server in my SQL Express install that is using SQL Server Authentication. I’ve created a SQL Server login-mapping and it’s using Impersonate. I’ve confirmed that the account exists on both servers but I’m still getting the error. Any suggestions? Answer Where are you attempting to login from ? An application on … Read more
Sql 2005 I have a text column that has special characters stored e.g. CR, LF, but I don’t know what they are. I would like to view these characters in management studio. Something like in Notepad ++ > Show Symbol > Show All Characters. My Goal: I am working on a data conversion from one … Read more
I’m having a problem with SQL Server Express 2005 edition; it’s unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which succeeded: Ping and DNS resolve test from internal and external (my laptop). Creating System ODBC entry and then perform test from the server … Read more
I am trying to modify and existing sql server 2005 maintenance plan. It’s currently set to run a full backup that will expire in 3 days. It is also set to append existing under if files exists. I want to set it to overwrite if files exist however that particular dropdown is greyed out. I … Read more
Lately I experienced a corrupt DB because of a defective harddisk. SQL Server 2005 detected the issue and put entries into Windows event log about inconsistent DB and invalid page checksums. But it just tried to deal with it. It kept on making daily backups of the already corrupt DB and after each full backup … Read more
We have SQL Server 2005 SP1 currently and VS 2005. We’re planning on installing SP4 for Sql Server 2005. Question: Are there any specific requirements for this install or known negative effects that we should know about? Thank you. Answer You should “smoke test” in a testing environment whenever possible but, in general, SQL Server … Read more
