Log Shipping

Technical Article

RE: Applying SQL Server 2000 Service Pack3

  • Reply

Allen, You're right. The SP3 installs fine on NT. The ticket was coming from a user with Windows XP. I verified and made sure that local policy for DEVICE: unassigned Device installation is set to "Silently Succeed". But when I double "setup.bat". The installation window does not show up. If I double click on the […]

You rated this post out of 5. Change rating

2003-06-09

2 reads

Technical Article

RE: Decimal Format

  • Reply

How did you 'define' your decimal field? The proper syntax is: DECIMAL(p,s) p=precision - the number of digits total s=scale - number of digits to the right of the decimal. So, to be able to store your numbers 2.5, 3.125, 4.1275 you would need a decimal column as: DECIMAL(5,4) -SQLBill

You rated this post out of 5. Change rating

2003-06-04

Technical Article

RE: Uncluster SQL 2000

  • Reply

To "uncluster" them, backup up all the DBs, detach the DBs, uninstall the virtual instances, uninstall the default instances, and finally uninstall the cluster service. If it is your desire to keep those two servers as SQL servers, you'll need to reinstall SQL Server and then reattach the user databases.

You rated this post out of 5. Change rating

2003-05-20

1 reads

Technical Article

RE: Fail Clustering

  • Reply

It might be possible with other vendors. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2003-05-20

1 reads

Technical Article

RE: how to split a field?

  • Reply

Hi, it should be possible to use conditional processing depending on what value is in the second field. Can you provide more information on what value field 2 can contain and what should be done with it? Cheers, Frank

2003-05-19

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