Agent

Technical Article

RE: Question of the Day for 21 Jul 2004

  • Reply

I found the following quote on the MSDN site at:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_6b3k.asp"Using AWE Memory on Windows 2000Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000 Address Windowing Extensions (AWE) API to support very large amounts of physical memory. SQL Server 2000 Enterprise Edition can access amounts of memory approaching 8 GB on Windows 2000 Advanced […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-07-21

Technical Article

RE: Change DB Owner

  • Reply

sa might be mapped to a user. The login would be sa, the user something else. select u.name , s.name from sysusers u inner join master.dbo.syslogins s on u.sid = s.sid Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-13

Technical Article

RE: Problem showing all records

  • Reply

Hi Mike, quote: There are 60 records in the parent table, 21 in one child, 27 in another child and 40 in the third child. Does that help? just doing time waiting for the weekend Maybe the easiest way is to create a view within EM. You can add the tables in question, use drag […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-13

Technical Article

RE: SMTP and sp_MakeWebTask

  • Reply

We've used a few different things to do the mail, CDO at one point and now looking at Lyris. Ideally you want to abstract yourself from the mail format if you can. We basically build a template, then the template gets some minor (for now anyway) personalization. You know, I don't know if we support […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-29

2 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers