SMO

Technical Article

RE: Running DTS packages from ASP

  • Reply

Here's the code that connects to the database Const DTSSQLStgFlag_Default = 0 Const DTSStepExecResult_Failure = 1 Dim oPkg, oStep, sErr, bSuccess Dim sServer, iSecurity, sUID, sPWD, sPkgName, sPkgPWD ' Get Form Variables sServer = Request.Form("txtServer") iSecurity = CInt("0" & Request.Form("optSecurity")) sUID = Request.Form("txtUID") sPWD = Request.Form("txtPWD") sPkgName = Request.Form("txtPkgName") sPkgPWD = Request.Form("txtPkgPWD") ' Validate Variables […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-15

Technical Article

RE: QOD 11/25

  • Reply

I never look up first, I treat these questions as test questions to find out how much I do know to prepare myself for the exam. quote: I always answer without researching. Except for today. And if 60-something percent of respondents got this one right, it means they went and looked it up. (I look […]

2003-12-09

Technical Article

RE: delta processing: alternative to cursor

  • Reply

Jeremy, There may be some things in your SQL that we could look at that might speed things up. But aside from that, speed is not the only problem with CURSORS; they can also have serious memory problems associated with them that a SET-based solution usually doesn't. That said, there ARE times when a cursor […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-07-30

Technical Article

RE: Install stuck!

  • Reply

Finally figured out what the problem was. Thanks for the response, hirenk; here's the short version of the story. I sometimes do installs off a copy of the SQL CD that I keep on a hard disk. Somehow, a DLL on that copy got updated (ssnetlib.dll), so that it wasn't compatible with the base install […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-07-15

1 reads

Technical Article

RE: Running Totals in Stored Procedures

  • Reply

You are cross posting - the site owners get cross about that kind of thang. This is one way to create break totals and running totals without cursors or temp tables. set nocount on create table #running (keyval int identity(1,1) not null , breakval int not null , runval int not null) insert into #running […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-07-08

Technical Article

RE: Check SQL Server Uptime

  • Reply

uptime.exe is a resource kit utility that will also show you the uptime for the server. If it's a dedicated SQL box, this should be close to SQL's uptime, though SQL could potentially stop and start without the server rebooting. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

2003-07-03

1 reads

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

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...

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