On SQLServer 2005:

I am in the Test database which has Test table.

insert into Table

SELECT@@servername as Servername,name as DBName,[crdate] AS [LastStartupDate]

FROM[master].[dbo].[sysdatabases]

WHERE[name] = 'tempdb'

and [Test].[dbo.Table].LastStartUpTime < [master].[dbo].[sysdatabases].crdate

Error:

Msg 4104, Level 16, State...

SQL Server 2008 has start time.Where can I find similar data in 2005 and 2000

I would like to have the servername,starttime,login that started the server,login that stopped the server...

Yes.

Just as scott has coded.

I got this part.How do i concatenate both weeks and days together.

Ex: 37 5/7 or 31 /2/7 or 41 6/7

I have a days column

Ex:280 days

I would like to...

Query result:

1544

max server memory (MB)

2147483647

16

2147483647

2147483647

Maximum size of server memory (MB)

1

1

Query result:

1544

max server memory (MB)

2147483647

16

2147483647

2147483647

Maximum size of server memory (MB)

1

1

Do the appdomain errors mean issues with the server/database?

Does this error mean trouble?

Error:appdomain is marked for unload due to memory pressure.

Would giving "the sql server service account the right to prevent the operating system from paging its memory to disk" get rid of this error ?

i.e

Click Start.

2. Go to...

Min memory:0 MB

Max memory:2147483647 MB

We have 8Gb RAM on the computer

Should I decrease the max memory to 7GB ?

If i choose to do this how I do it.Do I have...

Does not work.....

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

DOes not work....

.ldf - log files

.dfb-diff backup files

.mdb - master database backup...Is .mdf used only for the backup of the master database?

.bak....Does having .bak extension means it is a full back?

How do...

no errors...the above sql does not return any data.

Thanks Jeff. Works like a charm !

appreciate your replies...working on it...will get back to you.

thanks