Could you post the SQL statement that you are using?
>should it matter that the sql server is not local?
yes, you need the full path name. SQL Server is looking for the file own it's own C drive,...
I am about 99% sure the answer is "no".
Is "Sheetname" the actual name of a worksheet in the c: esting.xls file?
You will always need the $ at the end also.
I would try using the openrowset function. Here is a sp that I built to import excel spreadsheets into my db from command line.
It takes 3...
Sorry. I searched for "Service Pack 4" and could not find anything.
Is there any possible reason that I should not go ahead and install SQL Server service pack 4 on my servers?
So far, I have avoided using cursors, but I see no other way to do this.
I have a db with 285 tables. I want to add 1 varchar(10) column to all 285...
I did not analyze your sp, but it sounds like you may have data which cannot be converted and/or is in the wrong format.
i.e. This data would cause...
backup log your_database with truncate_only
dbcc shrinkfile (your_database_log, 0 , truncateonly)
I tried this, but I still have a 14 gig...
I figured it out. I had a local user in my database that I inherited that was not a global user SQL Server. I deleted the local user and now am...
No, my issue has not been resolved. I have tried backing up the transaction log with every different options, changed the amount of allowed free...
I have built a DTS package to copy one database into a new, empty database. I have used two different servers, locally and remotely for both...
you need to specify either
I am having trouble shrinking a database. The database is 14 gig, with 6 gig free space. I have tried to shrink the db with ERM, and I have tried...
There are two methods, the Rozenshtein Method:
>Your real data looks much different from the sample data you've posted. It might have been a good idea if you had ><img...
I will make it even trickier for ya'll. These are real values from one of my tables. Neither of the udfs posted seems to handle this data set very...
As Adrian mentioned, I am almost always dealing with locations with varying length prefixes.
Actually it is not as easy as that. Sorry that I was not more specific in my first post, but I have no control over the naming of the sampling...
Separate names with a comma.