Mahesh

Try this.  But beware: if you have procedures of the same name owned by different owners then this will need a bit of refinement.

John

select o.name, user_name(p.grantee) from syspermissions...

I think you're safe using the SQL Server Service Manager to stop and start the services - it's the Services applet in Control Panel that you shouldn't use.  Having said...

Depending on what commands you are trying to execute against the databases in your list, something like this might be what you're looking for:

declare @db sysname

declare @sqlstring nvarchar(100)

set...

Perhaps the users who couldn't connect are all on the same part of the network, and connectivity between that part of the network and the SQL Server was lost.  Then,...

Had any configuration change been made before the restart that wouldn't take effect until after the restart, for example authentication mode, TCP port?  Check the users/PCs that can't connect and...

I take it that where duplicates exist in the column that is supposed to be unique, you want to insert one row only?  If that is the case, you will...

Brian

It depends on the format your full names are in.  Is it "Lastname, Firstname" or "Firstname Lastname"?  Are titles and/or middle names included in the full names?  How will you...

Yes, you can use a staging table, but you'll still have to deal with the duplicates in your data at some point.

John

I'm guessing that the connection your UserControl uses and the connection you use to execute the INSERT INTO statement have different values for QUOTED_IDENTIFIER.  Have a look at the SET...

And there are still users in the database that you can't delete because it says they own objects?

John

Not tested...

SELECT c.vcPostcode, COUNT(r.SFID), COUNT(t.iCALL_RESULT_ID)

FROM Customer c LEFT JOIN Contact_Result r

  ON c.SFID = r.SFID

LEFT JOIN Contact_type t

  ON r.iCALL_RESULT_ID = t.iCALL_RESULT_ID

  AND t.Description = 'SALE'

John

Mark

In the absence of any sample data, I've used the Northwind database.  This query finds the second highest value of Freight for each CustomerID in the Orders table.  You should...

G

You don't provide your table definitions, but I imagine that if you try to fit nvarchar(4000) data into several columns in the same table, it is unlikely to fit.  nvarchar(4000)...

Do you need objects owned by different owners, or are you aiming for the recommended practice of having everything owned by dbo?

The following query will give you a list of...

You do it in exactly the same way as you did the first one.  You will need a new IP address from your network administrator before you start, and you...