Is traditional backup means native sql server backup?

If the answers is yes...

You can take take native backup for SAN attached databases... I do that everyday... 

You can take native backup as well as...

If you are talking about Ent Edtn --> Dev Edtn.

I think that is called downgrade not upgrade.

I think the function name is: DATE

I don't think it possible to add views to database diagrams..

Because it is disk problem... if you remove the one table from that problematic area on the disk by running the CHECKTABLE...

but when you insert the new data it writes to...

I am using the sP_help_revlogin since long time without any issues...

How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/default.aspx/kb/246133

Was your sql server 2000 also 64 bit?

Is your dll compatable with 64bit OS?

Adding an Extended Stored Procedure to SQL Server 

http://msdn2.microsoft.com/en-us/library/ms164653.aspx

I think your if statement doesn't make any sense to me syntactically... use the following...

if

(select sysjobhistory.status

from sysjobs join sysjobhistory on (sysjobs.job_id = sysjobhistory.job_id)

where sysjobs.name = 'MYJOB') = 4

Note:...

http://msdn2.microsoft.com/en-us/library/ms143470.aspx

Trusted connections between a Publisher and a remote Distributor are no longer supported because they did not require a password (trusted connections were used by default in versions prior...

Do you see any errors/warning is system log?

Looks like HW issue...

1. Backup your corrupted db and restore on to another server.

2. Run DBCC CHECKDB against restored db.

3. If you find...

How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/default.aspx/kb/246133

As mentioned before You can use SET SHOWPLAN_ALL ON or GRAPHICAL EXECUTION PLAN to find the query is using parallalism or not...And you can force by using MAXDOP option...

But SQL server optimizer...

Deploying SQL Server 2005 with SAN

http://blogs.msdn.com/sqlcat/archive/2005/10/11/479887.aspx

I don't know but try 4 part table name instead of openquery...

And Why are you using char(8000) when casting date column...Change it to char(10).

Then you should use DBCC CHECKIDENT.. read BOL for details...

http://msdn2.microsoft.com/en-us/library/ms176057.aspx