How to transfer the logins and the passwords between instances of SQL Server 2005

http://support.microsoft.com/kb/918992

--

How to transfer logins and passwords between instances of SQL Server

(covers SQL Server 7.0 to 2005 (9.0))

http://support.microsoft.com/kb/246133

Amen Brother Moden!

Sacrificial-Lamb also comes to mind.

To quote my brother: "I knew there would be a goat!"

amit,

Your data in the DATETIME format may be out of the boundries of SMALLDATETIME.

DATETIME

January 1, 1753 through December 31, 9999

SMALLDATETIME

January 1, 1900 through June 6, 2079

Microsoft SQL Server Books online...

All that I have in my script library is a cursor-based script, which believe came from the SQL Server 2000 Books Online (BOL).

--

--Begin Script--

/*Perform a 'USE ' to select...

I agree with Steve and Jeff.

Do DBAs need local system admin privileges?

... and with Information Technology almost every answer starts with "it depends".

In my experience,...

In an nutshell: We write all BAK and TRN backup files to a specific folder (DB_BACKUPS) on each database server. Several times a day (depending on the frequency of...

I agree as well.

All 4 books of the "Inside SQL Server 2005" series will help in creating a solid foundation, but to focus on your goal of SQL Development I...

Chris,

Another Crystal Resource is Tek-Tips.

http://www.tek-tips.com/

They have 5 "Business Objects: Crystal" Forums:

Business Objects: Crystal certification & testing

Business Objects: Crystal Reports 4 Other topics

Business Objects: Crystal Reports 3 Integrate

...

Bryan,

Not a problem!

There are several different ways to parse your data into the correct destination table, once it is loaded into the staging table.

Keep us posted on how...

No. We want to load the data into the staging table, so that we can begin to work with data at the column level.

The lack of a staging...

I agree with SQLBill.

You will save yourself a lot of headache by loading the data into a staging table first via BCP or a DTS package.

Once the staging table is...

Chris,

Thanks for the link, I have added the site to my Favorites. I will be sure to get it to our Lawson Admin as well.

With the ODBC/DSN settings, I would recommend that you use the "readonly" account as well. By using the "sa" credentials in the DSN you are circumventing the security that...

Chris,

We have a SQL Server 2000, Crystal Reports XI and Lawson 9, with Lawson Business Intelligence 9 environment (LBI).

The Crystal Report and SQL Server issue is difficult enough, but adding...

I have a similar setup with a SQL Server 2000 database server.

User: readonly

General

SQL Server Authentication

Default database - Master

-Server Roles

None

-User Mapping

Users Mapped to this login: all databases checked

Role membership:...