Check my blog for some basic stuffs

http://venkattechnicalblog.blogspot.com/

Post the error to use, Please try out with this query

CREATE PROCEDURE OrderID

@OrderID NVARCHAR (40)

BEGIN

AS

SELECT T_OrderHeader.OrderID,T_OrderHeader.CustomerID,T_OrderHeader.ShipCountry, T_ICPAudit.ID,

CONVERT (MONEY, (T_ICPAudit.Amount)) AS Amount,

...

Hope the below article may be useful for you to achieve your task,

http://venkattechnicalblog.blogspot.com/2008/07/to-fetch-all-constraints-in-sql-server.html

Hope,

The below article will help you,

http://venkattechnicalblog.blogspot.com/2008/07/retrieve-owner-of-database.html

Hope this article will answer your question,

http://venkattechnicalblog.blogspot.com/2008/06/finding-subdirectories-and-directory.html

Hope this will help you,

select * from sys.columns a inner join sys.objects b on a.object_id=b.object_id

where a.[name] = 'last_update_by'

Hope you had a huge task to achieve ...

for this you can opt.. Bulk insert task in SSIS or ordinary BCP to load your data.

CPU time will show the amount of time (in milliseconds) taken to execute your query.

Read will indicates the number of reads done to execute this query.

Writes will show, how many...

If you are not specifying anything in the input... you oledb destination will check for the input column else it will automatically populate null value

Since, the path of the source and destination is different, you have to opt .. package configuration wizard to create XML configuration.

Using DTSconfig option you can deploy your...

Yes changing the connection settings to TCP/IP and Named pipes is the best option.

Go to SQL server surface Area configuration and do the same.

Regards,

Venkatesan prabu .J

http://venkattechnicalblog.blogspot.com

To my experience, Instead of writing huge T-SQL scripts. Its really pain and there may be a possibility to miss some data in the older version.

Please proceed with upgrading the...

You can do it by using backup option. Take the back up of your db and restore it ..

dont forgot to change compatibitily level of the database to 90.

Else you...

Below query,

select count(*) from table

will fetch you the count of rows in your table.

If you have date column then you can modify the query like,

select count(*) from table where datecolumn...

Thanks Hari..

I got it ..