If it only happens during sql startup it can be safely ignored. Check out this blog post by CSS.

http://blogs.msdn.com/b/psssql/archive/2009/05/12/sql-server-reports-working-set-trim-warning-message-during-early-startup-phase.aspx

-Jeremy

When you create the table you will see one data page and one IAM page created. The IAM page (PageType=10) tracks the data allocations and is counted towards the index...

Here is a query which will show you how memory is being used by each db.

SELECT

CASE

WHEN database_id = 32767 THEN 'Resource Database'

ELSE DB_NAME (database_id)

END AS...

SSL is always enabled. If the server option ForceEncryption is not enabled, then clients can still request to use SSL. So yes it is possible that some connections are encrypted...

You are correct that sql does auto generate a certificate for use with ssl each time it starts. It is self-signed so it is not as secure as something you...

Fix the principal

--On the principal

--create a new cert for the endpoint

USE master;

CREATE CERTIFICATE [principal_new_cert]

WITH SUBJECT = 'mirroring cert',

START_DATE='07/11/2010', --make sure this is a day prior to...

The objects will usually be split between the files due to the proportional fill that sql uses. However to answer your question you could use dbcc ind.

example usage

dbcc...

If you aren't using fts then it really does not matter. However if there is any chance you are using fts than I would recommend reviewing for more detail...

Gail nailed it on the head with the only surefire method of tracking the file size. However if that is not setup we could look at the default trace....

Ken,

Basically you would need to use a logon trigger and query sys.dm_exec_sessions for the program_name. Unfortunately though I think you would need to come up with other criteria other...

SqlServerAlias is managed through wmi. You could assign permissions for your developers to this name space. It's not perfect since you have to assign permissions to the entire namespace...

Your syntax is close but you don't need the single quotes.

ALTER LOGIN xxx WITH DEFAULT_LANGUAGE = British

-Jeremy

1.) Open MMC

2.) Add Remove/Snapin

3.) Add Certificates

4.) Select Computer Account

5.) Expand Certificates

6.) Expand Personal

You should see the certificate in there and the name it was issued to. It's been...

It depends on what url you are wanting to use and what ssl cert you have. No matter what you can use the same ssl so long as the...

Once a file is offline, it can only be brought online by restoring it.

-Jeremy