i tested it...

what you are asking is already built into the mail service on SQL.

the service broker for mail automatically retries when the mail server is unavailable;

you might want to change the...

four i would say, built in functions, plus three kinds of user defined functions: scalar, multi statement table functions and inline table functions.

-edit]

from my notes of SQL server...

Ness thank you; I didn't know a restore cleared the whole cache on the whole instance; i had to see it to believe it, adn Now i see your point...

Ness (7/19/2012)

---

Hi All,

I am wondering about others views about restoring a copy of a production db to the same server, obviously using another name.

I always under the belief...

since you said "from an internal SQL Server.

" to "MySQL", that doesn't use 1433 at all.

if you wanted to connect to the MySQL database from your PC(which is also on...

i think you can use one of the built in convert formats.

--2012-07-19 09:56:46.040 MyString

SELECT CONVERT(VARCHAR,GETDATE(),121) + ' MyString'

repair softwork doesn't seem to work when it comes to SQL Server, because the file is always open;

it's kind of like opening a word file;

you may edit for hours, but...

when you say you are granting sa access to a group, how did you do that?

for me, "sa" access means you made the group part of sysadmin, like this?

(this is...

the full error message , and not just the error number, would give us more information.

the message gets substituted with helpful, specific info.

select * from sys.messages where message_id=18456

Login failed for...

whoops that was wrong;

i left it in place but striken.

i got the same error you mentioned when i tried this:

Msg 2108, Level 15, State 1, Procedure TR_NewTrigger, Line 4

Cannot create...

two syntactically correct , workable examples...

all code, whether a TSQL statment or a procedure, is executed on the SQL server, and the results(if any) are returned to the client.

so if you have a linked server...

from a SQL server perspective, cursor declarations are session specific(unless you are using the DECLARE cursor_name myCursor GLOBAL syntax);

so it's very likely that an error is occuring sometimes and...

Done!

I made this because i really do feel we are begging for the same thing all the time!

ColdCoffee (7/18/2012)

---

Can you also please add expected results to the placard the gentleman...