You can grant network access to the SYSTEM account by granting network permissions to the Computer account. Do you see this for the UNC resources?

Andy

Try installing NT4 with SP3 before SQL 6.5, then apply SQL 6.5 sp2 or newer before doing anything else. These were the days that proved "never install a M$ product until...

How to uninstall an instance of SQL Server 2005 manually

http://support.microsoft.com/?kbid=909967&SD=tech

Here are some other interesting methods and tools for cleaning up after an Uninstall failure:

http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx

http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Andy

DECLARE @D TABLE (CP1_CI_AS varchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS

        , CP850_BIN varchar(40) COLLATE SQL_Latin1_General_CP850_BIN)

INSERT INTO @D

SELECT '2004-01-11T17:11:032','2004-01-11T17:11:032'

SELECT * FROM @D

select convert(datetime,REPLACE(CP1_CI_AS,'T',' '))

        , convert(datetime,REPLACE(CP850_BIN,'T',' '))

FROM @D

select convert(datetime,CP1_CI_AS)

        --, convert(datetime,CP850_BIN)

FROM @D

GO

Looks like...

Within a trigger (except for INSTEAD OF triggers), the inserted table contains the rows that were inserted, consider the inserted table as an alias for the table associated with the...

I do not mind ads, as long as they do not get in the way or replace content.

Am I the only one who has noticed the close proximity to the...

Try changing to:

set @CommandString = 'SELECT ' + ''''+ @serverName + '''' + ', TABLE_NAME, COLS_LIST FROM [' + @serverName + '].[MY_DISTANT_DATABASE].[dbo].MY_DISTANT_TABLE'

INSERT INTO MY_LOCAL_TABLE

exec (@CommandString)

END

Andy

For SQL2K You could have the user initiated trigger insert the value(s) used for the stored procedure parameters into a queue table with a GETDATE() column then create another stored procedure...

Create an Instance of SQL Server move the desired databases to this server which can be configured for reduced resources.

I do not think that this is available on a per...

You cannot use dynamic T-SQL in a UDF, so convert to a stored procedure:

CREATE PROCEDURE dbo.WAPSnapshotProc(@TheDate datetime)

AS

DECLARE @GSDB varchar(30)

DECLARE @LegalConfig varchar(50)

DECLARE @EPSInfo varchar(50)

DECLARE @sql carchar(8000)

DECLARE @item_category_counter INT

DECLARE...

MSDE 2000 sp4 is a set of tools for a developer to use to create an update.

http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desksp4.htm

See section 1.2.1:

You must 1st determine if your installation type supports sp4:

A quick google shows:

Looks like this has been around since SQL Server 6.5:

SET NO_BROWSETABLE ON is an undocumented option performed for Remote Data Service (RDS) ActiveX Data Connector (ADC) connections...

Since the error is caused by the attempt to convert a column's data type, simply add a WHERE clause that will exclude all rows where this column's data cannot be...

The issue I see is the use of the RequirementsId Int Identity (1,1) column in the temprorary table @Requirements and then later using it to join with the Requirements.RequirementsId. In...

Check out:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=298832

The topic is Measuring Performance, but the query being tweaked performs the task you describe, or at least as I understand it.

Andy