Sorry, I was wrong. Once the license mode is set, you can't change the modes but you can add seat or processor licenses from control panel --> SQL Server 2000 Licence setup. But you still can change it by change the registry. '0' for 'per seat' and '2' for 'per processor'. HKEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo\MSSQL8.00
2003-08-22
1 reads
Anything new implemented on the server last Thursday/Friday? Or, any config change at all? Cheers, - Mark
2003-08-21
There is a registry change needed. I had the same problem, made the change and everything was fine. Can't find it right now, but I'll dig a little later. Note it has nothing to do with SP3a, I had it while we were still on SP2. GOT IT check mskb 281345 !!! KlK, MCSE Edited […]
2003-08-19
DTS packages are kept on the server but you can save them (design package/ save package as) to a local or network drive as a visual basic package (.bas, a text file which can then be added to stuff like MSAccess to execute). You find them in Enterprise Manager under Data Transformation Services.
2003-08-18
1 reads
In practice, yes, you are correct. Part of the frustration is the following when you set c2 (even to the same value it was previously): quote: DBCC execution completed. If DBCC printed error messages, contact your system administrator. Configuration option 'c2 audit mode' changed from 0 to 0. Run the RECONFIGURE statement to install. When […]
2003-08-15
Developer is upgradeable to Enterprise Edition. Check BOL. No backup/restore/uninstall would be needed.
2003-08-08
Hi, I still can't tranfer my LOG file. Is there any other way that I can transfer my database from 1 machine to another?These machines are not networked. Please help. yogi
2003-08-08
1 reads
What you need to do is create a store procedure which accepts a date as parameter. Then using a where clause filter out the records for this date. Then use the group by command and group by customerid. e.g. use northwind database select shippername,sum(extendedprice) from invoices where requireddate='1996-10-23 00:00:00.000' group by shippername Relationships are like […]
2003-08-08
quote: Why not session_user ? Because session_user returns the database user name, not the login name.
2003-07-29
1 reads
Will this help If exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Parent_Child_Delete]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[Parent_Child_Delete] GO If exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Parent_Child]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Parent_Child] GO CREATE TABLE [dbo].[Parent_Child] ([Parent] [int] NOT NULL ,[Child] [int] NOT NULL) GO ALTER TABLE […]
2003-07-21
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers