functions

Technical Article

DB Design question

  • Topic

Hi everybody I would appreciate some help with the following design problem: The application is about documents with paragraphs. The documents are in a table, and each document consists of various paragraphs, which are also kept in a table. If a document is created using paragraphs 1, 13, 27 & 54, it is easy to […]

You rated this post out of 5. Change rating

2005-01-25

Technical Article

RE: Windows vs Mixed Mode Authentication

  • Reply

OK.About "differences between Windows Authentication vs Mixed Mode Authentication when using SQL Server", well, functionally there are none.Once inside the DB, everything works as advertised.However, from the User Rights management point of view you are much better off with mixed mode vs. internal or windows only.Why?...Some Software only works well with an Internal System Administrator password. […]

2004-06-07

Technical Article

RE: Deceptively hard - xfering single records to another database

  • Reply

Here are some sources of DTS information if you decide to investigate John's suggestion further.Executing DTS from ASP: see http://www.sqldts.com/default.aspx?207Control access to DTS packages with owner and user passwords. see "Handling Package Security in DTS" in BOL.You can pass parameters to a DTS package by using a Dynamic Properties Task and global variables.  See both […]

You rated this post out of 5. Change rating

2004-05-11

Technical Article

RE: Copy database

  • Reply

There's an article on MSDN with this error:http://support.microsoft.com/default.aspx?scid=kb;en-us;274463In summary it says if the destination server is started with the Local System account, or an account that does not have local admin rights on the source then this error will occur.

You rated this post out of 5. Change rating

2004-04-27

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