We did a work around on this issue were I work by creating an proc in the master database that called the sp_OACreate and granted right to this sproc to...

This is a wild guess but is it having problems finding the domain controller to verify the account info.

Checked WINS and DNS entries stuff

Tim S

Expand the + in-front of a table that should have a trigger; you should see a folder called triggers under the table.

Tim S

Till the SQL Server has SP3 of SQL installed it is not suppossed to let tcp/ip traffic in i under XP and 2003 OS.

Tim S

I like this URL better

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

But, this one is a little better upto date

http://www.aspfaq.com/sql2000builds.asp

DBGhost Does it OK.

I use a custom method which does the table creates for all the tables and then I do all the FK stuff.

Tim S

-- Create temp table with the structure of Data returned by the Sproc

CREATE TABLE #temp

(

col1 INT NULL,

col2 varchar(2) NULL

)

INSERT INTO #temp (col1,...

I would try using sp_MSforeachdb

see http://www.mssqlcity.com/FAQ/Devel/sp_msforeachdb.htm

Tim S

Try

IF EXISTS(SELECT TABLE_NAME FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '#searchResult%')

I perfer the following

IF OBJECT_ID('tempdb.dbo.#searchResult') IS NOT NULL

Tim S

SET FMTONLY

Returns only meta data to the client.

Syntax

SET FMTONLY { ON | OFF }

Remarks

No rows are processed or sent to the client as a result of the request when...

Did You Try it!!!!!!

SET FMTONLY ON

Tim S

It might be an MSDTC issue. MSDTC was changed in XP SP2 & WIN2K3 SP1

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

Tim S

SET FMTONLY ON

GO

SELECT *

FROM dbo.sysobjects

GO

Tim S

I would get a copy of developer ED SQL 2000 and find out what stats the IT guys want and then learn how to get them from your development box.

The...

It is bad because of SQL Injection and because of the permissions issues.

When using "dynamic sql" the user must have rights to both the sproc and the tables invovled.

The above...