PiMané (11/3/2009)

---

@Lynn Pettis

The data files, along with the system databases (data and log), are on a RAID10.

The log files are on a RAID1 and tempdb has a RAID1 of it's...

Run the following:

select * from msdb.dbo.restorehistory

People still have pagers??

If you already have the pager(s) check with the company and see if you can send email alerts via them. Many years ago at another company...

Totally forgot about those posts. Sad thing, they weren't that long ago. 😉

PiMané (11/3/2009)

---

ok,

Thanks and sorry for the confusion..

But since these databases aren't very used, they are important but not read/write intensive, there's no need to move the log file to the...

TempDB...

After running the ALTER DATABASE command and shutting down SQL Server, did you move the mdf and ldf files to their new locations before starting SQL Server again?

Whic actually means we aren't in a position to know what is best for them. We have asked for clarification and now we need to sit back and wait.

It would also help if you provided the DDL (CREATE TABLE statement(s)) for the table(s), sample data (as INSERT statements). What you have provided so far really isn't enough.

For...

However, it would also help if the OP would elaborate as to what the problem or issue is. Several questions have been asked seeking clarification which has not been...

Gianluca Sartori (11/3/2009)

---

If my calculations are correct this is post # 9000.

I set 7 posts per page, took the page number, multiplied for PI and divided it by the distance...

Curious,you looking for something along these lines?

create table dbo.Ticket (

TicketId int identity(1,1),

UserAssigned varchar(32),

UserData varchar(512) null,

...

Another thing you may consider. If you want to capture the data causing the error, you can insert that data into a table variable defined for that function, then...

My take on table aliases is simple, use them even in single table queries. Two reasons for this, first, you never know when an additional table may be added...

You can also start here[/url] and make appropriate changes to move the data instead of just deleting it. One way in SQL Server 2005 is to use the OUTPUT...