Not sure how that helps with changing the port number, the switches you mentioned are purely for no ui or basic ui, no prompts. silent install

ananda.murugesan (9/11/2009)

---

In sql server 2005, the following query does not work? could anyone suggestion me what is the worng?

SELECT B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(),

MAX(Backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,

ISNULL(Convert(char(10), MAX(backup_finish_date), 101),...

I worked for a company where UNISYS were doing a consolidation project, before I had started there, the unisys project manager...

naresh1253 (9/11/2009)

---

actually my product requires SQL server express as a prerequisite. So i am doing a silent installation of SQL if it does not exist and give any one or...

naresh1253 (9/11/2009)

---

Hello All,

Currently the SQL Express edition on my machine is configured to listen on Port 5201, now i would like to change the port...

Nope, kind of ironic considering I live in wales. But weekends are time with family and when I saw that Unisys are helping to sponsor it, that made the decision...

shanila_minnu (9/11/2009)

---

We are trying to change the login and password of the server.

In one of the server login for sqlserver agent and mssqlserver is different.we changed the login to...

BOL is a good reference, but sometimes people need a little more help...

This might help you as well

http://www.sql-server-performance.com/articles/dba/Overview_of_Maintenance_Plans_in_SQL_Server_2008_p1.aspx

depending on what information you are after, you could query the default trace file, there is another recent post that describes how to do that

Hilda (9/10/2009)

---

Sorry about the incomplete information.

Here's the version:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard...

between 7am and 9am GMT, replying to topics is almost unworkable, waiting for about 2 minutes for it to time out.

http://www.mssqltips.com/tip.asp?tip=1229

http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/

http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/

point in time recovery is the ability to...

Duplicate Post

All replies to

http://www.sqlservercentral.com/Forums/Topic786154-146-1.aspx

Duplicate post

please reply to

http://www.sqlservercentral.com/Forums/Topic786154-146-1.aspx

Duplicate Post

All replies to

http://www.sqlservercentral.com/Forums/Topic786154-146-1.aspx