Actually, the issue is that the login is already mapped to a different user. In this case, the user is called "\SW".

Drop the database user \SW and then you can...

Always backup your system databases!

Before trying anything drastic, I would look at the data in those tables on a different instance and try to figure out what data needs to...

It depends. Small data sets will usually perform better with the CTE whereas large datasets will usually perform better with a temp table. Regardless, the best answer is to test...

If you're going to store it as MMYYYY, I would store it as an int, not a date or datetime. Otherwise, it will be converted to a different format.

mah_j (11/24/2013)

---

My table just has 2 fields : id that is uniqueidentifier and a nvarchar() it is about 1G and has 525400 rows.

how can I put the clustered index somewhere...

Only backups are listed int he backupset table. Restores are tracked in the restorehistory table.

Vedran, when I got the news last night, I immediately thought of you and how you just took the exam a few days ago. I hope you pass the exam...

Yes, it does mean that. No MCSM for anything.

I hate to be the bearer of bad news, but all of the MCMs and MCAs got an email tonight (10 PM on a Friday night before a holiday weekend)...

Excellent advice, John!

I saw in...

The reason that len(cast(0.28999999165535 as float)) returns a length of 4 is because the LEN() function accepts string or binary data which means an implicit conversion has to occur before...

There isn't a logging aspect any more. There's is only doing.

first of all, use square brackets around the database name:

ALTER DATABASE [SharePoint_AdminContent_e96sd86f-ec29-46655f-b9562a-d0cgch77d3c46] SET ........

I will disagree with Denny on one very small point. I think you should bring in the consultant now, not later.