Mining

Technical Article

RE: Making database smaller

  • Reply

I can't see your hard drive, so the image doesn't show, but the screen does take a few seconds to fill in (about 6 seconds for me). What I see in the mean time is some gray backround at the top for what will be a menu and three horizontal rules spaced out a bit […]

You rated this post out of 5. Change rating

2005-03-02

Technical Article

Workflow question

  • Topic

In my DTS package I have two connections: GA2_remote, GA2_local Let's say I have a Data Pump.Then on successful completion of this data transfer I want to do another Data Pump with the same GA2_remote and GA2_local connections.Can I do that? If yes how do I control the workflow? How do I say SQL Server […]

You rated this post out of 5. Change rating

2004-10-12

Technical Article

RE: Setting Up SQL Mail

  • Reply

Thanks for your reply... the default mail client is set to be Outlook 2000 and not express.Second, how do I modify the Sql Agent Mail properties?  If I go into the services and open up the properities for the SqlAgent it doesn't give me anything... I am still confused because when I try to set […]

You rated this post out of 5. Change rating

2004-10-07

Technical Article

RE: Count day pr mont, year

  • Reply

ANavn cannot be null see http://www.cyren.no/diagram3.gif  Shall i only put the             SELECT DISTINCT GjelderFra FROM marsh_HKL.tblhertzkorttidsleiebiler,                         LEFT JOIN marsh_HKL.tblhertzkorttidsleieAvdeling                                 ON FKBRAvdeling=AID --AND GjelderFra BETWEEN @datoFOM and @dataTOMin the first select or both?With this i get error: ******************************* Incorrect syntax near the keyword 'LEFT' *******************************  

You rated this post out of 5. Change rating

2004-10-07

Technical Article

Cannot add domain group

  • Topic

Hi folks.   I have not seen the following before: I cannot add the security group ‘domainname\LADM SLEEC DEV’ as a login to SQL Server which complains that the group does not exist.  If I use Enterprise Manager and attempt to add the user, I can see that the group does indeed exist in the domain… Now, […]

You rated this post out of 5. Change rating

2004-09-27

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

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