There is no hyperlink datatype as what you have in MS ACCESS you have to convert this datatype to varchar and use your application logic to convert that to hyperlink...

I know that microsoft has brought all your sql server related keys under a common folder Microsoft SQL Server. If you have more than 1 instance than there will be...

Did you read SSIS or Analysis services in SQL 2005. Might ne they will be useful for your requirement.

Just stop and start the services that enough. Once the agent service is started you will have the generic refresher in the sysprocesses may be with a diff spid.

Just stop and start the services that enough. Once the agent service is started you will have the generic refresher in the sysprocesses may be with a diff spid.

This is the microsoft KB article for permissions for sql server service accounts.

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

Yes this can be done.

insert into tablename exec spname parameters

remeber to have the values returning by your sp in the same order as the table column

Do you have service packs installed. If not trying going for SP2 and start your service and check if its ok.

Do you have service packs installed. If not trying going for SP2 and start your service and check if its ok.

Hey now i have found what the problem is. You are trying to invoke a exe from sql server. Remember that SQL Server is non interactive and you when you...

There problem might be because you are trying to enter a value for the restricted growth to a value lower than what is being used now. check the same and...

backup the database. Copy the backup file and then restore the same in the remote machine. Else use copy database wizard to copy the database to your remote machine.

Are you sure the registry key exists. If not there is a possiblity for you toget such a situation. Microsoft has replaced most sql server registry keys in 2005 so...

yes its possibel with xp_rewrite.

select convert(varchar(20),database_name)as 'Database name',

case convert(varchar(30),backup_finish_date,101)

when convert(varchar(30),getdate()-1,101) then 'Current Backup'

else 'Old backup'

end as 'Backup Status',

convert(varchar(20),backup_finish_date,101) as 'Backup File Date',

CASE type

         WHEN 'D' THEN 'Full Database backup'

         WHEN 'I' THEN 'Differential...