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...

I just used the package and deployment wizard on a vb6 project that only had a richtext object on it;

this is a list of all the dll's the wizard selected...

i think alimcitp has nailed it; your connectionstring doesn't have a username/password or integrated security:

you need to know your machine name; the constring you had was clearly incorrect.

it's machinename\instnacename,port

so if...

When I perform an Insert into the Transaction table I update the Ledger. For the most part this is a simple case of inserting the required data, the issue comes...

additionally, if you are running any operating system with windows firewall, you will need to add an exception for sql server...you have to browse to sqlserver.exe for each service you...

I was trying a similar project...wanted to make a CLR that simply dumped RTF into an RTF object and returned it's .Text property, and found it was not allowed in...