You need to set the nested triggers option of server configuration settings to 0 to stop the engine from executing the trigger recursively using the following snippet...

USE master;

GO

EXEC sp_configure 'nested...

You can add column with a unique combination of the existing columns or you can use newid() function to have a 25 characters long unique value..

It would be better if we can have a filter for unanswered questions, in case if anyone wants to check for unanswered questions....:P

Thanks Ken for your response..

Initially, I'd the same thought of using Count as the criteria for filtering the rows..

The...

ECHO OFF

CLS

SET FilePath=C:\MySQLFiles\*.sql

SET MyServer=NameOfTheServer

SET MyLogin=LoginName

SET MyPassword=Password

SET MyDatabase=DefaultDB

FOR %%i IN (%FilePath%) DO osql -S%MyServer% -U%MyLogin% -P%MyPassword% -d%MyDatabase% -i%%i -o%%i.log

Andras, seems like you've a bad experiences with synonyms....

And also you can't have a synonym on a database...

The problem only yells at you when you have so many objects that...

Keeping aside the execution plans, the time constraint...here is one of the solns...

SELECT * FROM databaseimageslist

WHERE LOWER( DatabaseImagesList.Path + DatabaseImagesList.Directory + '\' + DatabaseImagesList.FileName ) NOT IN( SELECT LOWER(...

Keeping aside the execution plans, the time constraint...here is one of the solns...

SELECT * FROM databaseimageslist

WHERE LOWER( DatabaseImagesList.Path + DatabaseImagesList.Directory + '\' + DatabaseImagesList.FileName ) NOT IN( SELECT LOWER(...

Basic stuff...

SELECT COALESCE( WCAmount, 0 ) + COALESCE( WCHours, 0 ) AS Total FROM worktime

WHERE WCid = 'WC11111'

OR

SELECT ISNULL(

You might have a look at GUIDs...

SELECT

NEWID()

Jeff,

Thanks for your response...

Honestly saying, I doesn't have much idea about MLM systems...

Anchelin,

Here is one of the ways to know the state of ther service...

EXEC master.dbo.xp_ServiceControl 'QUERYSTATE','SQLServerAgent'

Keep in mind that xp_ServiceControl is undocumented and unsupported as its...

Jeff,

Nothing much....it just sums up the incomes for which we all are working....a payroll process

When I started this post, I was in context for #tables & the user tables which...

Darth,

seems like still looking for a soln...to be left in the middle of the con

Looking at my query, I notice that i mistakenly used...

Karna,

Basic stuff again....

This error is because you've not specified the logical file names for the backup file.

Use RESTORE FILELISTONLY to get the list of files associated with the backup file.