Viewing 15 posts - 376 through 390 (of 541 total)
Do you still see these errors when you run that transaction job?
If yes and if there are more and more errors this post might be helpful
http://www.sqlservercentral.com/Forums/Topic653669-265-1.aspx
Refer to this article on...
June 23, 2009 at 10:52 am
You can use this stored procedure to scan error logs
June 23, 2009 at 10:24 am
Sometimes this error goes way after restarting sql server.
Run dbcc checkdb in msdb database.
if you see any allocation or consistency errors refer to this doc (only if you have backups)...
June 23, 2009 at 10:11 am
Are you using BCP between two databases with different collation?
This might help http://msdn.microsoft.com/en-us/library/aa196742(SQL.80).aspx
June 19, 2009 at 2:42 pm
You have to recreate all windows authentication logins in SQL SERVER because SQL SERVER cannot find them anymore.
June 19, 2009 at 2:30 pm
it's probably 64 bit cause you cant have 8GB of RAM on a 32 bit system max is 4GB.
Check index fragmentation and rebuild all your indexes.
Check disk fragmentation and defrag...
June 19, 2009 at 2:24 pm
YES
The backup is probably reading and writing to the same disk.
Separate the data and backup folders to different disks.
June 19, 2009 at 2:20 pm
May 29, 2009 at 3:15 pm
You should be fine but run DBCC UPDATEUSAGE and DBCC CHECKTABLE to be sure.
More info here:
http://www.sqlservercentral.com/Forums/Topic655130-146-1.aspx
May 28, 2009 at 1:34 pm
ALIF
You have a desktop edition of SQL Server 2000 embedded with your application.
If you want to connect to it read this KB:
May 27, 2009 at 3:54 pm
Or you can use this script if you need info per file.
SELECT
a.FILEID,
CONVERT(decimal(12,2),ROUND(a.size/128.000,2)) as [FILESIZEINMB] ,
CONVERT(decimal(12,2),ROUND(fileproperty(a.name,'SpaceUsed')/128.000,2)) as [SPACEUSEDINMB],
...
May 27, 2009 at 3:47 pm
You should modify the Data Dictionary part or remove it all together cause it applies to Oracle.
May 27, 2009 at 3:38 pm
Viewing 15 posts - 376 through 390 (of 541 total)