Viewing 15 posts - 4,366 through 4,380 (of 6,105 total)
We're primarily a SQL Server shop, but I do play with MySQL off and on.
MySQL, using the Berkeley piece, does support transactions. Stored procedures, true referential integrity support, and...
May 14, 2003 at 7:53 am
The app role binds to the connection itself. This means if you're doing things like Resource Pooling with OLE DB, the app role is in effect, even if your application...
May 14, 2003 at 7:44 am
Nothing short of a trigger to override. The DEFAULT only takes effect if someone doesn't enter the date/time. If you're allowing data entry via Query Analyzer, then they can choose...
May 13, 2003 at 3:26 pm
Verify that the Microsoft Search service is running under the LocalSystem context as well on both nodes.
Is this an active/passive or active/active cluster?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to...
May 13, 2003 at 3:23 pm
Take that SQL query you're printing directly and you'll see the same error.
If TableName is a column in the Hist table, and it contains character data, then you probably need...
May 13, 2003 at 3:21 pm
I give some good generic sources here:
http://www.sqlservercentral.com/columnists/bkelley/gettingcertified.asp
Of course, if you have a question that isn't a "brain dump" question, here is a good site.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide...
May 13, 2003 at 3:06 pm
quote:
A developer in our company changed her password and since then this error has been happening intermitently.
May 13, 2003 at 1:40 pm
Allen is right, no user-defined server roles. What you can do as a work-around is make the requisite permission changes in the existing databases and then also in the model...
May 13, 2003 at 1:39 pm
Let me ask a known Lawson guru if he's seen any problems with SQL Server 2000 and the config you've mentioned. We've got the reknowned Kwane McNeal at our site...
May 12, 2003 at 1:38 pm
After making the registry change, you stopped and restarted SQL Server?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
May 12, 2003 at 11:08 am
These disconnects persist after you've done the MDAC upgrade?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
May 12, 2003 at 11:05 am
Default instance:
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode
Values:
0x00000002 = Mixed
0x00000001 = Windows only
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
May 12, 2003 at 9:15 am
Does your user account have the appropriate rights to modify the registry key? That's where the value that determines the startup mode is actually recorded.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish...
May 12, 2003 at 8:30 am
or simply:
net start "mssql$<instance name>"
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
May 12, 2003 at 8:28 am
A few questions:
(1) What version of Lawson?
(2) What version of Apps?
(3) Lawson on same or separate box?
On a related note, have you seen the Lawson SysAdmin group on Topica (http://www.topica.com)?...
May 12, 2003 at 8:27 am
Viewing 15 posts - 4,366 through 4,380 (of 6,105 total)