shri_sastry (2/9/2009)

---

Hello All,

I am running rebuild indexes as a nightly job every night. I see that the transaction log has grown to 140G(the database...

These are message from a third-party backup tool which tries to take a snapshot of the database.

Mike Levan (2/8/2009)

---

I see trace files only for past 2 days in the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG and i havea total of 4 files for 2 days each of...

SQL 2005 has implemented a new table sysjobactivity. There you find info about all running SQL Agent jobs.

Yes it's free as far...

You could use DDL trigers which capture any CREATE or ALTER LOGIN/USER command and log the results into an audit table.

If you have a lot of 2005 servers it might...

I'm not sure, but it looks like the passive node has not been updated. You might have to install CU1 on the passive node manually.

I have not installed that update...

Yes, it can. There is a management pack for SQL Server which supports SQQL 2000,2005 and 2008.

http://technet.microsoft.com/en-us/opsmgr/cc539535.aspx

Just did some more testing and I noticed that then you run the query against a SQL 2000 server, then the second part is not visible in the grid, but...

I've tested it on my system and it works.

But I have noticed that when you...

Your concatenation is actually working, but because you don't trim the trailing blanks you probably don't see the second part. Try using this instead:

SELECT RTRIM(cast(lastwaittype as varchar(100))) + '...

Because I don't know for which application the...

One more comment. I think you should change the datatype of your input paramters to varchar. Using CHAR(10) for the password will result in trailing blanks.

That's what happens when you just write some quick code without testing it. THe procedure fails because the password parameter adds the string without quotes. Change it to this:

ALTER PROCEDURE...

In that case you can try the /3gb switch and raise the max memory to 3 Gb.