EXEC master..xp_cmdshell 'osql.exe -S YourServerName -U sa -P secretcode -Q "EXEC sp_who2" -o "E:\output.txt"'

Or

You can use DTS

returns the error severity specific to the scope of the CATCH block in which it is referenced

If u have any thirdy party tools like Log Viewer try with that.

In transactional and Merg replication it is possible

check with dbcc index defrag for the same index. After use dbcc showcontig even the problem still persists if the table is not too big drop the index and...

Example

EXEC master..xp_cmdshell 'osql.exe -S YourServerName -U sa -P secretcode -Q "EXEC sp_who2" -o "E:\output.txt"'

Is the linked server configured on this server?

select * into new_table from old_table

Application Roles:

Application roles are the SQL Server roles created to support the

security needs of an application. Often database applications

enforce their own security based on the application logic.For example, you can...

UPDATE SomeTable SET Col2 = 66 - ASCII( LOWER( Col1 ) )

The Script is working without any error for me.

use master

go

declare

@UseDate as varchar(50),

@dbname as varchar(50),

@mycommand as varchar(2000)

set @usedate = replace(LEFT(CONVERT(VARCHAR(19), getdate()-3, 120),10),'-','')

set @dbname = 'NAVTEMP'+@usedate

print @dbname

set @mycommand = 'if exists(select *...

Three Simple Reasons

1) Scalability 2) Security and 3)Support

The best and easiest way is using DTS Transfer Login option

Needed more clarity for the post

declare

@dateA datetime,

@dateB datetime,

@baseDate datetime

set @dateA = '11/26/2007 13:27:53.205'

set @dateB = '11/26/2007 13:27:53.209'

set @baseDate = '07/04/1923 00:00:00.000'

select convert(char(11),dateadd(ms, datediff(ms, @dateA, @dateB), @baseDate),114)