fpoon,

I am getting a popup window with the Wizard even if I do in Excel File->Open and navigating to the file. Everything opens in one cell if I double-click on the...

SQL Server 2000 was released in 2000 before the Web Services with all other .NET stuff was available around 2002.

As for Elegant Solution - you may upgrade to SQL Server...

I agree. There are 2 places to store depending on the size.

Also, someone says that if you use conversion functions to convert from a smaller data type to varchar(max)...

Jeff,

If I save the output of a GRID as CSV it saves it WITH commas because it is CSV. And if I save them as "ALL Files" it saves it...

There is no difference in Notepad between 2 outputs, same as in Wordpad.

The output from 2005 is in Unicode, this is correct. The only(?) problem that the database fields...

In this case I would really advise to take a FREE class on Microsoft Learning website. This is a 6 hours online self-paced class, free untill November 2006

Course 2936:...

You may use a DOS script using dsquery (from the server machine) or dsget utilities.

Hello,

I do create a login who has a a db_datareader role in the database that has to use this additional query tool. We do have a couple. Also, for one...

Madiha,

You can grant db_creator role membership. But if you don't trust this person than I would tell him/her to submit the db creation script to me and run it myself...

Madiha,

Your #1 (sp_changedbowner) will help. I always run sp_changedbowner 'sa' (or other login name) when I have a similar situation.

Why did it happen? Developers mostly connect by default through their...

Hi,

UDP Port 1434 is for Microsoft SQL Monitor service. Service pack 3 or 3A fix possible worm problems, we are told.

I think it is not so much credentials as a Firewall issue. I do have cases like that with exact same error message. The problem is that the firewall is...

That is what I am actually doing: selecting into the temp table, as Pam says. The example that I posted above is a part of my code that inserts into...

Hi,

I use '''' (4 single quotes) instead of the single quote inside the outer single quote. Here is a beginning of my long statement (for example, this example connects...

You may want to look at database mirroring, see

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Database Mirroring in SQL Server 2005

This is sort of a White Paper. I was told that it will be officially...