I tried this and added acouple of different things, like timeouts and Content-Length to the headers...it made no difference...depending on the url it either failed witha 404, or the same...

I've had this snippet for a while, which i thought gets the number of processors on the server. this is the physical number of processors, and not whether they are...

awesome example michaela;

Still dealing with too much SQL 2000 here, and i wanted a nice working example to explore the new DDL trigger abilities.

I was able to read it,...

I had created a search proc I called "uglysearch", that found every varchar/char column, in every table, and searched for a specific string. similar to what you are doing, but...

i think this is just a result of spaces in the path/filename, right?

changing this part should work i think:

SET @folder = 'C:\Inetpub\wwwroot\Pergamum\Doc\International Banking\Caribbean'

SET @path =SUBSTRING(@folder ,...

sounds like you want the results of sp_who in a view for example?

simply sp_helptext sp_XXX, and read the code....maybe you can simply lift the code, or maybe you can convert...

you could also attach the spreadsheet as a linked server, and then select from it as well;

here's an example, which adds the linked server "MySpreadSheet", just change the path and...

it sounds like you are doing everything right...

here's a basic example of a select into:

select top 5 * into #Table1 from sysobjects

Select * from [#Table1]

that works fine on my...

doc_sewell (7/10/2008)

---

The problem is that our application needs to evaluate strings before they are submitted for processing. and these strings may contain variables, e.g.,

" select *from t where id...

I'm pretty sure that error 2147217873 is a foreign key violation;

ie

Error Code : -2147217873

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ForeignKeyName'. The conflict occurred in database 'DatabaseName',...

As you already suspected, In SQL2000, there's not much you can do.

If all your databases have the database recovery model set to "FULL" instead of "SIMPLE", you could use a...

Stephen is kind of right, as long as you ignore some stuff.

unless you've added a primary key to the table, because Access is file based, Access really does keep the...

from Query analyzer or SQL 2005 Management Studio:

exec AddSystemEvent 12,'06/09/2008',-21,'Some Bad Event Occured that probably should not have.'

note the scanner id example i put in an arbitrary number of 12,...

maybe i'm just misreading it, but you want to insert just 255 chars right?

CREATE PROCEDURE [dbo].[AddSystemEvent]

(

@ScannerID As Int,

@TimeDate DateTime,

@EventID As Int,

@EventDesc NVarchar(256)

)

AS

Begin

Insert Into tb_system_event

(Scanner_ID, Time_Date, Event_ID, Event_Description)

Values (@ScannerID, @TimeDate,...

installing Enterprise Edition of SQL Server on a non-Server...