Welsh Corgi (2/21/2010)

---

Jeff,

I should have been more clear and I agree with you. 🙂

I never setup a maintenance task to shrink a Data or Log File. I would...

I don't see any other way - you have to create the user(s) in the database before you can assign any permissions to the user.

jaroho (2/21/2010)

---

I am not using a single account to authenticate users.

All i want is, no one should modify or run queries from the backend.

All modifications should be done from the...

The best way to automate tasks on the server is whatever works the best for your situation. There is no one size fits all automation tool.

As for Powershell -...

cmd.CommandType = System.Data.CommandType.Text

cmd.CommandText = _

" SELECT O.OrderID, SUM(OD.UnitPrice * OD.Quantity)" & _

" FROM dbo.Orders O " & _

...

Like I said before, if you are concatenating strings and passing those strings you really should change your code. In it's current form, you are open to a SQL...

Also, since you are using ASP - you probably want to make sure you are using parameters instead of concatenating the date to a string and passing the string to...

If you are passing in your date in a format that is affected by regional settings, you would get this error. For example:

01/02/2010 can be interpreted by SQL Server...

If there is no key on the case, or stamped on the CD - then you need to contact Amazon and ask them for it. Sorry...

Paresh Randeria (2/19/2010)

---

Log file is on it's own dedicated disk.

I understand that writing in the log file is sequential but because it is very very heavy insert into the multiple...

It may have been pre-pidded. Have you tried installing and seeing if it prompts for it?

This is just the same recommendation you get when installing any software. FWIW - I have never had any issues with virus scanners causing issues during SQL Server installations...

This does not sound right - there is...

Right-click on the maintenance plan and select View History. This will show you the history for the plan and which task actually failed. Select the failed task and...

Did you read the article I linked to? It explains this all in great detail.

Regardless of your experience, if your database is in full or bulk-logged recovery model you...