use Microsoft SQL Server Database Publishing Wizard, using this tool you can take backup object wise.

Link: http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en

SQL 2005 new features not supported in SQL 2000.

if you use nolock, you will get all the records (includes all uncommited transactions) but result is not accurate, if you are not using nolock, query will be wait till...

re-download the sp4 for SQL Server 2000 and installed it. Still problem persists, you can backup the respective databases and repair the SQL Server and install SP4.

First you need to install relevant JDBC / ODBC drivers to access SQL Server 2000 and below version, for SQL 2005 and above you need install SQL Native Client for...

if @db is int then you get the result.

try like this:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

set nocount on

go

alter proc dbo.inow6_AlterDatefield

as

begin tran

update in_doc

set F3 = stuff (F3, 3,1, '/')

from in_doc

where creation_usr_id = '2000000001_00011B3EPCXJ'

and creation_time >...

need more information (exact requirement) about question ? so that I can help.

Enable BCP option thro' SQL Server Surface Area Configuration.

or use sp_configure command

Just insert the DVD / CD and then choose repair or modify VS & SQL.

Generally "Times New Roman" font.

FYI:

http://www.sqldev.net/xp/xpsmtp.htm

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21603633.html

http://www.sqlanswers.com/Software/SAM/Help/UsageGuide.htm

good example

try like:

select*

fromINFORMATION_SCHEMA.COLUMNS

whereCOLUMN_NAME = 'your column name'

go

one of the best method to upgrade from SQL 2000 to 2005 is attach and detach the .mdf files.

one more command available in SQL 2005, TableDiff.exe, try this command, for more info. see SQL BOL.