Viewing 15 posts - 166 through 180 (of 227 total)
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...
December 27, 2007 at 8:48 am
Amen Brother Moden!
Sacrificial-Lamb also comes to mind.
To quote my brother: "I knew there would be a goat!"
December 27, 2007 at 7:24 am
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...
December 27, 2007 at 7:21 am
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...
December 27, 2007 at 7:14 am
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,...
December 27, 2007 at 6:55 am
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...
December 27, 2007 at 6:23 am
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...
December 26, 2007 at 7:25 am
Chris,
Another Crystal Resource is Tek-Tips.
They have 5 "Business Objects: Crystal" Forums:
Business Objects: Crystal certification & testing
Business Objects: Crystal Reports 4 Other topics
Business Objects: Crystal Reports...
December 19, 2007 at 12:03 pm
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...
December 19, 2007 at 9:51 am
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...
December 19, 2007 at 9:45 am
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...
December 19, 2007 at 7:55 am
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.
December 17, 2007 at 3:22 pm
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...
December 17, 2007 at 3:17 pm
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...
December 17, 2007 at 8:38 am
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:...
December 17, 2007 at 8:18 am
Viewing 15 posts - 166 through 180 (of 227 total)