I am the lead developer working on an intranet project and have run into a problem controlling changes to our development database. I'm not much of a DBA but here's what I need to do: I need a way to allow users to create tables in a database but not alter ones they have not […]
2004-02-12
Welcome to the club.At first I thought this in an issue with some service pack, because it disappeared with applying SP3. But after some time it happened again.Well, the good thing about it is, that it keeps me from using EM
2004-01-30
1 reads
Hi all. I have some databases that I can sometimes attach to a new SQL server (2kE) without the log file, and other times I can't. It was my understanding that it's not possible to attach a database without both the MDF and LDF, but it appears I can do so, usually after a backup […]
2004-01-13
1 reads
Dear all,now we finally got the 2-Xeon Hyperthreading Server, but SQL Server 2000 does not use its processors! Apart from parallel execution plans for a single query, which may be avoided by the optimizer for good reason, I at least expected the Server to run two parallel queries for two concurrently working users.The users call […]
2004-01-12
3 reads
Try this SELECT T1.Param_ID, T1.Value, MAX(T1.[Date]) as DataDate, T2.DefaultOrder, T2.Order1, T2.Order2, T2.Order3, T3.DataType_ID AS Type FROM dbo.tblValues AS T1 INNER JOIN dbo.tblParam AS T2 ON T2.Param_ID = T1.Param_ID INNER JOIN dbo.tblSetupKey AS T3 ON T3.Key_ID = T1.Key_ID INNER JOIN dbo.tblKey AS T4 ON T4.ID2 = T1.KEY_ID AND ID1 = @ID1 AND ID2 = @ID2 AND […]
2003-12-02
1 reads
hi, try (from BOL) create procedure {proc_name}... with encryption. create trigger {trig_name} on {object_name} with encryption Paul
2003-07-16
2 reads
Certainly sounds like you have you transaction isolation level set to repeatable read or serializable, and a transaction isn't being closed - so that the 'select' statement is holding its lock(s) indefinitely. You can check this with DBCC USEROPTIONS - which will show you the value if it has been explicitly set. If not, SQL […]
2003-07-01
Does this mean SQL Server Engine will use upto 2GB RAM for its usage and leave the excess memory for OS and other apps (if there is more than 2GB on server).
2003-06-30
1 reads
Just to make sure I understand, Frank says "I've never had orphaned logins". Does this mean the logins transfer OK if the SID does not already exist on the destination server?
2003-06-27
course you have to have the trace running. If you want to do this, set this up in a stored procedure, mark as a startup procedure, and then monitor and archive or delete this information over time. Probably need some weekly job to do this. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
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