You could shrink the log file first and then set it to what you want.

The typical file extensions are:

Full Database Backup - *.bak

Transaction Log Backup - *.trn

Differential Backup ...

SQL Server 2008 has "Edit top 200 rows" SQL Server 2005 is "open table"

I do agree though that you should use this for minor updates.

Yes you can. Just right click on the table you want to update in management studio and choose 'open'.

Open a new query window and execute this SQL statement:

Select ServerProperty('ComputerNamePhysicalNetBIOS')

Lucyhampson1 (2/3/2010)

---

erm hey my friend just told me to find out what node i'm on, i don't know what a node is or anything so i signed up to this...

Hmm... It is... 97 dollars?? lol

Try this:

Select ServerProperty('ComputerNamePhysicalNetBIOS')

Green Bay, Wisconsin

Hey Andrew, thanks for the reply

Yes I did change the MsDtsSrvr.ini.xml file and it is installed on both nodes. It works fine

just not when connecting to SSIS when on the...

All system db's or a specific one?

Something like this would work

declare @variable float

set @variable = round(((555* 1.0) /1203) * 100 ,2)

select @variable

Do you have SysAdmin rights?

Hi

I believe if I'm understanding your question adding another column to the table and making the default value of that column as "getdate()" this will give you the exact time...

Hi

I've never done this personally but you can check out this website:

http://mattiasgeniar.be/2008/07/16/installing-sql-2000-and-sql-2005-on-the-same-server/