Transaction Log

Technical Article

RE: DTS Problem on SQL Server 2000 SP3

  • Reply

A fix for this problem has been found.  Although slightly different to the one we experienced, the problem is described at : http://support.microsoft.com/default.aspx?scid=kb;en-us;814113   ...and the hotfix for it can be downloaded at : http://www.microsoft.com/downloads/details.aspx?familyid=9814AE9D-BD44-40C5-ADD3-B8C99618E68D&displaylang=en Hope this helps anyone else out there who has experienced the same issues with the DTS GUI.(With thanks to Paul […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-01-13

2 reads

Technical Article

RE: Export Date and Time to SQL Server

  • Reply

More than one way to skin the cat, I guess. I would create a query in Access that combines both columns into one, switch to SQL Server and import the data via Import/Export wizard into SQL Server. Once you reach the screen in the wizard where you can select what to import, click on transform and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-01-10

1 reads

Technical Article

RE: Can't Debug a Stored Proc

  • Reply

quote: All right: 1.) went through the DCOM settings on the server 2.) made sure DLL's were registered on client 3.) even reinstalled SQL Server client tools... It still doesn't work. I'm back in the market for clues...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-11

1 reads

Technical Article

RE: SQL Agent Starting - MS Cluster

  • Reply

Check a couple of things. One the account that sql server and the agent are set two run under have enough permissions to start i.e. usually a domain acount with local admin rights on each node. Two, check your dependancies in cluster admin and make sure that sql owns everything it needs to fail over […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-04

1 reads

Technical Article

RE: Schedule a DTS package

  • Reply

quote: Hi, like i m a newbie in DTS, i don't understand some thiongs about it. I want to schedule a DTS to be executed as a job. When i right click on my package to schedule it, no problem. When i go to SQL Server Agent/Jobs, i've got nothing ! Why ? Can't explain […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-04

2 reads

Technical Article

RE: SQL database backup from Arcserve2000

  • Reply

Hi, there, Normally, we only backup the system databases and user databases to tape devices through the ARCserver or other netbackup software. It does not need to back up the SQL database files. And it is recommanded to do some research on www.ca.com and maybe you could get the answers. Good Luck.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-02

1 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