I had a friend that had a multi-client scenario where each client had their own database. They had a central database with some common information which was replicated to each...

Correct, you must user server software for server versions. If you are trying to save money on licensing the server, you won't. You'll get yourself into trouble if you figure...

If you have some idea of the path that will come in, you can search through it with Charindex to find the last "\" and then use substring to get...

If you have the data, that's the way I'd go.

I was going to suggest using backup sizes, which is how I've tracked database growth over time. I have autogrow set...

This looks like homework. You ought to be able to easily search out the first and third items. A few links for you to read:

http://blogs.msdn.com/craigfr/archive/2006/08/10/687630.aspx

http://blogs.msdn.com/craigfr/archive/2006/08/03/merge-join.aspx

http://blogs.msdn.com/craigfr/archive/2006/07/26/679319.aspx

I'm with Jeff. I like them in separate fields, and then assemble them in another field if needed. As numerics they sort well, and the separation to me makes it...

How much data are we talking about? Is there a reason you don't want to move the whole db?

Most people I know transfer data in bulk at specific intervals so...

If you want to learn BI, I'd start with some of the books out there on the technologies. Work on SSRS, SSIS, learn some of the ways in which the...

If you know the data was stolen, you need to treat it like other stolen property. Report it, document your knowledge, don't misuse it.

As GSquared mentioned, knowledge is punishable.

you might try tracing the task and see if something else is being called

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...