Clustering

Technical Article

RE: Connect to different servers thru stored procedure

  • Reply

Short answer (based on complexity) you can't.  Why not use tried and true methods such as OSQL i.e (inside a BAT file)SET ChangeRecord=ABC123 SET LOGDIR="C:\Temp\%ChangeRecord%" IF NOT EXIST %LOGDIR% MKDIR %LOGDIR% SET LOG=%LOGDIR%\ProdInstall_%ChangeRecord%_runsql.log SET PREFIX=%LOGDIR%\prd. SET SRVNAME=YourServerNameHere SET DB=YourDBNameHere ECHO. > %LOG%osql  -S%SRVNAME% -E -n   -d%DB% -i "C:\Temp\PROD\Database\Stored Procedures\SPNAMEHERE.sql" -o %PREFIX%SPNAMEHERE.sql.err >> %LOG% OR a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-24

Technical Article

RE: Odd Bookmark Behaviour

  • Reply

Thanks for the info.  However, to make things more fun I took the bookmark out of it.I'm using this in the combo box with the string explicitly set  Me.RecordSource = "select * from Party"   Call Me.Recordset.FindFirst("[ptyrfnbr] = 51756")51756 is for the pary Smith, Joe.   I put a stop breakpoint right after the Call Me.Recordset.FindFirst("[ptyrfnbr] = […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-04-22

Technical Article

RE: Starting SQL server - error 1068 and error 193

  • Reply

These both appear to be OS errors, as the corresponding errors in SQL Server have messages that don't seem to apply.  I will assume that when you get the error 193 from the mssqlserver service, it fails to execute.  If this is true, that is probably why SQL agent won't run.  It is dependent on […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-03-23

Technical Article

RE: Windows vs SQL Auth - Performance Issue??

  • Reply

SQL Server hitting the network for NT account verification has got to be a factor in here somewhere. I am by no means conversant with the subject, but if you're granting SQL Login access to NT security groups, SQL has to be going out to the network to check what groups a login attempting to establish […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-01-25

Technical Article

RE: datetime

  • Reply

1) WHERE (DATEDIFF(d, datelogged, GETDATE()) = 1)2) WHERE (despatchdate BETWEEN '" & convDate(dteFromDate) & "' AND '" & convDate(dteToDate) & "') 'Using function to massage date.3) WHERE orderdate > Getdate() - 3    

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-01-04

Technical Article

RE: Single or Mutlible tables?

  • Reply

A financial accounting system indeed requires a very well-designed database. However, I think most systems here mix the pure OLTP data with presentational stuff. A journal is such a presentational issue. It can be achieved either by directly querying the transactions table or via several intermediate tables. We're running SAP R/3 here and if I […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-01-04

Technical Article

RE: sql returning no records when search field left blank

  • Reply

I tried all these and none worked. If it helps, im using "get" on the form and then request.querystring in the sql. I cut and pasted each of the above suggestions and all return no records when the school parameter is blank. http://www.thebrickhousetestsite.com/search_residential.asp The code is simple:<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../Connections/rmls.asp" --> <% Dim Recordset1__MM_neighborhood Recordset1__MM_neighborhood = […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-12-28

Technical Article

RE: Adress interval into multiple records

  • Reply

Thanks for your reply Charles But this will only give the house_number_start and house_number_end, and if there is more than two housenumbers in the interval (like Pieroad 6, 14) I will be missing 8, 10 and 12I'm totally blank, no idea how to do it. Hope that you have another suggestionBest regards Joejoe 

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-12-21

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