Hi,

Which row's values of the duplicate key do you want? There are several ways you could do it.. perhaps somthing like:

INSERT INTO dest VALUES (

SELECT * FROM tbl o INNER...

Hi there,

you get get some corrupt databases from here: http://blogs.msdn.com/sqlserverstorageengine/default.aspx there are a couple of posts http://blogs.msdn.com/sqlserverstorageengine/archive/2007/04/20/and-an-example-corrupt-2000-database-to-play-with.aspx.

Tony Rogerson also has a blog post on how to create a corrupted...

See my response here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=360675

- James

Hi Will,

You can set up a service dependency (http://support.microsoft.com/kb/193888) - you should make sure that you check the restart options etc via the services control panel once you have...

Hi Rod,

I'm not sure there is particularly other than the advantage of using a stored procedure from your code rather than dynamic sql (which is some what of a religous...

I would probably create a string with the SQL I want to execute in it - IE: SET @sqlStatement = 'SELECT * FROM '....  then use sp_executesql or EXEC..

- James

The add/manager user functionality is now under Security -> Logins in the object explorer. Right click on the logins folder to get options such as new login.

You can change the...

Heh, you are right Andrew,

my bad.. I obviously spent too long programming with MySQL

- James

Hi Dinendra,

Have a look at the TOP keyword in SQL Server Books Online and also the LIMIT keyword. The TOP keyword allows you to select the TOP n rows from...

Hi there,

You might want to look at computed columns in SQL Server Books Online (BOL) as this might well give you what you want without having to run the script each...

Have a look at sp_databases (http://msdn2.microsoft.com/en-us/library/ms176070.aspx). You might want to check if the database size includes log files or not.

- James

Hi there,

I have yet to come across a standard way of formatting SQL (or even one I really really like) however I do use SQL Prompt and SQL Refactor (14 day free...

If you want a list of the logical file names then you can do a RESTORE FILELISTONLY FROM <backup device> (http://msdn2.microsoft.com/en-us/library/ms173778.aspx).

- James

OK,

A variation on Steve's way is probably best then,

Somthing like:

SELECT * FROM

(SELECT a.employeevoip, SUM(a.hours) [InboundHours], SUM(a.mins) [InboundMins], SUM(a.seconds) [InboundSecs], COUNT(*) [IncomingCount] FROM [phonelog] a WHERE a.direction = 'INCOMING' GROUP BY a.employeevoip) incoming

LEFT JOIN

(SELECT b.employeevoip, SUM(b.hours) [OutboundHours], SUM(b.mins) [OutboundMins],...

A few more things which might turn somthing up (as we seem to be on a fishing expedition here)...

What other software do you have installed on the server?

Do you...