I was able to create a new table using the import/export wizard. The wizard was nice as it created the correct columns needed in order to hold the unicode...

Sometimes the logins become orphaned. Try running the following to see if any logins pop up:

USE <database_name>;

GO;

sp_change_users_login @Action='Report';

GO;

If you do have rows returned, here are the instructions on...

Dean Jones (8/3/2009)

---

Hi,

Just a quick question guys.

I was looking at all the edition comparison for SQL 2005, and it does say that SQL 2005 standard does use OS maximum for...

SQL_Easy_btn? (8/3/2009)

---

Background:

We built a server to replace 'ServerA' a production server, while we were getting 'ServerB' ready we had it on the domain. We could connect to the server using...

diane.payne (8/3/2009)

---

I'm trying to remove a user that is a dbo on several databases on an instance of SQL 2005. When I try to delete the user it give...

Thank you to everyone for your responses thus far. They are appreciated!

We believe we have a license agreement with WinZip - I will look into that further.

I...

The query is "as is" minus replacing a few strings with...

Jeffrey Williams (6/9/2009)

---

Can you post the query that is causing the problem? I would bet that it is because of the way the query is joined and/or how the...

Update: I have now confirmed that the query is trying to utilized more than 64GB of tempdb data file.

Mohit (3/23/2009)

---

When applying hot fix to active node SQL Server automatically applies to passive node (node defined as passive node for the instance you are patching) Only time you have...

Is there any easy way to determine if a hotfix requires the active node or includes desktop tools?

Thanks,

Jen

Sorry to report that we did not find a...

PaulB (3/1/2009)

---

oerr ora 28547

28547, 0000, "connection to server failed, probable Oracle Net admin error"

// *Cause: A failure occurred during initialization of a network connection

// ...

The location of the shortcut was the following:

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005

All, I was able to resolve this. I had updated the shortcut on my start menu to run SSMS as administrator. I found that running this would be...