Viewing 9 posts - 46 through 54 (of 54 total)
I had already considered using SSIS to move the smaller table to the other server and then performing the cross join in a OLEDB Source component. While this would...
January 22, 2009 at 8:53 am
SQLZ (11/3/2008)
Are you sure you're looking at the right counter in perfmon and that you're alerting on the right counter?There's the SQLServer:CacheManager\Cache Hit Ratio and the SQLServer:BufferManager\Buffer Cache hit ratio?
My...
November 4, 2008 at 2:13 am
MANU (10/6/2008)
October 7, 2008 at 2:14 am
At present, that code will just output HTML table rows and cells.
You need to concatenate the opening and closing table tags along with any column headings inside TH tags....
July 23, 2008 at 7:52 am
What I have done in my .net app is script out sql jobs from a SQL2000 server. The code changes all calls to ISQL to SQLCommand, change calls to...
July 17, 2008 at 9:18 am
Thanks for the clarification. So is there any other way to properly script out an MSDB job to a text .sql file? I don't want to have to...
July 17, 2008 at 2:31 am
If anyone else encounters this, I have found that is caused but a corrupt MDAC installation. Instructions to fix can be found here:
June 13, 2008 at 9:45 am
Frank Bazan (4/17/2008)
Populate a recordset with a query against sys.databases.[font="Courier New"]SELECT [name]
FROM SYS.DATABASES
WHERE state_desc = 'ONLINE'[/font]
Then use a for each ADO enumerator to loop through the recordset.
Thanks, that was...
April 18, 2008 at 3:01 am
I have tried setting the Max Number of Errors on the Dataflow task which sits inside the For Each loop but the package still fails.
Is there anyway to...
April 16, 2008 at 8:24 am
Viewing 9 posts - 46 through 54 (of 54 total)