You could use a Script Task to recognize the file format. In the Script Task, once you know you have a file you want to pre-process here are a couple...

If you provide test tables in the form of CREATE TABLE statements and sample data in the form of INSERT INTO statements I would be happy to provide some working...

It is trying to tell you that the time frame captured in your Trace file and the time frame captured in your perfmon counter log do not overlap.

The MAP Tool from Microsoft has done well by me in the past. It gave me an inventory of all SQL Servers on my network and some decent reports including...

Try this link.

I am not sure I understand this comment: "Some has it while others has run as Administrator."

If you want to run a program as another user right-click the shortcut you...

It looks like the Agent service is down. Where are you seeing this error? In some monitoring tool setup in your environment?

sandosh.star (2/12/2013)

---

@subject ='Status Log for Today'

,@profile_name ='Status'

,@query ='my query'

,@attach_query_result_as_file = 1

,@query_attachment_filename ='Status.csv'

output has Column name called COUNTRY contain different countries AU,MY,SG

I want to group by country and attach the...

No worries if there is little or no database activity, a log backup will still be produced.

Use the Maintenance Cleanup Task to delete old backups.

wendy elizabeth (2/12/2013)

---

if the following is in the connection string in an app.config file, the following will use the sql server login and not the

windows user login correct?

The...

Yes, change to use Table-Valued Parameters instead of passing in a comma-delimited list of values in a single parameter.

Table-Valued Parameters (Database Engine) - SQL Server 2008 R2

SSIS would be my choice for this. A Derived Column Transform after reading the file could append your additional columns before loading the row into a table.

If you want to...

Having supported SQL Server for PHP developers that developed locally on Windows but deployed to and had their code tested and hosted on Linux for QA and Production...some random thoughts:

-...

If you have thousands of jobs just click on the Jobs node in Object Explorer and press F7 to open the Object Explorer Details. Then highlight all the jobs you...

midnight251 (2/12/2013)

---

Ok, just created a Maintenance Plan to backup the Trans Log file. It's going to run Mon-Fri from 7:00am to 7:00pm every three hours. I did say...