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,........

wow that looks a little scary to me, where maybe the logic isn't quite clear.

it looks like you want to delete any existing records that might end up having...

aaron.reese (4/24/2013)

---

Which is sort of annoying!

It means that home developers and/or people trying to 'break in' to SQL development have a huge barrier to entry. I understand why Microsoft...

well, note the comments in the thread;

if you need to protect 400 tables, it's probably better to look at the security aspect of it, adn not tackle this via a...

Andy did you copy the trigger verbatim or modify it a bit?

it worked fine for me when i posted to the thread originally;

can we see your version of...

ok by looking at a different registry key and looking for Service names, i think this finds them all on my sample machine:

/*

ResultsId ResultsText

233 ...