Viewing 15 posts - 1,036 through 1,050 (of 1,161 total)
I'm sure this is not the case, but thought I should mention: make certain the ID column in your audit table is not a identity column.
April 11, 2013 at 11:08 am
Even if it does cause potentially more network traffic as a result of normal usage, that is the point of creating the connection from server A to B was to...
April 4, 2013 at 11:51 am
If a sixth column/price gets added or a new product in the family, with 'price 5' rather than 'price5' you will miss data, have to keep maintaining the query. That...
April 4, 2013 at 11:42 am
I had seen this error when I was processing tons of records on a virtual machine. My solution was breaking the query down into batches. That is, using a loop...
April 4, 2013 at 11:25 am
File groups could help if you do frequent data backups on this VLDB where you can back up each devise simultaneously. I don't read that you need to do this.
March 28, 2013 at 10:40 am
Is there a way except advanced editor to change the data type of all columns of excel source in one shot instead of doing for every columns one by one...
March 27, 2013 at 11:21 am
If you are calculating the average value and then showing in the report, just use the FormatPercent function in the expression.
--Divya
This is fine if the value is still a ratio,...
March 27, 2013 at 10:51 am
SELECT
CASE WHEN LEFT(Customer.StartDate, 2) = '98' THEN substring(convert(varchar(20),Customer.StartDate), 3, 2)
...
March 25, 2013 at 12:58 pm
When you use 'like' you are opening the door to multiple rows being fetched. Why could you not pass the exact table name? Your issue may be more upstream.
March 25, 2013 at 12:45 pm
You can import the data as a string and in the dataflow manipulate the string in a derived column transformation to put it into yyyymmdd format, and append that to...
March 20, 2013 at 11:27 am
The user account used for SQL Services has to have local admin privileges and the Log on as a Service right.
March 20, 2013 at 11:12 am
Based on your data flow, did you encrypt the copy of ssn columns and then tried throwing that encryption value into an Excel cell? This may be causing your error...
March 19, 2013 at 11:07 am
Stop SQL Server and restart it in single user mode. Then from management studio right click the master database and and use this menu to restore form your backup device....
March 18, 2013 at 11:26 am
You may need to coordinate with your IT group. Sometimes the Exchange server ( I assume it is Exchange) may have rules that do not accept messages from unknown domains...
March 18, 2013 at 10:59 am
Viewing 15 posts - 1,036 through 1,050 (of 1,161 total)