Viewing 15 posts - 121 through 135 (of 270 total)
The most common recommendation is to do a full backup whenever a change is made to the system databases.
August 29, 2006 at 10:07 pm
A way to use triggers without the need to drop and recreate them would be to use SET CONTEXT_INFO. I found this out only a few months ago whilst reading...
August 17, 2006 at 12:37 am
When you first set up the alert in SQL Server you should also receive a message telling you that 'error 15327 will not invoke alert <alert object name> by default...
August 13, 2006 at 11:07 pm
For SQL 2000, you can use this query to see what backups have been performed against your databases:
select
a.database_name, a
August 10, 2006 at 10:14 pm
A typo, it should have been wmic!
August 10, 2006 at 6:56 pm
Could it be wmci, the Windows Management Console Command-Line Tool?
August 10, 2006 at 6:54 pm
Its possible that you may not have set up the publication properly, or that all articles have been dropped from the publication. Can you confirm that there are articles present...
August 10, 2006 at 6:24 pm
The error message is saying that you are trying to edit a field of the 'text' data type. You will have to use the UPDATETEXT statement instead. Refer to BOL...
August 10, 2006 at 5:53 pm
My experience has been that the timestamp data type column is supported in merge replication - the exception being that its literal timestamp values are not replicated, that is, a new timestamp...
August 8, 2006 at 7:25 pm
The installation will detect if you have any prior versions of SQL Server, and will present you with the appropriate options. You are simply installing a fresh SQL Server 2005,...
August 8, 2006 at 6:41 pm
Have a look at this article (http://support.microsoft.com/kb/231830/EN-US/), which seems to imply that there is no solution to the problem.
In short, SQL Server is able to store data preserving...
August 8, 2006 at 6:33 pm
I am not sure that changing the database collation is the approach to take. Normally, the database collation is set at a particular collation for a reason!
Have you tried changing...
August 8, 2006 at 12:59 am
Sure...a starting point would be to use the following select statement:
select
databasepropertyex('pubs', 'Collation')
August 8, 2006 at 12:44 am
I did install the free product, but was somewhat dissatisfied with its performance, and had to uninstall it quickly! Not a smart thing to distribute a product that does not...
July 26, 2006 at 10:17 pm
To strip the hours from your table aliased as 'H', you can use the 'convert' function, eg. G.sdtT = convert(char(10),H.sdtT,102)
Refer to BOL for more info on the convert function.
July 24, 2006 at 6:52 pm
Viewing 15 posts - 121 through 135 (of 270 total)