Hello Michael,

You can't enter any value in the timestamp datatype column. SQL Server automatically generates binary numbers which are guaranteed to be unique within a database.

Coming to Identity column. There is...

Try this one:

Select [Order Number], min([Date Received]) From OrderDetail

Hello John,

I'm not aware of the correct answer you require but would suggest you to go through the help available in SQL 2005 Books Online for topic

Connecting to SQL Server...

Hello Michael,

What do you mean by relocating?

You mean to move the files from one directory to another directory. if so, you need to detach the database and then copy over...

Hello Koci,

Have you created the necessary login on the SQL box?

Then in the client tools -> client network utility -> Alias tab -> Add button -> Give the server alias...

Hello Scott,

Please go through this link

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx

Thanks and have a nice day!!!

Hello David,

Go through one of the earlier thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=252302#bm252343

Thanks and have a nice day!!!

Hello Peter,

It seems there is no way in deleting the backup files as existed in SQL 2000.

Please go through this blog thread

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=213255&SiteId=1

Thanks and have a nice day!!!

Hello Alan,

Go through this article.

http://www.databasejournal.com/features/mssql/article.php/3514731

Have a nice day!!!

Can you post some sample data of the 2 tables, which will be easy for the workout?

Hello,

Try this one

Update ActiveUsers

Set Email = (Select Mail From Directory Where Empid = EmployeeID)

Thanks and have a nice day!!!

Hello Jan,

Please go through one of the earlier posts depicting the same problem of yours.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=185045

MS KB Article.

http://support.microsoft.com/default.aspx?scid=285833

Thanks and have a nice day!!!

Hello Andrew,

Please check SQL 2005 Books Online -> SQL Server Management Studio Keyboard Shortcuts

Thanks and have a nice day!!!

Hello Miquel,

Please go through Books Online -> UPDATETEXT

This can be used to change only a portion of a text column in place.

Explanation with example is available.

Thanks and have a nice...

Hello Stefan,

Can you check this information in Books Online -> Installing SQL-DMO

Check whether the said files are existing in the default location.

Thanks and have a nice day!!!