Hi Rudy,

Script getting errors in #TrustedDB & #SQL_Server_Settings, these tables were not created and simply using in the query.

Also observed some place "=" sign missed on where clause as well...

Please send the complete details about ur requirements to following mail-id: kishore.pen@gmail.com

Is it possible to hold the CDC information into another database?. It means for example, I have database name call INVENTORYDB, have enabled the CDC for all tables on...

try the following way:

selecttop 10

name + char (13) + char (10) + convert (varchar (10), age)

fromemp with (nolock)

Hi Chandra,

If database have not enough space, at that time also you get this problem. I faced this problem long back, after I ran DBCC command(s) issue was resolved...

I think SQL Server 2000 Service Pack 4 may exist in your machine.

Problem may be ODBC Drivers or TCP/IP ports.

Run the following commands if server is offline:

DBCC UPDATEUSAGE ([DBNAME])

DBCC CHECKDB

DBCC...

use linked server or OPENROWSET to insert the data, for more info see SQL BOL.

when this problem occurred ? (means today or long back)

Could you please do the following:

> Check the Client Network Protocols of SQL Server.

> Possible, restart the SQL Server or reboot...

which ver. of SQL server using ?

while restoring the data, you can't access the data, once process completed, you didn't get this problem.

In SQL 2000, Query Analyzer give the \. Try it.

I think SQL 2008, IIS is not required, even if you configured, you can work like SQL 2005. Check New Features of SQL 2008 in MSDN site.

copy all the information into one single file and compile in your database.

mohamedek (5/18/2009)

---

Hi,

I try to Upgrade Sql 2000 to Sql 2005 the same instance and succeed. After upgradation try to run the my Dynamics GP then I got the following...

WebTechie38 (5/12/2009)

---

I tried using the data compare. I unmapped the columns and then mapped the two I needed.

However, when reviewing results, it doesn't give me any. It is...