Interviews

Technical Article

MSDE/Access - client shut down

  • Topic

I am using MSDE on Server NT4 (256 Mo of memory). When sqlserver memory reaches 128 Mo, there are troubles on PC clients (using access2000). Clients must shut down Access and I must relaunch sqlserver to free memory each day... How to solve the problem ?

You rated this post out of 5. Change rating

2002-02-06

Technical Article

Restoring a database in another server using DMO

  • Topic

I have a database backup file in one machine and want to restore the same database in a another machine using DMO. Is there any way other than copying this backup file to second machine and then restoring? I need this functionality during installation where the user can select any sql server in the network. […]

You rated this post out of 5. Change rating

2002-02-06

2 reads

Technical Article

Accessing column descriptions

  • Topic

Does anyone know where I can programmatically grab user table column descriptions? I have entered table column descriptions using the 'Design Table' interface in the Enterprise Manager. I tried looking in the syscolumns and syscomments tables thinking they would be there, but they are not. Thank-You...

You rated this post out of 5. Change rating

2002-02-02

2 reads

Technical Article

communication Link failure

  • Topic

After managing to install a new helpdesk system onto our server I keep getting an error message "communication Link Failure". I have looked at the server but cannot identify what the cause could be. does anyone have any suggestions or ideas?

2002-02-01

37 reads

Technical Article

Dynamic SQL and User defined Functions..

  • Topic

Hello All.. I need to execute Dynamic SQL in a user defined function after passing the table name as a parameter and the return value has to a table. When I try to do this I get the error message "Only functions and extended stored procedures can be executed from within a function." Please Help […]

You rated this post out of 5. Change rating

2002-01-28

3 reads

Technical Article

Books

  • Topic

Hi Is their any good books for SQL 2000 Thank you Ray

2002-01-11

Blogs

A New Word: Mottleheaded

By

mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...

Democratizing Core Contributions: A Guide to WordPress.org Badges 

By

In the WordPress community, badges aren’t just for scouts.

Microsoft Purview GA menu’s

By

The new data governance features in Microsoft Purview are now being made generally available...

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