mramey (7/30/2012)

---

Yes the structures are always the same. As I said before I will pass the path and names to the SP from an access vba application. I...

Scott D. Jacobson (7/30/2012)

---

Lowell, just out of curiosity, what would the result set look like on say a clustered SQL Server instance compared to standalone? I don't have the ability...

for me, I was trying to use ACE 12.0 drivers, which i know i installed, and can use for Excel xlsx files via openrowset so...

edit: when i did ping /? from a command line, i do not see a -o option.

in 2008 and above, you can get it from some of the DMV.s or...

on a similar note, has anyone gotten a linked server or openrowset command to work on 64 bit / ACE drivers?

I see there is a connect item on it with...

which is actually being dropped, the login in sys.server_principals, or the user in databasename.sys..database_principals?

if it is databasename.sys..database_principals, is the database being restored every quarter, by chance?

if the backup doesn't contain...

that's normal and by design.

SQL tries to keep everything in memory in order to better serve multiple requests for the same data.

unless you tell it otherwise, SQL uses all the...

could your script be multiple commands, and you are adding the same table twice?(and maybe dropping it once.

you seem to be on the right track as far as looking...

IsNumeric tests to see if the string matches any of a number of specific patterns for all sorts of data types.

select isnumeric('3e0'),isnumeric('3,4'),isnumeric('$23,454')

'18' is certainly convertable an integer, for example...did you...

select * from the table where the model not like '%[^0-9]%'

that will filter out anything that has anything that is not in the range of 0-9 characters; so punctuuation,...

maw74656 (7/30/2012)

---

Are you suggesting there is no point where too many comments can slow it down, or that the point is so large its impractical to consider? What if...

the hiccup there, as you identified, is when files exist on the network, and not the local disk.

The system account is one of those special accounts that never logs into...

a server side DML trace is lightweight amd can provide the whodunnit info, but not the rollback of changes.

For me, i think having a DML trace that rolls over...

the way i've always handled this situation is to continue to use an identity field, but adding a persisted calculated field that creates the desired alphanumeric based on a concatenation...

looking again, i think there is a TargetObjectName in the RENAME schema.

-<xs:complexType name="EVENT_INSTANCE_RENAME"> -<xs:sequence>

<!-- Basic Envelope -->

<xs:element type="SSWNAMEType" name="EventType"/>

<xs:element type="xs:string" name="PostTime"/>

<xs:element type="xs:int" name="SPID"/>

<!-- Server Scoped DDL -->

...