Viewing 15 posts - 1,531 through 1,545 (of 2,387 total)
You may also consider using DTS with 'transfor data task (ActiveX Script)' to do that.
Here is the example of ActiveX Script.
'**********************************************************************
' Visual Basic Transformation Script
'************************************************************************
' Copy each source...
July 10, 2003 at 3:04 pm
Do you perform database statistics update and optimization regularly?
July 10, 2003 at 1:49 pm
The data of 'Container' was cached into memory after first run and that is why the second test has less physical read.
You still need to examine the execution plan and...
July 10, 2003 at 12:53 pm
I would suspect the user does not have access to these two dbs. Is MDAC version same in these two servers?
July 10, 2003 at 12:12 pm
Cut and paste the query into QA, set 'SET STATISTICS IO on' and execute it to display information regarding the amount of disk activity generated by the Query. If there...
July 10, 2003 at 11:56 am
Go to SQL Serevr Agent Property --> Job system --> uncheck 'Only user with sysadmin .....' and try again.
July 10, 2003 at 11:50 am
Try this.
select object_name(sysind.id) as TableNme, sysind.name as ObjName, sysfg.groupname as GroupName
from sysindexes sysind
inner join sysfilegroups sysfg
on sysind.groupid = sysfg.groupid
inner join sysobjects sysobj
on sysind.id...
July 10, 2003 at 9:23 am
Try Lumignet Schema Alter at http://www.lumigent.com/downloads/schemaalert/ and it is free.
July 10, 2003 at 9:09 am
For example, exec master..xp_cmdshell 'dir c:'
July 9, 2003 at 2:55 pm
quote:
Is this true and I have to live with this behavior
Unless upgrade to...
July 9, 2003 at 2:32 pm
quote:
BTW, SQL 7 SP3 on Win2k.
It doesn't work on SQL Server 7.0.
Use sp_helpfile to...
July 9, 2003 at 2:10 pm
With @updateusage = 'true', sp_spaceused actually executes 'DBCC UpdateUsage' in it.
July 9, 2003 at 2:04 pm
Two special tables are used in trigger statements: the deleted table and the inserted table.
The deleted table stores copies of the affected rows during DELETE and UPDATE statements. During...
July 9, 2003 at 12:09 pm
You need permission to run xp_cmdshell and execute a DTS package using the DTS Run utility from xp_cmdshell.
Examples from BOL.
Examples
To execute a DTS package saved as a COM-structured storage file,...
July 9, 2003 at 12:05 pm
You may use SQL collation as Dictionary order, case-insensitive, for use with the 850 (Multilingual) character set and manage character data in international databases with Unicode nchar, nvarchar, and ntext...
July 9, 2003 at 11:49 am
Viewing 15 posts - 1,531 through 1,545 (of 2,387 total)