Yes - it will generate all scripts. I do not know whether or not it can be automated - but it is easy enough to find out. Download...

Muralidharan Venkatraman (2/19/2008)

---

Hi,

My transaction log file has grown to 25GB.

I did dbcc shrinkfile which did not help much.

Pls confirm if this is the right procedure.

1. Backup the database.

2. Backup...

What you are asking about is a multi-node cluster (one cluster with three nodes). You cannot (afaik) have two separate clusters sharing a node.

With that said - yes, you...

Jason Wisdom (2/14/2008)

---

Actually, that is exactly it.

I want to duplicate the database.. EXCEPT for...

Lookup_BI (2/12/2008)

---

Peso,

Im the one who logged that topic on SQLTeam as well.I currently have got the INSERT part working with some help.Currently working on Update.

I know it is a very...

One thing you also should be aware of is that you always have the option of executing a SQL Task in your maintenance plan.

So, you don't have to use the...

Sorry - the command should be:

Use [db1]; Execute sp_updatestats;

Use [db2]; Execute sp_updatestats;

...

Just one other note: In SQL Server 2005 the system stored procedure 'sp_updatestats' has been improved to only update statistics on tables that have been modified.

If you use the maintenance...

John Morris (2/3/2008)

---

jeff.williams3188 (2/3/2008)

---

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select...

You can also use variables in the CTE:

DECLARE @myVAR int;

SET @myVAR = 1;

;WITH myCTE (col1)

AS (SELECT col1 FROM myTABLE WHERE col2 = @myVAR)

SELECT * FROM myCTE;

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select only those objects...

I know you stated you did not want to use third party tools, but I am assuming that is because of cost. So, visit http://www.quest.com and download their free...

There is an option to repair minor errors. If that option is checked - then exclusive access is required to run the integrity check.

Generally, you do not want the...

A couple of ways to find out:

Open Activity Monitor, find the process and see what commands are being run.

Or, install the Performance Dashboard Reports from Microsoft. Run the report...

239 columns? You definitely have a problem with normalization. I would highly recommend normalizing this table.

The only reason I could see having this many columns (and this is...