What I heard is uninstalling SQL Server Reporting Services is very tricky and people

by mistake would uninstall SQL Server itself.

So I guess, deleting these reporting databases would be...

Dear All, Thanks for the response.

Got confirmation from business team that they no longer need these reports.

So, will delete them 🙂

There was once when I had to restore a database.

Due to some reason, connections continued to persist on this database because of which I couldn't restore.

To overcome this, took the...

You could find out if SMTP server is available from your server admin. Then, you could easily configure email notifications using database mail feature. Configure a database mail profile and...

This column is used in a where condition.

select * from tablea where columna = '1'

But I am not sure how the optimizer will use this non-clustered index on columna...

SQL server browser is running on both the source and target server.

But on target it is running on local account, wheras on source it is running on service account.

Do you...

Yes, both source and target are named instances

Yes, but still same error.

I am getting same error message when I trying to create a linked server.

SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

OLE DB provider "SQLNCLI" for linked server returned message...

Just one doubt, in SQL server 2005 we have reorganize, rebuild index tasks in maintenance plans

But in SQL server 2000 when we run optimization jobs, does it do rebuild of...

Sorry..to be clear.

The table is part of replication. It is one of the articles.

Eg. table A is present in both publisher and subscriber.

And this table A which is on subscriber...

Constraint violation has happened with a table not present in the Publisher database.

I posted this error on replication forum now.

Thank you All

This was really helpful

Any idea, how to get the command which this dbcc traceon(3604) is running.

But is there a way to get the index on a computed column?