suser_sname() - http://msdn.microsoft.com/en-us/library/ms174427%28SQL.90%29.aspx

user_name() - http://msdn.microsoft.com/en-us/library/ms188014%28SQL.90%29.aspx

There are related functions in those links as well. Pick the one that suits your needs.

The guidance is first half 2010. I would guess it's a May/June release, but I have no idea. The Dev connections event is in March and should include the release...

If you have a question, please start your own thread with the "Add Topic" button.

Beyond what bitbucket wrote, the difference in those calls is dbo and sys are schemas. Schemas are buckets for organizing objects and applying security.

The dbo and sys are system schemas....

It seems that quite often people move sideways in a company. The best thing seems to be to get any type of job and then try to move over. Or...

What scirpt did you use? If you ran the sp_help_revlogin script, the logins are there. Logins are only at the server level. Users are at the database level.

Yes, just change the destination to 2005.

those statements will update EVERY record.

Are you using SQL 2000? You posted this in 2005, so I wanted to be sure. You could potentially do this in DTS, but it would have to be completely...

Gus, best of luck and hope things keep going through the holidays. Definitely sounds bad, and I know I'd be looking if that happened at RG.

I think part of the decision by MS was so they could use the VS framework, which gives them some nice features without a lot of coding.

However, I think it...

When you go to restart the database engine, it will ask you to stop the Agent, which is dependent on it. SSIS and SSRS shouldn't necessarily be an issue.

Dave,

Thanks for the challenge. Looking forward to seeing the entries.

Do you mean have SQL Server connect to a web service, not a client connect to SQL Server hosting a web service, correct?

There is a task in SSIS that can...

Cast the data first to char, then replace, then cast back. However I didn't think CHAR(13) was valid in a datetime field. I'd do a SELECt first aftetr casting to...