Viewing 15 posts - 1 through 15 (of 104 total)
If you are exporting from SQL Server to Excel, just make sure that "First row has column names" is unchecked when you are defining the destination connection.
January 22, 2009 at 1:56 pm
If I'm not wrong, when the job runs, it runs in the context of the service account that starts SQL Server Agent service. Make sure that account has sufficient permission...
January 22, 2009 at 1:10 pm
For deployment, between file system and MSDB, would you please share with us what are the pros and cons of each ?
January 22, 2009 at 1:00 pm
Thank you...I will post it to SSIS forurm.
January 22, 2009 at 8:07 am
Thank you for your help.
Currently we are planning migration from SQL2000 directly to SQL2008. One of our pain is how are we going to develop and deploy SSIS packages. I...
January 22, 2009 at 7:46 am
Thank you for getting back to me.
What's interesting is that there were no errors in errorlog nor in event viewer.
Since DBCC CHECKDB hangs, I decided to run DBCC CHECKTABLE one...
January 21, 2009 at 7:52 am
CHECKDB now only using 0.5 to 0.8% of disk activity. There is no disk activity at all. Is it hanging ?
There is no blocking and the lastwaittype = 'PAGEIOLATCH_SH'.
FYI,...
January 15, 2009 at 9:04 am
There was no blocking and no errors in errorlog and event viewer. I stopped the job.
Right now, I'm running it manually from Query Analyzer. From Perfmom, I see there...
January 15, 2009 at 8:44 am
No problem. I looked at the link you provided and I understood. Thanks a lot.
Just to clarify: DataSource = ServerName and Catalog = DatabaseName ?
August 23, 2007 at 2:26 pm
I have lots of DTS on each server and it's impractical to open one by one. Have anybody use ActiveX Script to pull out those info from DTS Package Object ?...
August 23, 2007 at 9:07 am
Does your table has indexes ? If yes, drop them. After the table is loaded, then create the indexes.
March 14, 2007 at 7:17 am
Hi karthik,
Did you look at Event Viewer (System) to see if there is any errors to disk ? My past experience in DBCC errors are all related to disk problems....
October 30, 2006 at 11:57 am
Peter, Thank you very much for taking the time to answer my puzzle.
Actually by following the steps in KB 817064 would have worked if I also reboot the server B. After...
October 11, 2006 at 12:35 pm
If you have jobs that access files in other servers, the job will fail when using LocalSystem.
October 2, 2006 at 2:22 pm
run the following and retry the view.
UPDATE STATISTICS tablename
October 2, 2006 at 2:07 pm
Viewing 15 posts - 1 through 15 (of 104 total)