Ok here is a quick solution, no guarantee that it's the best or most efficient

declare @dte datetime
declare @dob datetime

set @dte...

The function provided by Ray works. You need to add a GROUP BY to the SELECT statement though.

EG:

SELECT [id], dbo.fn_ConcatStrings ([id])
from mytable
group by id

will give you

1 aaa
2 bbb
3 ccc,ddd
4 eee
5 fff,ggg
6 hhh

Check sp_changedbowner in Books Online.

That would be sp_change_users_login.

You still need to have the logins on the development server though.

Try these

http://www.sqldts.com/default.aspx?297

http://support.microsoft.com/?kbid=247527

http://www.sqldts.com/default.aspx?237

The page splitting will only occur if you have the uniqueidentifier as a clustered index. A Primary Key does not necessarily need to be a clustered index. That's just the...

Here is a list that's a mixture of applications and embedable controls,

http://www.devdirect.com/ALL/REPORTING_PCAT_1897.aspx

If you're importing data into SQL Server you should look into using BULK INSERT instead of BCP as it is quicker.

And this one as well,

http://support.microsoft.com/default.aspx?scid=kb;en-us;814398

Try this,

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53340

Check Windows Event log for any error messages.

Check to see if the SQL Server service is running.

Ok, gotta join this party

Windows VirusScan 1.0 - "Windows found:...

I'm with Jeff, this doesn't need a function(s), although I'd attack it a bit differently.

CHARINDEX finds your first space and gives you Firstname, REVERSE & CHARINDEX will give you the...

It's amazing what can be found in Books Online and Google when one takes the time to look

What version of SQL Server are you using?