Here is what I do to find orphaned users and sync the logins.

http://www.sqlservercentral.com/articles/Log+Shipping/63028/

Remember you need to have the logins created in the master database in order to be...

If the data is always in this format this should work.

declare @tst Varchar(6)

Set @tst = '280908'

Select cast(substring(@tst,3,2) + '/' + left(@tst,2) + '/' + right(@tst,2) as datetime)

What is the datatype...

You should be able to cast it.

declare @tst varbinary(20)

Set @tst = 0x74657374

Select cast(@tst as varchar(20))

If the value is NULL you can use ISNULL. If it is blank spaces you can use the Case statement.

Declare @tst char(10)

Set @tst = NULL

Select ISNULL(@tst,0)

Set @tst = ' ...

Can you provide a little more information? What are you trying to do?

Lewis,

The Dynamic Management Views are not available in SQL 2000, but I agree if you are using 2005 DMV's are the way to go.

You should still be able to connect to the expired server from another instance. I would connect and take a full backup of ALL the databases including the system...

It sounds like you need to sync your logins.

http://www.sqlservercentral.com/articles/Log+Shipping/63028/

These are the steps I use.

http://msdn.microsoft.com/en-us/library/ms345408.aspx

http://support.microsoft.com/kb/224071

I have always had to uninstall and reinstall if the evaluation has already expired.

http://support.microsoft.com/kb/914158

Here is an article that explains how to perform a dynamic pivot.

http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

Here is the fn_get_sql version, but it will strip out any statement that...

The code from the article does not copy/paste correctly, so I am posting it here. I have noticed that if you paste it into Word or Open Office it...

Here are a couple of links that may help.

http://www.sqlteam.com/article/search-and-replace-in-a-text-column

http://sqlserver2000.databases.aspfaq.com/how-do-i-handle-replace-within-an-ntext-column-in-sql-server.html

You can use the UPDATETEXT method.

http://msdn.microsoft.com/en-us/library/ms189466.aspx

Or cast the text as varchar(8000)

Update dbo.navigation_content

Set ...