hi there,

here is what i would recommend you.

1. take a backup on your server (on which SQL Server is installed)

2. then write a copy command to copy the backup to...

i had a similar kind of an error when i created a linked server between SQL Server and Access (MDB file residing on my local machine).

i would suggest you to shrink the database on a regular basis.

if i would have been in your place, i would not wait till an error is thrown up or...

hi there,

here is an answer to your question.

hi,

i have never used this software but just heard about it.

see if it gives you the expected results.

http://www.dirig.com/solutions/sams/sql_server.html

-- Parag

here is what you can use... replace replace the appropriate values

Microsoft® SQL Server™ 2000 returns error 1105 and sets the status column of sysdatabases to suspect if SQL Server is...

hi there,

could you be more specific about the data. the data you have given is not sufficient to come up with a query that you need.

can you put some real...

hi,

in your case if you really need to store more than 8000 characters in your row, i would then recommend creating a field of the type "TEXT".

the way a field...

Hi,

you could be facing this problem due to the datatype support.

please check the documentation of the driver to see what data types...

Hi Frank,

In order to make sure that you ask SQL Server to use all the CPUs you have on the server, follow the steps below:

1. open enterprise manager

2. go to...