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

are you sure the zero is causing the problem, it's alias? try SELECT 0 as CNT instead of the reserved word COUNT

also, careful with the datefield...

it's good practice ...

the primary key alows the replication service to uniquely identify every row in a table.

in that manner, it is much easier to tell the recipient database of the replication...

iitt2007 (3/31/2008)

---

I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the 'remote' (not local sql server -...

boy I really agree; It's a stupid Project requirement that all "raw data" is imported from text into SQL Server database, and then the data massaged from there.

The...

I'm putting this thru it's paces now Jeff;

The data I'm trying to parse is some FIP55 data with every place name in the united states; 560 meg of data, so...

that's what i was looking for antonio; i remember using a different kind of split function for the same type of results. it's the cross apply and the row_number() over...