Viewing 15 posts - 16 through 30 (of 46 total)
Just to give an update on this issue. After examination of the Maintenance Plans in existance, it looks like most full backups are scheduled to happen around two specific times...
February 28, 2007 at 11:38 am
Do you make backups of your transaction log?
February 26, 2007 at 12:04 pm
I restarted the server last Saturday but the errors didn't stop. They happen daily.
Full backup fail sometimes with similar errors. Here's another flavor that I received early this morning from another...
February 23, 2007 at 9:24 am
Thank you for the reply Bill. The support guy at Quest says that it could be a network problem but he's still working on the case. So I am waiting for that.
It is funny that...
February 22, 2007 at 5:10 pm
To create the procedure:
create proc 'myProc'
@param1 param1DataType, @param2 param2DataType...
as
...type your code here...
go
About calling the procedure from ASP, see this article:
http://support.microsoft.com/kb/q164485/
Hope that helps.
-M
November 18, 2006 at 2:20 pm
That will work for now, but it is only a temporary solution. Future releases might fix the posibility of selecting top < 100 percent and that would break your application...
November 17, 2006 at 1:42 pm
If the scope of this project is limited to spanish, there is no need to use nvarchar.
November 10, 2006 at 10:44 am
I would offer a simple solution just by converting the very few characters in spanish that don't exist in english: á, é, í, ó, ú, ñ, Ñ to their corresponding:...
November 9, 2006 at 11:56 am
Since I don't have access to changing the server settings, I was looking into changing the dateformat setting only for one database. This gave me the answer. I am simply...
November 5, 2006 at 1:35 am
select
top 2 number, date, sum(qty)
from...
November 1, 2006 at 12:02 am
I would check the client connection on each of the problem user's computers. Make sure they are set to use TCP/IP instead of Named Pipes.
September 16, 2006 at 1:18 am
I guess the confusion starts because SQL Server 2000 would return ordered data and SQL 2005 doesn't.
The same happened to me when a procedure stopped working properly after an upgrade...
September 14, 2006 at 11:27 am
The error is not visible. Can you post it again?
September 14, 2006 at 9:27 am
Hello Neil,
The situation you describe was explained in the June issue of SQL Server Magazine. You can see it here:
September 13, 2006 at 11:09 am
Hi Larry,
When I created the connection, I was able to see all my databases in the drop down menu. Is your db online?
September 13, 2006 at 10:56 am
Viewing 15 posts - 16 through 30 (of 46 total)