Getting ip adresses is somewhat painful as there is no built in function.

However, David Burrows provided this workaround a while ago

declare @ip varchar(255),

@cmd varchar(100)

set @cmd = 'ping ' +...

Hehe, I think I can top it. I just received a mail that obviously was sent from the old forum.

Sender was forum@sqlservercentral.com

Subject was [Data Transformation Services (DTS)] Creating a...

Hmpfh, can't edit my post...

I didn't mean '...and enough underwater with me...' but rather '...and have enough underwear with me...'

But your flower, Brian, is not bad at all

Don't give up. Go back and try again. Sooner or later it will work

Just for fun. You can also dynamically execute dynamic SQL like this

DECLARE @stmt NCHAR(1000)

SET @stmt = 'USE Frank_3 ' + CHAR(13) + 'DECLARE @stmt NCHAR(1000)' + CHAR(13) +

           'SET...

http://www.algonet.se/~sommar/dynamic_sql.html 

Sorry, for once again posting this link. I'll compile my own article on this, so I don't need to refer to that site.

You mean something like this

PRINT 'This is the first line'

+CHAR(10)+CHAR(13)

+ 'This is the second line'

Nope, Sir! That's not my intention!

Meanwhile I've seen the movie four times with my son in cinema. He can recite most parts....

This site http://www.databaseanswers.com/data_models/ has quite a few basic data models available for free. Maybe it is of any help to you.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=19701 might help you. And please post in the appropriate forum category.

Finally it hits me. Forget my last post

...but no solution anyway

Sorry, still waiting that my wife has read her books so that I can start

Problem with no being allowed to type in the...

Hm, maybe it's too late or maybe I'm too dumb

Why is there a GROUP BY in your query?

May you please explain very slowly...

On the http://www.sqlservercentral.com/forums/userinfo.aspx?id=67108 Profile Information page it states a incorrect number of posts. In my case 2519, while I'm actually on 2530.

On the Active Topics page I get an error when clicking on Next 15 or Last.

Object required