ywhittaker (3/29/2009)

---

Hi

I have been working as a developer/sole DBA on SQL Server 2000/2005 since 2003.

the reason for getting MCITP is to get a new job because of being made redundant...

I cannot open an .rar file, can you tell us what you need to know, or what is in the file.

SQL Server Integration Services

If you need any more info, let us know 😀

ok, lets see if I can cut through some of the issues here.

a (.LDF) log file, will always grow, when you backup the log, you are removing all the transactions...

Have you checked to see if any other window services have failed to start.

rockingadmin (9/24/2009)

---

hi all

i created a linked server in sqlserver 2005. i cant able to see the catalogs of that user using ssms 2005...

ramuvanparti (9/24/2009)

---

I have been asked to create two schemas and users. there are no objects in DB.

user must have full on the created schema objects i.e select insert delete and...

Fraggle-805517 (9/23/2009)

---

Something I haven't seen anyone discuss is do you need to put each of these on a separate drive or do you still get the performance increase if you...

sturner (9/23/2009)

---

You can defrag the drives.

'strategies' for minimizing the need to do this is really just good planning of the disk layout and space allocation. Put your backups on a...

vyelchri (9/23/2009)

---

Hi,

I have installed SQL Server 2008 instance in one of my server. SQL Server 2008 service start type is set to "Automatic". Every weekend SQL server database server is...

If you have setup database mail, is this the error you receive, when you right click on database mail and send test email.

MarkusB (9/24/2009)

---

First of all I wonder why you ask us and not MS for the "offical response".

But there are actually several responses from MS, because there are also different...

Keep getting these errors, is this supposed to happen when your jobs are running.

The following error occurred...

Sorry the application encountered an unexpected error. Information about this error...

As mentioned before, the tempdb database is recreated every time sql server is restarted. post the error that is occurring and we can help you further.

I took a look at this particular thread. I do agree with you, Silverfox, and I am usually one tht tries very hard in this regard. ...