Viewing 15 posts - 496 through 510 (of 525 total)
I've never had this problem but this sounds like a hardware maint issue.
As a guess, the OS is on a local C: drive and the data/SQL Server is on a...
July 6, 2004 at 8:20 am
This is the UNC:
\\whse\Drive_I\Stuff\BACKUP\DB2_1_of_5.BAK
The "Drive_I" is the share. The drive letter refers to the fact that the WinXX creates a default share of %drive letter%$ such as "C$" by default....
July 2, 2004 at 2:09 pm
Most likely because of the single quote marks when you feed it in the asp script.
Try
(f.files_path = ' + char(39) + 'D:\entirepath\withFile.bmp' + char(39) + ')'
July 1, 2004 at 10:21 am
I have a database on an MSDE server that can't be moved onto a real server. I'm using a scheduled DTS package to read from the MSDE and then write...
July 1, 2004 at 10:10 am
I wrote the following procedure when the SQL Server agent on the server broke. I set this as a scheduled task to run from my PC with the query analyzer.
It...
July 1, 2004 at 9:48 am
To SA24:
Samll but important point :
By default, SQL Server does use the System account. But you can change it, and have to for...
July 1, 2004 at 7:42 am
The domain controller is generally another server in the network.
Another thought....does the SQL Server have a second NIC? Maybe hang a second cable out to a spare switch/hub and a...
June 30, 2004 at 4:36 pm
Assuming your SQL server is not a DC......and if it is a/the DC this can be some very bad juju......Go to a domain controller -> Control Panel -> Active Directory...
June 30, 2004 at 3:26 pm
You can't backup the data/log files using Backup Express, ArcServe or other backup SW while the SQL Server is running. This is because the SQL Server keeps the files permanently...
June 30, 2004 at 3:08 pm
It sounds like your SQL Server and SQL Server Agent doesn't have write/create permissions on the distant directory. To prove it, log onto the SQL server as the SQL servers...
June 30, 2004 at 2:40 pm
We're just exploring clustering ourselves.
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/clustering/scconbp.mspx
The big thing is that there is no real load balancing for SQL Server in a clustered environment. If you are doing...
June 30, 2004 at 8:01 am
Can you access the database at all? It sounds like it.
My suggestion is to stop beating on it. And start fresh.
1) Get a good backup.
2) Create a new database, preferably...
June 29, 2004 at 1:33 pm
Go in the EM and select the table, right click on the table and select all tasks -> manage indexes.
That should show you all the indexes and their key fields.
June 29, 2004 at 12:36 pm
try
select *
from sysobjects
where id = #
But it is beginning to sound like the DB is corrupted in general. Another way to do this is take the DB offline and...
June 29, 2004 at 10:22 am
Did it give you the table name it errored on?
Run the following query (modify as necessary):
------------------------------
SELECT *
FROM tablename
WHERE indexed_field IN
(SELECT indexed_field
FROM tablename
...
June 29, 2004 at 9:43 am
Viewing 15 posts - 496 through 510 (of 525 total)