Well, I didn't know that......

Just a little something from my own experience:

The default trace file as has been mentioned, cannot be amended but that said, it shouldn't really be a trace that is used...

In the past I have used Microsoft Data Protection Manager (DPM) for organisational backups in general. It has a (IMHO) a great interface for backing up SQL Servers, allows...

There is nothing to worry about. TempDB is recreated each time the instance/server is restarted and it will consume however much space it requires to perform its function. ...

My solution would be to store the PDFs outside of the database in the file system where it can be continually access scanned. This has the benefit of helping...

1samharris (6/25/2013)

---

the subnets 10.0.0.0/16 and 10.0.1.0/16 can talk, (for diagnosis I openeded all TCP / UDP and ICMP)

The error is a SQl error

the account is domain account and right now...

I have the @ symbol for several service users and it works fine. I would assume therefore that the problem is an application problem and not the database itself.

The...

In that case, Matthew has hit the nail on the head with his answer.

How often can we not see the...

Tom Van Harpen (4/4/2013)

---

We have a team member that does not have sysadmin but we would like to give this person the ability to setup and maintain SQL Agent jobs.

We've...

K. Brian Kelley (4/30/2013)

---

If they're in a Windows security group, you can add the group as a login and deny permission to connect to the SQL Server.

However, this is usually...

Are you talking about not being able to see a database within the SSMS or not being able to view the contents of a database?

Try creating a second AD Group and assigning the users you don't want to have db_owner access to that new group. Assign new permissions to the database via the...

I waited to reply to Steves anser to me because I wanted to see how other people reacted and now I know!

Perhaps I am simply to optimistic about people getting...

awright 77372 (6/20/2013)

---

Hear hear, Steve! I'd love to see a dashboard similar to Oracle's OEM without the need for 3rd party monitoring tools. The Performance Dashboard Reports and Integration...