Just fixing up the link for future onlookers:

http://www.sqlservercentral.com/Forums/Topic1206241-1291-1.aspx

Google each one of those phrases and lookup how to capture each bit of info, over time. Then, once you have a process to capture that information over time you...

service account password changed, server rebooted over weekend and failed to start due to login error

A few things:

1) osql is deprecated in SQL 2005. Consider switching to use sqlcmd or bcp for this work.

2) accessing the file system from T-SQL can create some scenarios...

SQL Server Books Online (BOL) is almost always my first stop when wanting to learn more about a feature of SQL Server. Here is a link to an article in...

What do you mean by "saved the project"?

issues but I saved the project and now I have no idea how to open all the lines of code. I know it...

sql_er (2/15/2013)

---

Hi,

We have the following scenario: We receive CSV files every month for which SSIS packages were built to process the data. The following problems occur from time...

Is it MySQL that you are working with? This site is dedicated to Microsoft SQL Server. You may have better luck on the MySQL.com Forums[/url].

Not cheap, but Visual Studio 2010 Ultimate Edition has some very slick Load Test tools.

zsarv (2/16/2013)

---

Thanks for the response.

The role for the administrators is not a problem as sysadmin would be what I'd want and is done at the server level. For the...

Have you tried your SQL 2000 query on 2008? The system tables that support haven't changed much with respect to determining job success or failure, if at all.

I think you might be misunderstanding what those numbers mean. Please read this entire article including how to monitor the existing and calculate an optimal page file size on Server...

Books Online details the required permissions and if you have any doubts I am sure it is nothing running a few tests can't answer for you.

I think XMLReader is going to scale better because it dies not have to load the entire file into memory to work with it, but in using it you're signing...

How many violations are needing to be submitted at one time from the front-end? Or are you passing them to the database one-at-a-time? I am thinking table-valued parameters may be...