Viewing 12 posts - 46 through 57 (of 57 total)
Try building your edge table in tempdb instead of using all the unions. Also, maybe a call to an XSLT in the template or in the final xml result might...
March 15, 2004 at 11:20 pm
Bill,
Arden is right on the money, I've seen Access database shrink by this factor. So try the built-in tools. The cause as IRC is that really never internally deletes records...
March 15, 2004 at 9:55 pm
You might also try the DTSRUN.EXE tool. IIRC, It doesn't require you to have EM to run a package.
Peter Evans (__PETER Peter_)
March 15, 2004 at 6:46 pm
Bill,
Have you just tried using the Upsizing Wizard built into Access 2k? It creates a nice report of how it converts Access Types into SQL Types and reports problems.
Peter Evans...
March 15, 2004 at 6:43 pm
T-SQL approach
-- Assuming you
-- CREATE PROCEDURE spGetNextReportDate
-- @resultsring nvarchar(8) OUTPUT
__ AS SELECT @resultstring = ...
declare @nextreport nvarchar(8)
execute spGetNextReportDate @nextreport OUTPUT
insert (column1, column2)
select ArchiveColumn, @nextreport...
March 15, 2004 at 6:22 pm
Nice introduction to the concept of NULL is unknown. But I disagree with the implication that NULL should be treated as some default value. Yes sometimes treating @variables as defaults...
March 15, 2004 at 5:34 pm
You might try the Database Maintenance Plan Wizard built-in to EM and-or the sqlmaint.exe command line tool. I think these will post the size information you might be desiring...
March 15, 2004 at 1:47 am
You also might want to have your DBA set you up a DTS (Data transfromation services) script that you can run independently with DTSRUN.exe tool and load the data directly...
March 15, 2004 at 1:11 am
Are you sure your not running sql server in single user mode? I've seen this error when I've had sql server running in command window under single user mode for some...
March 15, 2004 at 1:01 am
I agree with Grasshoppers post. I think you're creating work for yourself here. However, If you just have standard edition maybe that's why you needed todo the work by hand. ...
March 15, 2004 at 12:53 am
Why aren't you using DTS packages to distribute the jobs and as documentation? Are these not sufficient for your business logic needs?
The DTS repository can be used for this...
March 15, 2004 at 12:41 am
With so many new features, YUKON (Sql Sever 2005) needs to get them very stable and secure before releasing regardless of the other licensing programs Microsoft customers have purchased.
I...
March 11, 2004 at 5:41 pm
Viewing 12 posts - 46 through 57 (of 57 total)