the FROM property for bulk insert must be a static string...it cannot be created from appended variables.

BULK INSERT BULKACT FROM 'c:\Export_o.txt'

to do what you want, you need everything to be...

here's one solution using a scalar function. I don't wnat to hog the thread, so I'll leave it to others to post a nice ITVF function featuring cross apply, which...

Sorrry kev i might have bben too brief on the explanation.

The sheet nin the excel needs to have column names in the first row and data in the subsequent rows.

I...

i was thinking the same as opc.three;

it's a false cause-effect i bet;

i'm thinking that procedures started sucking-performance-wise because of stale statistics, and the clearing of the proc cache, which occurs...

the problem is this case statement in the query:

CASE f.maxsize

WHEN -1

THEN -1

WHEN 0

THEN...

great job providing the same DDL and Data!

maybe i'm missing the hard part of the question and overlooking the obvious,it, but does this do what you want? a simple union,...

this looks right to me:

Imports Excel = Microsoft.Office.Interop.Excel

Private Sub ImportExcel(ByVal PR01filename As String)

Try

xlApp = New Excel.Application

xlApp.Visible = True

...

Ben I'm hoping some of my peers may have a better suggestion;

I'm familiar with the free Community verison of DotNetNuke[/url] which is a Content Management Solution featureing suites of web...

some links i have saved:

adding a sysadmin back toa server:

http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

http://sev17.com/2011/10/22/gaining-sql-server-sysadmin-access/

you really HAVE to compare differnet queries by their execution plans, and not by their perceived speed.

digging into those details are what gives you an understanding of why there are...

and the details:

first, you gotta have the ACE drivers installed, look at this post FIRST:

http://www.sqlservercentral.com/Forums/FindPost1407497.aspx

then here's a mockup of the code: there's a couple of issues...I'm ASSUMING every sheet is...

the devil is in the details, but if xp_cmdShell is available, you can use THAT via tsql to :

1. get the list of files,

2. create a cursor/loop for each of...

have the desktop application e use some web services you will need to create whichreturn available tickets and another to book tickets.

maybe an additional web service so you can see...

this blog has a good explanation and the scripts to track down the offending schema:

http://blog.sqlauthority.com/2011/12/26/sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/

Manie My setup for gMail is working fine and sounds to be near-identical to yours, i just tested it again; the only difference seems to be the smtp server i'm...