We are running SQL 7.0 SP1. How do I determine which version is installed, i.e. Standard vs. Enterprise? And if Standard, can this be upgraded to Enterprise with the SQL 2000 installation? Thanks Jay
2001-07-10
37 reads
I am curious how does SQL Server handle simultaneous calls to the same stored procedures.For example I have a stored procedure GetResults which is simulatneously fired by 1000 clients then how will the server handle this.Will it wait for the first one to complete execution send results back and then fire another or it will […]
2001-07-10
4 reads
Hi all I read a while back (somewhere!) about what msdb stored procedures to restrict to prevent users from a) Creating or modifying packages b) Viewing (seeing a list of) packages) I can take some pot guess and spend hours doing it, but can any point out the exec privs for some of the sp_enum […]
2001-07-10
6 reads
Hi Folks Im a Lotus notes , NT administrator living in Sydney Australia with no real sql knowledge. I installed The MSDE from the MS office 2000 CD onto my NT server and configured an SQL datasource to connect to it on my Windows 98 PCs. Basically I only intend using MSDE as an object […]
2001-07-09
3 reads
Using VB code generated from scriptpkg, I have created an ActiveX DLL which imports a given data source into a SQL 7.0 table. The Threading Model of the VB project is set to "Single Threaded" and the ExecuteOnMainThread properties (one for the Source Connection, and one for the Destination connection) within the DTS scripting is […]
2001-07-09
2 reads
Given a choice which is the best place for the SQL server binaries?on local w2k server drive or SAN drive.I have allocated RAID1 array on SAN drive. Hitesh
2001-07-09
2 reads
Hello, I have SQL SERVER 2000 on WINDOWS 2000 ADVANCED SERVER, there is a problem: I use coldfusion language to add data to SQL 2000 Database> .When I open database for retrieve the data the result as : ?????????????????????????? this is because i use ARABIC LANGUAGE and it is a non UNICODE language . -I […]
2001-07-09
24 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/lsmith/aggregatingasetofhierachicalrecords.asp
2001-07-09
5 reads
What's the best way to size TEMPDB? Perfmon lets you monitor % Log used and Database size, but not % use don the database. Ou TEMPDB is 2GB for some reason. I was thinking to resize it to something fairly small, say 200-500MB, and set auto-growth on. Thanks Jay
2001-07-06
15 reads
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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