Hi all

Question

Post reply

Hi all

VINODKUMAR KASTURI

SSC Rookie

Points: 40
More actions
October 20, 2011 at 3:01 am

#245629

how to create log in in SQLServer200R2

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 1

http://tinyurl.com/3fq4d5d

top link

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

vinodkumar.kasturi072 (10/20/2011)
how to create log in in SQLServer200R2

Which one are you referring?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

vinodkumar.kasturi072 (10/20/2011)
how to create log in in SQLServer200R2

There are different "kind" of logs in SQL Server. Which log you are talking about?

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 4

When you create a database you are required to create a transaction log as part of creating the database, so I don't think you're talking about that. The SQL Server error log and the agent error log are created for you as part of the install, with no actions required on your part, so I don't think you're talking about that. I'm unsure then what you're looking for.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 5

I think he means 'login' rather than 'log in'

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 6

derek.colley (10/20/2011)
I think he means 'login' rather than 'log in'

Entirely possible.

Here's the appropriate entry from the BOL

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 7

You're nicer than me. The tinyurl in my post above is a lmgtfy to the BOL.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

derek.colley (10/20/2011)
You're nicer than me. The tinyurl in my post above is a lmgtfy to the BOL.

Nice to see you are learning :-D.