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

I think what you are looking for is almost built in:

in MS SQL Server Management Studio, browse to Server>>Security>>Logions (NOT [specific database]>>Security)

right click on the existing user you want to...

I believe you simply have to shrink the msdb database.

running sp_cleanup_log_shipping_history will remove rows from the history tables, but that just created free space--the space is still reserved for future...

you created them using your admin account, but when you connected with SSIs Express, did you connect as that same user, or as a SQL Server login, like 'sa'?

that might...

can youc hange your primary key? instead of using some integer value, use the combination of HandheldId + Image_Surr_Key; that way Image_Surr_Key can repeat, but the combination of handheld...