If you already have this table in the Excel spreadsheet, just import it in SQL Server using DTS Import Wizard specifying Excel file as a source and a new table...

Hello Yuri,

Yes, it is possible.

1. If you are using DTS Import Wizard then in the window "Select Source Tables and Views" click "Transform" button and specify the data type that...

You have to read the source. The quote from the link has another link right after it in the article. This second link is to

http://support.microsoft.com/kb/315512/

which in turn has a...

Hi neotokio,

Krishnan's solution worked for me.  There are 2 things:

1. select @output=outputtext from #output

line just assigns the text to the variable @output. It does not print it out. you...

I would use the approach as follows:

job step should be of the type of Operating System Command. As a command I would do:

cscript myscript.vbs

and put all file reading and processing...

Never script with Drop option for any types of objects unless you are absolutely sure. "Generate the DROP command" checkbox  is on the Formatting tab of the Generate SQL Scripts window,...

Ramesh,

after you have everything in one woorksheet with the database name in one field you can create a macro in Excel that will create sheets based on distinct database names...

Sure you can. The authentication type is set on the server level, not on the database level. It could be Windows Only or Mixed (both Windows and SQL Server)

I knew that SQL Server per-processor license was required for the web applications in SQL Server 2000. I looked up the updated licensing page for 2005

http://www.microsoft.com/sql/howtobuy/processor.mspx

and it says it...

Sacha,

It was clear from the third answer (incorrect) and by the question itself: we all know that stored procedures are meant to be re-used, so they were asking about something...

The stored procedures can and should be re-used - means used several times. I answered correctly because from the suggested answers it was clear they were asking if a stored...

David,

I don't outsource these 2 activities to different people. I do both myself for my projects. As well as basic server support outside of the Infrastructure standard activities. You do...

Hi,

I tend to recommend App/DB server consolidation, not DB/DB consolidation. I prefer to put an application and its database on the same server as opposed to put several apps on...

First one:

-------------------------------------------

Select DISTINCT order_no from Table_A

Where key_col = 'XYZ'

-------------------------------------------

Second One

-----------------------------------------

Select order_no from Table_A where rev_no IN

(Select MAX(rev_no) from Table_A where name_col = 'XYZ'

   group by name_col)

----------------------------------------

You may move...

Hi,

Do select field1, len(field2) to make sure what is the lenght of the records. What is the need to use nvarchar(255) for thevalues as 0,1 or ''