I was looking for an option that will say that the query will cause an error (because of the missing group by) but I didn’t find one. I ignored...

You cannot compare null with the an equal sign (=). When you check for null you have to use the is null or is not null operators. Take...

Krishna (3/17/2009)

---

That sounds good to me, but how heavy is the table getting modified. 90% FIllfacotr prone to more page splits, if have this setting and if there is...

Here is one way of doing so:

select noo, namee, min(SourceName)

from (

select distinct noo, namee, 'a' as SourceName

from samm

union

select distinct noo, namee, 'b'

from sammM) dt

group by noo, namee

I...

If you want to add a new column with...

After your last message, I looked for more information instead of using my memory, and I have to say, that you might be correct. When windows 2000 is used,...

I think that I understand you now. Instead of using one update statement that updates all the records, you are looping through the records and updating each record with...

parth83.rawal (3/16/2009)

---

I understood, but i am using this Trigger to fire my mail, which i need to fire after all the updation takes place on the table then and then...

If I understand you correctly, both instances are not configured to use awe. If this is the case, none of them will be able to use more then 2GB....

Triggers don’t get fired for each record, they get fired for each statement. This means that if you ran one update statement, the trigger will be executed exactly one...

If you are not using the 64 bit edition, you can’t use more the 2GB without configuring the server to use awe. If you are not using Enterprise edition,...

If you don’t have a backup of this database, you can modify the files’ names, then create a new database with the same name and files’ structure as the old...

You query the data the exact same way that you query a database that has only one MDF file. When you issue any SQL Statement you don’t have to...

You can find an explanation here – http://msdn.microsoft.com/en-us/library/ms191516(SQL.90).aspx

Adi

The permissions that users have in the DB are stored in the user database and not on the server level. There is no need to script those permissions if...