Viewing 15 posts - 1,411 through 1,425 (of 2,387 total)
Right click your maintenance plan --> properties --> reporting tab --> check 'text report' to wirte text report to a directory --> run the job --> open above text report...
July 28, 2003 at 7:27 am
How about select * from openquery(TSTSQL01, 'select @@version'), TSTSQL01 is your linked server.
July 25, 2003 at 5:51 am
Anyone knows how to perform silent installation of this patch? Thanks.
July 24, 2003 at 1:48 pm
Are you try to refer temp table created by stored procedure or another session?
Check the sysobjects in TEMPDB to see whether this temp table exists.
July 24, 2003 at 12:44 pm
The INIT option specifies that all backup sets will be overwritten.
The NOINIT indicates that the backup set is appended to the specified backup device, preserving existing backup sets. NOINIT is...
July 24, 2003 at 12:29 pm
quote:
In summary, do differential backups take the changes since the last FULL backup or FULL OR DIFFERENTIAL??
July 24, 2003 at 12:18 pm
Have you tried to use openquery to call function in linked SQL Server.
For example,
select * from OPENQUERY(TSTSQL01,'select * from master.dbo.usysprocess(51)')
July 24, 2003 at 12:09 pm
July 24, 2003 at 9:31 am
SQL Server is designed to take as much as available memory and relaese the memory Once the amount of memory reaches the point where only 4 MB to 10 MB...
July 24, 2003 at 8:41 am
Create linked server to Excel File.
sp_addlinkedserver N'Excel', N'Jet 4.0',
N'Microsoft.Jet.OLEDB.4.0',
...
July 23, 2003 at 3:26 pm
http://support.microsoft.com/default.aspx?scid=kb;en-us;70956
http://www.sql-server-performance.com/rd_delete_duplicates.asp
Edited by - Allen_Cui on 07/23/2003 3:04:40 PM
July 23, 2003 at 3:04 pm
Have you tried to BCP Text data into SQL Server and select records that match the filed in existing table? BCP is quite fast.
July 23, 2003 at 3:01 pm
Are you trying to recreate log file for your database? Which version of SQL Server you run? Have to try to detach it and attach it with sp_attach_single_file_db? How many...
July 23, 2003 at 1:01 pm
Viewing 15 posts - 1,411 through 1,425 (of 2,387 total)