how about a maintenance plan with an Execute T-SQL task in it?

I've seen this where the design team ideally want to separate out databases onto separate servers but when it comes to deployment the costs involved mean the separate servers become...

Is the table called Empdetails? If it is then the syntax is drop indexTestIndex on Empdetails

With the syntax you are using, SQL is looking for a table...

If those are the only oracle services you have then it sounds like you haven't actually got a database set up. There should be a tool installed that will...

do you mean that you want to store text and search it or have a table where the contents are sorted? If it is the first then you need...

You have two nodes which have their own IP address. You then have a cluster resource sitting on top - this resource has another IP address and will run...

I've not had this problem when servers have been removed - I can remove them by right-clicking on the server registration. In 2005 you can export the registered server...

do you get an error when you try and drop it?

I agree with Abhay.

Don't think there is an equivalent to sequences in Oracle. You need to create a table that contains the number, read it via a function and update it afterwards.

So sounds like not everyone is applying the server patches - in our place the server and security team insist on them?

We do ours every month due to server patches

We've got similar issues. You might be able to see when the database was last used by looking into the tables - there might be a column containing a...

Backups are generally smaller than their associated databases so you may get away with backing up the 10gb db to a 5gb drive. However you will probably also want...

As new versions of SQL Server are released, certain features or ways of doing things change. So something that worked in an older version of SQL Server may not...