It can't be done directly from T-SQL, so you'll need an external tool...

If you read the...

The option FOR ATTACH_REBUILD_LOG will use the LDF-file if it exists on disk. If you really want to create the database with a new LDF file, you'll first need to...

Duplicate of this thread. Only respond on the other thread.

I think your question is answered by this thread on dba.stackexchange.com:

http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line

I have never tried this on a system database, but in the documentation it is not mentioned it cannot be done.

FOR ATTACH_REBUILD_LOG

Specifies that the database is created by attaching...

Take a look at sqlstudies.com[/url]. Kenneth Fisher has nice scripts under the "Free Scripts" menu to script out all instance or all database permissions.

torrid.inundate (10/28/2016)

---

<snip>...but if a change the date format i got error

DECLARE@return_value int

EXEC@return_value = [dbo].[testingpurpose]

@StartDate_in = '01-JUN-2016',

@EndDate_in = '14-06-2016'

SELECT'Return Value' = @return_value

Go

Msg 8114, Level 16, State 1, Procedure testingpurpose, Line 0

Error...

WhiteLotus (10/27/2016)

---

Thanks for the reply . Much appreciated .

Only 1 filegroup which is primary and 1 data file

The result of your query is as below ( I cut some information...

Perhaps this gives you the insight about the cause:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/79a9d797-7a09-40cb-85b4-f26d19fa1c45/being-flooded-with-security-event-id-4793-windows-2008-r2-sql-2008-r2?forum=sqlsecurity

http://serverfault.com/questions/390026/being-flooded-with-security-event-id-4793-windows-2008-r2

These articles mention it has to do with the Password Policy Check.

Briceston (10/27/2016)

---

Hello all,

<snip>

Data Age

Account 1 46

Account 2 36

Account 3 37

Account 4 ...

You can first convert/cast the "age" value to a decimal, like this:

if OBJECT_ID('tempdb..#Age') is not null

drop table #Age

create table #Age (Account int, Age int)

insert into #Age

values

(1, 46),

(2, 36),

(3, 37),

(4,...

Ed Wagner (10/26/2016)

---

HanShi (10/26/2016)

---

Jeff Moden (10/26/2016)

---

p.s. As for ascertaining the recommended size for the log files, you could write a script to (for each DB)...

1. Set the SIMPLE...

Jeff Moden (10/26/2016)

---

p.s. As for ascertaining the recommended size for the log files, you could write a script to (for each DB)...

1. Set the SIMPLE recovery model.

2. ...

Here's an article to help you troubleshoot: Troubleshooting Access Violation caused by Database Backup in SQL Server 2008/R2[/url]

The article is for SQL2008R2 but perhaps it can also be applied to...