Analysis Services (SSAS)

Topic

Hi I have created a linked server to AD, when I run a query against a CN it stops at 1000 rows? (running via query analyser). Is this a bug? or am I doing some very wrong... SELECT name FROM OPENQUERY( ADSI, ' SELECT name FROM ''LDAP://163.232.xx.xx/CN=Application Users,DC=ppl2kdv''') I cant see any properties in the […]

2001-11-11

4 reads

T-SQL dilemma

by actinicblue

Database Journal

Topic

I'm looking to write a stored procedure based on a Proxy log file. I have one field called URI. This field contains all of the different websites that have been hit as well as gif images and other items that are logged by an ISA server. I need to filter out anything that is not […]

2001-11-09

1 reads

DDL against replicated tables

by piper5

SQLServerCentral.com

Topic

From time to time I receive scripts from developers that modify tables within a replicated database. I would like to know if it is possible to 'exec sp_droparticle' the table(s) to be modified and then 'exec sp_addarticle' back in after the modification is made. I am attempting to avoid having to drop the entire replication […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-11-08

3 reads

Returning NULL's at the end of a recordset

by dynamic

ASPToday

Topic

I have just stumbled upon a (TSQL language supported) solution that I have been in search of for a LONG time and wanted to share. How many times have you wanted to use ORDER BY ASC on a field that can contain NULL's and did not want the NULL's returned at the top of the […]

2001-11-06

DBA Job Description: What type of DBA are you?

by Brian Knight

ASPToday

Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/dbaroles.asp

2001-11-04

6 reads

Certification Counterpoint - Why You Should NOT Certity

by Andy Warren

SQLServerCentral.com

Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/certificationcounterpointwhyyoushouldnotcertity.asp

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-11-04

3 reads

Linking Dev and Production

by CurtM

Database Journal

Topic

I have some users who have requested that we provide a linked server connection from our development server to our production one. My initial thought was no way. I like to keep production separate and this would be a violation of that rule. But I thought I would throw the question out here for discussion, […]

2001-11-01

5 reads

Another Book Question

by Michael-S-Armentrout

Database Journal

Topic

Anyone who has passed 70-228 or 70-229 care to recommend a book, or books, they used? I have the Transcender product, but would like to augment it with an additional source. Thanks in advance.

2001-11-01

4 reads