What will happen to your trigger if someone inserts data of multiple ProjectID / ProposalID / SolutionId / UnitID in a single batch ?

Keep in mind exceptions do occur !

e.g....

- I haven't played much with "merge", because of the issues with it I hear from time to time.

I think you should remove the "values" keyword before the select top...

- You are still using the deleted object in the insert trigger.

did you try the easy way ... split the trigger in two ?

1 trigger only for inserts

1 trigger only for updates

In such case, I would shrink the mdf file to an appropriate size and monitor its growth to prevent your application to go down because of the database restrictions.

If you...

SQL2008 R2 Express edition database size is limited to 10GB.

Solution?

- split the database

- drop/move some data

ref: Features Supported by the Editions of SQL Server 2008 R2 http://technet.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx#Scalability

Sreejith! (8/19/2013)

---

Thanks All

But the files(txt,mdf,doc,excel,zip) in the 'test' directory doesn't have proper time stamp, which help us to determine whether these files has been placed in the folder for more...

Technet topic "Partitioning Unique Indexes" states:

When partitioning a unique index (clustered or nonclustered), the partitioning column must be chosen from among those used in the unique index key.

NoteNote

This restriction enables...

With linked servers, the provided logins are always SQLUsers ! ( no windows domain accounts )

I don't use linked servers to gather inventory information from my sqlserver instances.

I use...

ananda.murugesan (8/14/2013)

---

Hi

ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Instead of above query, can we run as below query for make it online in MIRROR Database..? Mirror database always sychronizing/Restoring mode. wheather High...

Of course, testing it is fairly easy to do and the preferable way before implementing it into production.

Walk through all scenarios and test the actions before you need to apply...

Did you have a look at BOL ?

Forced Service (with Possible Data Loss) http://technet.microsoft.com/en-us/library/ms189977(v=sql.100).aspx

it has a ref How to: Force Service in a Database Mirroring Session (Transact-SQL). which...

1) centrainly not a good practise to use sysadmin privileges in regular aps.

(even for testing ! The sooner you encouter a security issue the better !!)

2) are you getting an...

Just my 2 ct.

You're still running SQL2008R2 RTM version.

Current is 2008 R2 Service Pack 2 ( and if you also do the CU it is on CU7 for...

does the sqlserver service account of your target server have the needed windows auth to read the backup file at the location you pointed to ?