I figured it out...until I did not get an error... 😉

ALTER DATABASE tempdb

MODIFY FILE (NAME = templog, FILENAME = 'X:\SQLtemp\logs\tempdb.ldf');

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'X:\SQLtemp\data\tempdb.mdf');

Is that the exact syntax?

The new directory would be X:\SQLtemp\data and X:\SQLtemp\logs for logs.

Remember I know nothing about SQL, so make it as simple as you can.

Thanks

I already have SP4 installed for SQL 2000. Hmm... I wonder what it could be?

Very cool... This makes this much easier... Now to see how to migrate from Exchange 5.5 to Exchange 2003...

I figured it out... Needed the database name + .dbo.ARM11

select * from ARM11

Yeah, sorry... I'm not using quotes...

This is the error message I get:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'ARM11'.

Well if this site is the best around, it failed to help me in my simple question.

Leg work? Are you kidding? You guys are really that stuck up? Thinking you are all hign and mighty.. Damn! I did not ask you to write a complete script,...

I'm surprised to see you talk like this, and scare people away from this forum... You should be banned. Because it should not be like this, for people trying to...

I asked a simple question... all you had to say was: SELECT * FROM tablename. and I would have said thank you. But you had to bitch about how you...

Then may I suggest shutting down the forum then.. Because there would be no need to have it, if you're not going help anyone...

If I needed to see data in a table what would be the syntax?

If I wanted to see data in a table, what would be the syntax?

Why would be so buried and hard to find.... Don't answer that.

Now that this is done, on to my next post / question.