If table structure already exist, use BCP or BULKINSERT command.

Otherwise use select * into ]

Check the local area network DNS (i.e. TCP/IP) properties and other settings.

Try the following way:

declare@sqlnvarchar (1000)

set@sql= N'SELECT * FROM openquery (linked_server, ' + '''SELECT SERVERPROPERTY (''''ProductVersion'''') AS [Product Version]'')'

print@sql

execsp_executesql @sql

go

🙂

after that use DBCC UPDATEUSAGE ([DBNAME])

🙂

provide Windows 2003 IP Address in ODBC Configuration (instead of SQL Server name).

Note: Also check whether Windows 2003 server is accessable from Win XP command prompt.

Ok, use left (..., 15) only. Copy the below code and try it again.

selectreplace (replace (left (replace (replace (convert (varchar, getdate(), 120), '', ''), ':', ''), 15), '-', ''),...

Try the following way, it may help to you.

selectdistinct object_name (id) from syscomments where text like '% %'

Try the following way:

selectreplace (replace (left (replace (replace (convert (varchar, getdate(), 120), '', ''), ':', ''), 16), '-', ''), ' ', '') + '.txt'

🙂

You can see the BACKUP DATABASE command on SQL BOL.

you mean System Database or User Databases ?

> Copy the SQL Server Data folder into new location

> un-install previous version and install SQL 2005 / 2008 Express / Developer / Enterprise edition

> New you can attach the...

If you have MSDN Subscription, you can download Developer Edition from Microsoft.

This problem occurs SQL 2005 onwards., Generally DBA's change the SQL Server permission, i.e. means allow the remote users.

Check the Wrox Publication books. These books help to you.

First collect the entire spec for your project (including reports) and design them according. Depending on your daily transaction you can design the database up to 3rd or 4th...