Enterprise Manager, click on new (shell) database, On menu select Tools -> Data Transformation Services -> Import Data..., In DTS Import/Export wizard Click <Next>, choose a data source and Click <Next>, Chose a...

Just double checking.  What date is today?

On the SQL server I am currently working, SELECT GETDATE() returns '2005-02-18 11:43:52.873'.  When users login to domain, the date and time is adjusted to...

If SQL server logins need to be exported to a new server, as in arthurgar situation, all SQL user, including users of other database will be scripted.  You may not...

Ryan.  Examine this statement:

SELECT CONVERT(DATETIME, '@ExpirationDate + '01', 112).  s

This statement is very simple, but it may be difficult to understandd by programmers of other languages.

To illustrate, look at the following examples:

1) SELECT CONVERT(INT, '')   AS [CONVERT(INT, '')],   CONVERT(DATETIME, '')   AS [CONVERT(DATETIME, '')]   

2) SELECT CONVERT(INT, NULL) AS [CONVERT(INT, NULL)], CONVERT(DATETIME, NULL) AS [CONVERT(DATETIME,...

Create a table (Holiday) with two columns, and enter holiday dates and country where they are observed.  Both columns should be the Clustered PK.  If the same holiday is observed...