Hello,

You could base the report on a dataset that is formed by a join of the two tables, that way the report will have access to both the data and...

Hello again,

When you say the record is being “wrapped” do you mean that control characters (e.g. Carriage Returns) are being inserted part way through the record?

If so, are the control...

Hello,

Under which Account does the SQL Agent Service run? Perhaps it is set up as Local System?

Did you already spot this MSDN Article on setting the SQL Agent Service Account?

http://msdn.microsoft.com/en-us/library/ms191543.aspx...

Hello,

I am not really sure what you want to accomplish, may be you could provide an example? If you want to perform different actions for records within the same result...

Hello,

You should be able to do this via PowerShell scripting. Take a look at the following article (although it applies to SQL 2005):-

http://www.databasejournal.com/features/mssql/article.php/3709441/Microsoft-Windows-PowerShell-and-SQL-Server-2005-WMI-Providers--Part-1.htm

Regards,

John Marsh

Hello,

May be worthwhile taking a look at the following FAQ page, as it is a bit clearer than the BOL description:-

http://www.sql-server-helper.com/faq/sql-server-2005-varchar-max-p01.aspx

Regards,

John Marsh

Hello,

When you specified the ptions for the Flat File Destination, did you select the “Delimited” format? If you chose “Fixed Width” then the “Row Delimiter” and “Column Delimiter” options will...

Hello,

The following script will Round 12999 to 13000:-

Select Round(12999, -1)

This works for the example that you provided, but what is the underlying rounding algorithm that you need?

Regards,

John Marsh

Hello,

You could take a look at the TechNet Best Practices pages:

http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

Regards,

John Marsh

Hello again,

“Can I get additional information on what DBA's should be setup as in regards to database access/rights?”

To be honest when working in the DBA role, I have always had...

Hello,

It could possibly be a Firewall issue, or may be it is trying to access the server on a port that is not listening or is not a SQL Server...

Hello again,

What types of Objects do you want to create and in which Schemas? Can you please elaborate on what you mean by “is not working” e.g. can you create...

Hello,

You mention that you work for a small organisation, but do you have separate Development, Testing and Production environments?

It would probably be useful for the Data Analyst to have extensive...

Hello,

You can not change the Schema of an object to sys e.g. you can not change a table dbo.MyTable to sys.MyTable. Please see BOL Topic “ALTER SCHEMA (Transact-SQL)”.

Regards,

John Marsh

Hello,

Where does the process fail and what error message do you get?

Can you also post a sample of the data and the Table definition?

Regards,

John Marsh