Well thats a question that you need...

You should create individual Logins for each member of this department and add...

If you mean to take backup of all databases, you can user enterprise manager and create a maintanence plan that automates the backup process using scheduler.

if you wish to do...

there is no reference to identity_insert being set on.

also apply the patch suggested by microsoft.

can u paste the table structure, the exact trigger, the insert statement...

sry missed the condition...

where id in(select id from inserted)

AND deleteflag='Y'

I'm assuming a column is present in the table that uniquely identifies that row. eg ID

CREATE TRIGGER trg_test on test after UPDATE

AS

UPDATE test set deletedate=GETDATE() where id in (SELECT...

can u paste the portion of the code trying to paste the data... including the part of the code that is setting identity_insert to ON.

Also microsoft reports this as a...

Thanks Gail for your valuable comments 🙂

I think i understand the backup fundamentals much better.

Its 2000 and the database is online.

Was browsing through sql server 2000 KB, and I think i got the answer....

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

pasting an excerpt from the link..

you have a database...

Need some clarification on this...

-------------

Assuming I've 3 filegroups, primary1, secondary1 and secondary2

I take filegroup backups with log backups.

If i need to restore all files from secondary1 filegroup(assuming this filegroup resided...

had never used with File= clause....

Thanks it helped 🙂

You can move those four tables in a different database file. take file/filegroup backup. You'll be able to restore them.

http://msdn.microsoft.com/en-us/library/ms189906.aspx

http://msdn.microsoft.com/en-us/library/ms179401.aspx

.

1) We are initiate a new project and want to keep every configurable records changes we have done

2) we have a few group of poeple updating the Pri DB, we...

is fine... you can use that...

I'd also...