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

I put a copy of PKzip25 in a zip file, along with a .SQL file containing an example, which you can download here

yes, the logic is the...

when converting a number to datetime, the date portion is left of the decimal place, and the time portion is to the right of the decimal point.

I think it really...

Matt Miller (2/27/2008)

---

Lowell - if you're on 2005 - use CLR instead to create the REGEX expressions instead. The XP is nice in 2000, but you can do better...