Viewing 15 posts - 1 through 15 (of 36 total)
Thanks for that Michael. Got the package config working however have a new problem....trying to write out to a file and getting the error
'The output column "ColumnName (xxxx) does not...
July 28, 2008 at 9:29 pm
Hi All,
Thanks for the responses. It seems as though the problem sorted itself once I changed the provider in the connection string. Initiallly it was using ODBC. What a head-ache...
July 30, 2006 at 6:02 pm
Hi Stephen,
I have switched the code to ADO but don't seem to be any better off. In fact the stored procedure seems to kick the bucket rather than completing entirely...
July 26, 2006 at 8:10 pm
Defragging the tables and indexes in the database only increased the amount of unused space in the database. Switching to full recovery mode didn't make a difference. Truncateonly and notruncate...
February 15, 2006 at 10:00 pm
Thats the easy part...what about multiple data columns, is there a way to name each one individually?
October 9, 2005 at 6:51 pm
After much agonising.....I finally built a web app to extract the data which simply called the stored procedure then output the data to a text file using a stream writer....
July 13, 2005 at 4:29 am
Thanks for the responses! Since I was already taking file growth measurements I implemented a process to notify me when free space dropped below a certain level so I can...
March 16, 2005 at 5:15 pm
Hi Leon,
Attempted both but still have the same problem of Enterprise
manager not reporting all rows. I ran sp_spaceused with the object name and it returned the same number of rows...
December 30, 2004 at 5:05 pm
Thanks for the tips all...particularly the posting on the backup/restore tools....very handy.
Regards,
Terry
December 8, 2004 at 4:15 am
How long it takes would depend on a number of factors Im guessing. Such as where you are restoring from (disk or tape), cpu's , RAM etc. I have a...
December 5, 2004 at 3:49 pm
Everyone is entitled to their opinion I guess. When you have a group of power users who may want to do one thing one week, then another the next its...
November 25, 2004 at 5:51 pm
I agree totally that a user shouldnt have access to the tables....in most cases. However, I'm looking for a better way to support our advanced users in the finance team....
November 24, 2004 at 4:15 am
Hi All,
Thanks for the responses...but after much digging I found the solution to be as follows:
iif( Parameters!FromDate.Value is nothing .....
Im still cutting my teeth with designing reports in...
September 28, 2004 at 7:52 pm
Essentially we have done the same thing. If you had changed your services to run under the domain account via EM, then apparently all the correct permissions are applied to...
September 5, 2004 at 5:37 pm
Hi All,
Thank you all for your responses. Its been an interesting ride....and the ride hasn't stopped. Basically we created a Domain account then added this account to start all the...
August 30, 2004 at 10:12 pm
Viewing 15 posts - 1 through 15 (of 36 total)