How to enter manually a "uniqueIdentifier" type value

I created a DB and a table in Visual Studio .NET 2003. For one of the column
I choose the data type uniqueidentifier.
How can I add manually a unique ID value in the table value editor?
OK, figured it out: select newID() as the default value.
"Frank" <someone@.nospam.com> wrote in message
news:c5f6j4$dpe$1@.news.mch.sbs.de...
> I created a DB and a table in Visual Studio .NET 2003. For one of the
column
> I choose the data type uniqueidentifier.
> How can I add manually a unique ID value in the table value editor?
>

How to edit backup history

I am using SQL Enterprise manager to manually backup test databases on
my PC.
As time goes on the list of backups is getting long and cumbersome,
and I no longer need many of them
Is there a way I can remove entries from the backup history for a
specific database to tidy up the even increasing list.
Thanks for any help
RichardF
Hi,
Use the system procedure:-
USE msdb
go
EXEC sp_delete_backuphistory '07/20/2004'
Deletes all the history older than july 20 2004. But there is no option to
clear the histories for a sinle database
Thanks
Hari
MCDBA
"RichardF" <no.one@.no.where.com> wrote in message
news:41114edb.172348764@.msnews.microsoft.com...
> I am using SQL Enterprise manager to manually backup test databases on
> my PC.
> As time goes on the list of backups is getting long and cumbersome,
> and I no longer need many of them
> Is there a way I can remove entries from the backup history for a
> specific database to tidy up the even increasing list.
> Thanks for any help
> RichardF
|||There is a separate proc to delete the history of a single database:
EXEC msdb.dbo.sp_delete_database_backuphistory dbname
You cannot specify a date however - it will delete all the backuphistory data
JustinR
"RichardF" wrote:

> I am using SQL Enterprise manager to manually backup test databases on
> my PC.
> As time goes on the list of backups is getting long and cumbersome,
> and I no longer need many of them
> Is there a way I can remove entries from the backup history for a
> specific database to tidy up the even increasing list.
> Thanks for any help
> RichardF
>