In Management Studio you should be able to see your instance in the Registered Servers tab (View->Registered Servers).

If not, right click on the Database Engine row tree and choose Update...

You can Export and Import your list of Registered Servers in Management Studio.

On your old machine: Open the Registered Servers tab, right-click on a group of servers and choose Export....

A more simplified version:

Print CONVERT(char(8), GETDATE(),14)

exec master..xp_cmdshell 'copy \\ipadddress\txtdatafileforplanning\salestable.zip D:\FilecopyEpinav\Script_filecopy'

Print CONVERT(char(8), GETDATE(),14)

http://www.juliankuiters.id.au/article.php/t-sql-time-without-date

The ASPNet service will have a random login generated at install, so both machines will be different. The ASPNet login probably doesn't have network access either, so wouldn't be allowed...

SET IMPLICIT_TRANSACTIONS [ON | OFF]

will set transactions only for the current connection.

To change the server default for all new connections:

In Enterprise Manager: Right click server -> properties -> Connections tab...

Windows Authentication can be used, but the same username and password must be present on both the client and server machines (and have permissions to SQL Server of  course).

I've used both the products, and in terms of performance and output size, they are almost identical (only 2% size difference). Both have slightly different feature sets, but overall they...

Maybe....

-- Create temporary table with identity / auto-incrementing number

CREATE TABLE #Conv (ConvID int IDENTITY(1,1), OrderID int)

-- Insert the existing orders, identity values are automatically created

INSERT INTO #Conv (OrderID)

SELECT OrderID FROM...

DATEADD() is the function you need to use to add days to a date. (It's also the same function you use to subtract days).

As Farrell said DATEADD( day, 14, OPENDT)...

The Web version (and possibly the normal app) would be using ADO.

Every SELECT statement creates a RecordSet in ADO, and these are entirely different objects to messages (PRINT).

One way that...

cross post: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=22&messageid=202264

In DMO I think you need to look at each of the members for each of the roles in the database/server. checkout EnumServerRoleMember in BOL.

If you are using windows 2000 Professional, only the Developer edition of SQL Server 2005 will install.

Enterprise Edition requires a Server version of Windows.

Did you install a named instance of SQL Server 2005?

It's possible to install SQL Server 2005 in a side-by-side installation with SQL Server 2005. Check the "services" in control...

SQL Server 2005 can be installed in a side-by-side installation with SQL Server 2000. One of your instances would need to be a named instance.

SQL Server 2005 requires the .Net...