vinodh247 (1/6/2011)

---

Craig,

I have not copied these q's from any site, these are the questions i was asked in the interview. I'm a newbie to this site and this is my...

Microsoft SQL Server 2008 Express (SQL Server Express) can serve as...

I understand..the only other way I can think of is Policy Management (SQL 2008 up).

Haven't tried anything like this yet...

Trigger on create?

Schedule a job to send mail to you with the following tsql...it will return with the names of databases created in the last day....

select name from sys.databases

where create_date > (getdate()...

To add to what Adiga said, you can always make a normal backup, restore it as a different name, detach from SQL, and do as you please with the mdf...

Let's rather start by you presenting us with the answers you gave, and we'll work from there?

No you cant use Express as Distributor.

http://msdn.microsoft.com/en-us/library/ms165686.aspx

Replication Considerations (SQL Server Express)

SQL Server 2008 R2

Other Versions

* SQL Server "Denali"

* SQL Server 2008

...

In my age group, it's really the only way to keep in touch with people.

Nobody picks up the phone and call anymore, so FB is a good alternative.

In the job itself, add the 1st step as a 2nd step, and configure the first step's failure action to go to the next step, instead of reporting failure.

rmazambara (1/4/2011)

---

Hello folks,

I would like to set up an audit for my sql server environment. I would like to audit changes that would have been done straight on database tables;...

declare @username nvarchar(35)

set @username = (select suser_name())

select loginname, (Case sysadmin when 1 then 'Yes' else 'No' end) as Sysadmin

from syslogins where loginname = @username

Passwords for NT linked accounts are...

exec sp_helplogins

In SSMS, right click the database you want to modify.

Select properties.

Select "Files" from the list on the left.

All files that belong to the database will be displayed (your database file,...

You can set the maximum size for each file in your filegroup.

The filegroup size is the total of all the files sizes that belong to the group.

I use getdate() purely as a habit.