http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Ok,...

Ian-440692 (9/21/2009)

---

After ten years of MS SQL database administration, I feel (hope) that I can answer (resonably well) the questions I will be asked.

But what should I be asking of...

Not really, it used to be...

Krasavita (9/21/2009)

---

I was told to check what is taking a lot of space on the drive where db live. We were ok until last week and now we get alert...

Indianrock (9/15/2009)

---

Has anyone tried this? Reads a folder containing bak, dif and trn backups and generates restore commands. Also handles multiple file groups and the "WITH MOVE" needed...

Sergey Vavinskiy (9/21/2009)

---

C:\>osql -L listens TCP/IP and Named Pipes, that is why you may get duplicates in the server list.

Of course when the one of them is disabled you...

What has been suggested will work for finding server installation, within the same domain. however finding out client installations, if you mean workstation components cannot be done that easily.

If you...

Henrico Bekker (9/21/2009)

---

Narendra-587652 (9/21/2009)

---

thank's for prompt response

i have 500 server and differnt version of SQl(2000,2005,2008) and have to

find SQL client or SQL server installed...

Sergey Vavinskiy (9/21/2009)

---

There is nothing like ALTER JOB command.

But when you script your job as CREATE TO ... You will have full script, which will recreate a job for you....

Quite an open-ended question, not sure how it would, you are allowing SQL Server access to more memory.

plus the fact you...

ebenraja (9/21/2009)

---

Hello Friends,

Using Master target principle I have scheduled the backup maintenance plans. Backups are running perfectly but there are a lot of files created (like text files) on the...

Indianrock (9/18/2009)

---

This is more of a statement than a question. Today I took a small test database, in full recovery mode, and did a full backup followed by a...

Stuart Davies (9/21/2009)

---

Update:-

After a log backup and log shrink things are a bit neater now with regard to dbcc loginfo figures :-

[font="Courier New"]FileId FileSize...

this link might shed a bit more information for you.

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

From my point of...

gupta1282 (9/21/2009)

---

Hi

Is it possible to take full backup of two databases on different schedules

by creating only one maintanence plan

Let me Explain the scenario

I have Two DB , DB1 And...