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

i believe it's becasue you want to update the alias "o",

try this instead:

CREATE TRIGGER [dbo].[tr_intr_ob_problem_list_]

ON [dbo].[ob_problem_list_]

FOR INSERT

AS

...

documenting all users and roles, any CLR assemblies, and mail settings for database mail is handy too(even though the mail settings are in msdb)

linked servers and synonyms and custom...