You add/register an external DLL by using sp_addextendedproc.

This URL tells you how to do it.

a2zwd (7/27/2009)

I was given a job to design the database for my application.

What is the procedure to design the database.

I mean the tools, database design life cycle, any...

In 2000, after rebuilding master database, we need to attach each external dll files as extended stored procedures seperately. Not sure on how to do in 2005.

The first two lines from the post of Victor are other two methods on how to...

If the primary key is numeric and keeps on increasing, this code should just do fine.

select top 10 * from YourTable ORDER BY yourPrimayKeyColumnName DESC

Pls share some primary key values...

Do you have a date column on the table? or identity columns? you can query the table using ORDER BY clause.

They could have used atleast a synonym for the word checkpoint.:ermm:

That link was useful. thanks.:-)

I think this is...

The command i wrote would be sufficient. the other way is to terminate all open connections using KILL.

sqlcool (7/26/2009)

This is first time i am doing this pls help

I was told to restore(refresh) database every 30 mins i am getting files from server every 30 mins...

When the package failed, it must have rolled back which means whatever was inserted would be undone. Atomicity of a trasaction means either all or none. So either all records...

Delete the entry from registry.

Go to HKCU>Software>Microsoft>Microsoft SQL Server> 80>Tools>SQLEW>Registered Servers X> SQL Server Group

Check out for the group name from the same location and then delete the registry entry...

I dont think so. The database is in norecovery...

query the sys.schema view

select name from sys.schemas where schema_id in(select uid from sysobjects where name = 'PurchaseOrderDetail')

This looks like SQL Server wasn't able to write to the backup device. Check out for SAN Drive...

Pls go through This Article on understanding execution plans.