also check out this neat trick:http://sev17.com/2011/10/22/gaining-sql-server-sysadmin-access/

basically it's a model for a SQLCMD script which would add a new sysadmin user, because it is able to run as the built in...

it's just the wrong provider;

jet is for 32 bit Access/Excel, and not for SQL Servers.

here's your command adapted, and also one I know works for sure:

--query directly without open rowset:

SELECT...

convert to...

collation.

for case insensitive searches, some high ascii characters are treated as the same character as certain low ascii.

you can use an explicit binary collation, for example, which would seperate teh...

remove the SET IDENTITY_INSER

%T command. since it is not valid/has no effect with BULK INSERT statements.

instead, as identified, you need to add KEEPIDENTITY to your BULK INSERT command:

BULK

INSERT ABC

FROM...

well as John Mitchell pointed out the ren command syntax found here does not allow the path of the filename as part of the second parameter.

however, the MOVE command...

Ok your problem...

easiest fix is to move it out of your personal folders:

c:\users\austens samsung

a fresh installation of SQL has permissions to it's own folders under program files, and it's own folders under...

when you say "CPU's, are you referring to virtual CPU's? i believe Standard 2008 is 4 sockets, but the Virtual CPU's could be, say 16 on a four socket...

there is a very handy free plug in for SSMS here:

http://www.ssmsToolsPack.com

one of the options is to right click on a table in Object Explorer>>SSMS Tools>>Generate Insert Statements

Lynn, do you know why my calculation is off by two days? is it because SQL's zero date on 01/01/1900, but Excel thinks zero date is 12/30/1899 ?

rcherod (4/24/2013)

---

Estimados, 🙂

I would like to inquire about how to convert a date format of strange, I have a txt file that comes with the date field as follows:

Name fecha_asist

Pedro...

Damian-167372 (4/24/2013)

---

may be you can try some telnet commands to send an email first and see if there is any ports are blocked to access the smtp server from your...

ok, i'll skip the peer review and go straight to the error you are tripping over:

your error was pure syntax.

the SET IDENTITY_INSERT must be inside the body of the trigger,........