RE: Inserting bold text in emails
in @subject ??? i'm not sure about anyone else, but i've never seen an email client that has formatting in the subject header - only in the body text.
2004-08-02
FILESTREAM
RE: Blog of SQL2K SP3a clustering Win2003 3 nodes Clustering.
We've actually decided on holding off on installing SQL Server 2000 on Windows 2003 clusters. Unless MS has fixed this in recent days, SQL Server has to come up after MS DTC or it may not register properly. This means distributed queries will fail. If you aren't using distributed queries, this isn't a big deal […]
2004-07-30
RE: creating new backup device on network drive
Most of the time, it's a permission error. Is your SQL Server service started using the Local System account or a windows user account? To use a network drive, it needs to be started using a windows user account, with the appropriate permissions granted to this account. To test if you have set it up correctly, use […]
2004-06-25
RE: Unauthorized attempts to login
I forgot what it's called - DSN or DSNless. This is what I use: PROVIDER=SQLOLEDB.1;DATA SOURCE=MachineName;INITIAL CATALOG=DatabaseName;USER ID=iserid;PASSWORD=password; Where would I need to insert port? I need to read some ASP or VB documentation.
2004-06-11
Installing SQL SERVER 6.0 in Windows 2000 Professional
HiI am trying to install SQL SERVER 6.0 in my desktop (Windows 2000 Professional). I need to select Binary Sort order for the installation instead of the default (Dictionary). If I select, binary sort order my installation will not be completed. While installation process, it comes to the point “Configuring Sql Server” and hangs. I […]
2004-03-02
3 reads
RE: Stuck on a tricky query ... please help?
Many thanks guy's. With your help you have saved my sanity. Problem solved.
2004-02-25
Cross Server (DB) Update DTS Package
BackgroundWe are currently implementing a New Planning system where the Data is stored in Oracle but the Web Interface is Via a SQL Server on the DMZ.We have added triggers to the Oracle database to populate tables on the Oracle Server with all changes (Inserts, Updates and Deletion) to the Data.These Tables are then Imported VIA DTS […]
2004-02-23
2 reads
2004-02-20
2004-02-12
How does SQL Server store a Page ???
A quick maths.Size of a SQL page = 8K = 8 * 1024 = 8192 BytesPage Header Size = 96 bytes (as per BOL look for Pages and Extents).so total Free bytes available to SQL Server Page = 8192 - 96 = 8096 bytes.Again as per BOL, Maximum row size = 8060, which includes row […]
2004-02-04
8 reads
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