Some of the ones that I like are:

* Compression for Backups, Log Backups, Log Shipping, Database Mirrioring

* Compression in the engine for certain data types

* new data type

* SSMS enhancements...

...The way we found a quality person...

We had the luxuary of time to fill a position, so with this time this is what we did:

Position to be filled: DBA Administrator

Entry...

BACKUP DATABASE [Ax_Dev] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Ax_Dev.bak' WITH NOFORMAT, NOINIT, NAME = N'Ax_Dev-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

To Backup a table...

Hi

Is your DB set to FULL Recovery?

Do you have your logs backed up?

Can you set your DB's recovery mode to SIMPLE? - if yes then you can shrink Log File...

Hi

I would do it in the following manner:

if (select count (*) from Tablename) > 8

begin

drop table tablename

end

Hi Mary

It seems as if your version number is later than mine. If it is the developer version then it should work no problem.

If you change the setting and have...

Hi

If your tables have a primary and foregin key for the student for each table then you could create a SP or query that would be something like:

--//////////////////////////////////////////

declare @StudentID as...

hopefully someone has had a similar problem to solve and can supply us with a solution

good luck and let us know when you do resolve this issue

Thanks

Kevin

The above code assumes you can enable or use xp_cmdshell - but SQL 2000 this should be ok.

You also need to use the UNC path to the computer name as...

set nocount on

declare

@Path varchar (200),

@TheFile varchar (200),

@RestorePath varchar (300)

--select @Path = '\\servername\E$\Softwares\MS Studio 6.0\Disc 1\SAMPLES\VID98\DATABASE\'

select @Path = '\\jhb_kevinv_xp\c$\'

--Create temporary table with files lists

if object_id('tempdb.dbo.#tbltemp') > 0

begin

drop table #tbltemp

end

create...

Have you linked the servers and are you able to return data from the SQL 2000 server?

Hi

Yes the error trapping is happing after the call to the OLE/DB provider.

In 2005 there is a TRY CATCH syntax that can be used - that will allow a better...

Hi

I have also had a similar scenario - I would try the following:

* restart SQL Service if you can to see if the status changes

* does it give you the...

The server that you are running the query on and inserting the data into - if it can see the other server or the source server.

On your 2005 server -...

ok I understand a bit more about the backup device limitations.

Great - good to hear that all is sorted