Current Activity
Is there a script that I can use that will show me all the users currently showing activity on any given database. I'd like to find another way rather than looking in the Process Info.Shane
2004-07-12
1 reads
PowerShell
Local vs global cursor
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-07-12
Newbie - How to Do This (if Possible)
Hi Members:I have never used replication before so please excuse my ignorance. Here's the situation:I have set up various sql2000 databases on my client's server (SBS2000). Every month, I remotely access their server (through PCAnywhere) and obtain their database so I can perform statistical analysis on the data. Currently, what I do is detach the […]
2004-07-08
How to backup and restore XML and Full text Indexing
Hi Allam moving all user databases from one server to another I need to know how do I backup and restore "Configure SQL XML support in xml " and full text indexses uses in some applications. can some one provide with any white papers. I have no much idea about xml and iis configuration as well. Thanks […]
2004-07-06
RE: GROUP BY vs DISTINCT -- SQL SERVER BUG ?
the unexpected results are because you are returning 3 fields in the (from recordset) - these are only grouped by 2 fields, one row for each sr.eid is being returned. distinct will include EID in the group and hence the number of rows is less as the duplicate rows are removed.
2004-07-01
RE: GROUP BY vs DISTINCT -- SQL SERVER BUG ?
Hi Peter,I don't think that Julian's claim is correct. For exampleselect left (filename, 1) as drive from master.dbo.sysaltfiles group by left (filename, 1) order by 1 will yield the same result as select distinct left (filename, 1) as drive from master.dbo.sysaltfiles --group by left (filename, 1) order by 1If one omits the group by clause in […]
2004-07-01
What does this log entry mean?
I get this log record about half a dozen times a day. I would be interested if anyone could tell me what it means or at least give me an idea to whether or not I shoulod worry about it. Internal I/O request 0x6513A328: Op: Write, pBuffer: 0x0E2F0000, Size: 983040, Position: 2791352832, UMS: Internal: 0x0, […]
2004-07-01
3 reads
Unique Identifier: Usage and Limitations
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-06-28
Sql 2000 permissions help needed!
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-06-28
RE: Problems with a text import!!!! HELP PLEASE!!!
In case this helps, this is the ActiveX script that is being used in my datapump.'********************************************************************** ' Visual Basic Transformation Script '************************************************************************Function PreSourceMain() 'Declare Variables dim currentColumn 'Contains the current column to transform dim index 'index for looping through column headers dim columnHeaders 'contains the headers used in this transformation PreSourceMain = DTSTransformStat_OK End FunctionFunction RowTransformMain() columnHeaders […]
2004-06-24
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers