Viewing 10 posts - 1 through 10 (of 10 total)
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...
June 27, 2005 at 2:00 am
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).
May 26, 2005 at 3:26 am
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...
May 26, 2005 at 3:21 am
here is an answer to your question.
In this excellent article Doug covers the basics of creating an Indexed View. He also goes...
May 20, 2005 at 1:26 am
i have never used this software but just heard about it.
see if it gives you the expected results.
May 20, 2005 at 1:16 am
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...
May 11, 2005 at 1:48 am
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...
May 2, 2005 at 5:47 am
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...
April 28, 2005 at 3:14 am
you could be facing this problem due to the datatype support.
please check the documentation of the driver to see what data types...
March 24, 2005 at 12:35 am
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...
March 17, 2005 at 2:28 am