NJ-DBA (10/17/2011)

---

you could create a OS command job stem andcall sqlcmd from the OS with the header option set like so:

sqlcmd -h-1 -i "D:\scriptdir\script.sql" -o "D:\outputdir\outputtext.out"

fairly sure that'll...

you could create a OS command job stem andcall sqlcmd from the OS with the header option set like so:

sqlcmd -h-1 -i "D:\scriptdir\script.sql" -o "D:\outputdir\outputtext.out"

fairly sure that'll give...

Thank you!

derrick.pope (10/4/2011)

---

Ok. In further test I discovered that I can run the Tuning Advisor on the server using the trace files I had already created. I still cannot...

derrick.pope (10/4/2011)

---

I am trying to run the Tuning advisor against a 2008 database. I have used profiler to capture a trace file, I used the tuning template to generate...

rjoseph (10/4/2011)

---

Thanks very much. I was able to restore that database to a new name by using the "move" feature. I have tried the gui but it did not give...

rjoseph (10/4/2011)

---

Looking for help in restoring a production database to a different name in order to restore a wiped out table.

Dont have this options in the gui to perform this...

tripri (9/30/2011)

---

I got to design a package whihc will pull some recordsfrom source to destination. The scenario here is

Table A

name----id----date

A-------1-----09/27/2011

A1------2-----09/27/2011

A2------3-----09/28/2011

B-------4-----09/28/2011

B1------5-----09/28/2011

Here A1 and A2 are the dependents of A

B1 dependent of...

Seems like it's there in the second line: (Not enough storage is available to complete this operation.).

a disk is full...

can you post the error log from the point of a startup? the server isnt starting in single user...

Ken Davis (9/30/2011)

---

We have a SQL 2008 R2 instance where the Master db seems to be in single_user mode. I say it that way because the SSMS GUI and...

eh, I did oversimplify. The problem is that there are a large variety of statments... various delete and selects which are formatted as above. I wanted to use...

NJ-DBA (9/26/2011)

---

If, for example there are a large batch of statements like

select * from table1 where cola = @variable

delete from table1 where colb =@variable

It seems that DTA can not...

Ninja's_RGR'us (9/21/2011)

---

Of course this can change. It's an estimate and if there's contention the end time will change.

There are also start & end process that can screw this up...

NJ-DBA (9/21/2011)

---

Ninja's_RGR'us (9/21/2011)

---

NJ-DBA (9/21/2011)

---

Henrico Bekker (9/21/2011)

---

try using the following:

use master

go

SELECT

percent_complete AS ‘PctComplete’,

start_time AS ‘StartTime’,

...