bdragoo (3/5/2008)

We're moving data centers, and we're just restoring the master database to our new instance of SQL 2005....unless that is for some reason unnecessary, as I'm restoring all the...

byron.baker (3/5/2008)

---

When I look at windows task manager, the SQL Server process is using about 330 megabytes of RAM.

I would like SQL Server to use approximately 2gb instead of 330...

Oh whoops, I just read again ... you're trying to restore, not move ...

Can't say I've ever had to restore the master db, I've rebuilt, but not restored. Out of...

This sounds so familiar ... it's been a couple years, but I remember it being something about msdtc or mdac running ... Can't seem to find anything on Google about...

You need to start in minimal config mode (/f) and skip recovery on all db's except master (/T3608).

Basically, stop SQL and then

NET START MSSQLSERVER /f /T3608

x86 or x64 SQL Server will use the pagefile after it has reached its maximum available memory regardless. I just don't understand how/why x64 would automatically use the pagefile if...

EdVassie (3/5/2008)

---

Hopefully you will haveseen this already, but in 64-bit you MUST set the upper memory limit for SQL Server. Otherwise it treats the pagefile space as part of...

Not sure I follow, but are you asking to...

I believe there are some freeware tools out there that could assist with such a thing ...

If I were to do it though? I'd say create a procedure to run...

This should get you started in the right direction ...

SELECT * FROM msdb.dbo.sysmail_log

If you leave the default trace running (on by default), you can view a built in report. Right click database -> Reports -> Standard Reports -> Schema Change History.

Yet if...

I do that in my procs, but never with views ... I just updated it to include the view.

It still needs some work though ...

You can filter a view ...

Personally, I prefer procs and views as you can create a wrapper process to keep them in a "admin" or "dba" database on all your...

What is it that the users are attempting to do?

By default (someone correct me If I'm wrong, as there is no documentation on this xproc), only sysadmins, msdb dbo's (?),...

ALZDBA (3/4/2008)

---

there is a DMV exposing this in sql2005, I'll have to do a little search on it.

this comes from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2892190&SiteID=1

(I don't have my own scripts available for the moment)

--...