Now why would you be using IPX/SPX ??

There is a knowledgebase article on this the 7391 error. I don't have the time to hunt it down at the moment,...

How about using the built-in Datetime transformation task ??

No license is required as long as you connect to a licensed version of SQL Server.

Open Query Analyzer on your machine, or the local server, and you should get a dialog prompting you for connection details. Put in the exact same details you are using when...

Have you tried logging in to the remote server using Query Analyzer? Maybe the username and/or password are different on the remote server.

Are both servers running mixed mode authentication?

For the "made using this security context" option, did you use an SQL Login that has be defined on the remote server?

You can setup a linked server easier using T-SQL...

When defining the linked server what options/entries have you put on the Security tab?

"i have enabled mixed mode authentication.even then its not displaying the intended result."

So does this mean you can connect to the linked server and get results, but your query is...

So is this for the insert/select part, the delete, or the whole lot?

When you remove the records from the table, SQL removes the entries from the index as well, so...

The main thing I hate about sqlmaint is it's all or nothing approach.

Generally, what I would be doing is checking for fragmentation first using DBCC SHOWCONTIG. Then just reindex, or...

Many ways to achieve this, try each and pick one that suits your need best. Also, be aware that depending on how you've designed your package you may need to...

When you execute,

exec master.dbo.sp_msforeachdb 
"USE [?] 
BEGIN
SELECT '?'
EXEC sp_helprolemember 
END" 

by itself in Query Analyzer you will see that seperate resultsets are returned. You can't insert seperate resultsets...

Try these,

http://support.microsoft.com/default.aspx?scid=kb;en-us;873160

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

How about this to show the last weekday in the month ?? The important bit is the first line.

SET DATEFIRST 1
DECLARE @MyDate datetime

-- example 1 with end...