Search results for query: *

This is probably a silly question, but I can not find the answer. In the sp_attach_db command the books on line samples show that you put an N infront of variables, like this: EXEC sp_attach_db @dbname = N'FIRE', @filename1 = N'c:\Fire_RMS\FIRE.mdf' What does the N mean? Thanks. Ted

I am trying to figure this out, and after banging my head against the wall for a few hours I thought I would ask to see if there is something I am missing. Scenario: Table icfct holds transactions. A sample list of rows would look like this: Row_ID Part_ID Program_ID 872...

Thanks Dan - it turned out that was not the exact problem I was having but you got me thinking in the right direction. I started to scan through the notes field that I was reading in from Excel and it was pulling in hidden fields - some nulls and other lower ascii characters that I did not see...

I have a utility that needs to read an Excel data file. I have the system working pretty well except that it will not read long notes. Any note that is longer than 255 characters gets cut-off. I am using VB6 and using an oledb connection to Excel: cnnExcel.Open...

Thanks Swi - I just gave you another star. I was looking up something completely different but I stumbled on this post and it was something I have been looking for an answer on for a long time. Thanks. Ted

Thanks hmckillop that was exactly what I needed. I put in the (NOLOCK) on my select statement and the problem has gone away.

I have a program that is reading one database and based on the results will update a seperate database. My reads are supposed to be readonly but it is being reported to me that this is causing recordlocks on the server that is blocking other processes. here is a snipit of code: With oSLXRS...