Curse those implicit conversions. Serves me right for not testing it more. :blush:

would something like this work for you. not what parsename is intended for but I think it does the trick.

declare @dec decimal(10,7)

set @dec = 87.01

select len(parsename(cast(@dec as float),1) )

http://www.microsoft.com/download/en/details.aspx?id=22985

This is the express version so you wont get things like profiler and DTA.

look at the options in both and if you do not need any of the features in enterprise now or in the future then standard would be sufficient.

http://download.microsoft.com/download/F/C/6/FC6006B5-866E-42C1-88F8-9AC4B8BC610D/WS%20Brand%20Pages%20-%20Editions%20Comparison%20Guide.pdf

By the looks of what you are doing the where clause (1=1) will actually be different when used in real code. if so try using CASE statement.

INSERT INTO TestResult(Total)

select case...

you can also use sys.master_files (http://msdn.microsoft.com/en-us/library/ms186782.aspx) to query all databases at once.

Are you getting the error on the copy job or the restore job? Also have you tried not using the hidden share but instead creating an actual shared folder?

Have a look at this books online article about joins http://msdn.microsoft.com/en-us/library/ms190014.aspx

What you probably want to do is join the IDS table to the IDCondition table on the ID columns. If...

Have a look at the sys.dm_db_missing_index_details (http://msdn.microsoft.com/en-us/library/ms345434.aspx)view.

also here is a blog post with some handy scripts using the dmv

http://sqlserverperformance.wordpress.com/2007/10/12/five-very-useful-index-selection-queries-for-sql-server-2005/

based on your very limited example a join and group by might work.

Read the link in my signature and post good example data and scripts and you will probably...

I am not sure how scalable this will be but it does do what you want it to for the sample data.

SELECT

t1.GroupID,

MemberList = substring((SELECT ( ' '...

I was able to add the login after I had failed-over the server to the other node.

My investigation into this led me to another question. When trying to add...

That was my first thought so I checked all the domain controller manually. They all appear to be correct.

When adding the login on any other sql server it works...

You can also use a cursor and dynamic sql like so

DECLARE @database nvarchar(100),

@sql nvarchar(max)

DECLARE c_Databases CURSOR LOCAL FOR SELECT name from master.sys.databases

OPEN c_Databases

WHILE (1=1)

BEGIN

FETCH NEXT FROM c_Databases ...

Might be that the database in question is on an instance that does not support log shipping. ie. express