Check out ..

http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/

This shows how to use notification services to setup login alerts/auditing.

Thanks.

Mohit.

I agree with Noel, I provided the links. But if you were willing to post your queries, and execution plan I am sure someone here can help you out...

Another argument I like to use for not giving Server operations/Network operations access to SQL Server is it makes it hard to manage the server. When there are databases,...

I see ..

It is usually easier to provide an answer if you provide a CREATE TABLE and sample data .. If you can do that I might be...

I think he might be referring to the MARK function in the "BEGIN TRANSACTION"; which can be used for recovery and such.

However I have never tried to set MARK while...

Do you get an error when trying to get a listing? If so can you please paste that here?

What permissions does the security role have? Can it be...

The DMVs for missing indexes are not without fault; because you got to realize that these information is correct only until last recycle of you server. And the DMV...

Actually in 2005 ..

Simply this will give you that information also 🙂

SELECT * FROM sys.databases

Look for column Recovery_Model_Desc.

Thanks.

If field B is an integer then you can use ...

SELECT A, MAX(B) AS B

FROM Table

GROUP BY A

Thanks.

When executing dynamic SQL, you need to use

EXEC (@SQLStatement)

Those brackets tell SQL Server it is not a store procedure call.

Thanks.

Urg. Correct; sorry must have been running low on caffeine. Sorry for the mix-up ..

Mohit.

I am not quite understanding what you mean ...

Are you saying you prefer to install it using Command Prompt instead of the installer interface SQL comes with?

Mohit.

Not with SQL Server.. but you can do this:

Restore the database in another database with different name.

Drop Table (or truncate)

Recreate table (if dropped)

Then copy all the information over.

Thanks.

From BOL:

DBCC CHECKDB

[

[ ( database_name | database_id | 0

[ , NOINDEX

...

This is not repair so you can...