Alan.B (3/30/2016)

---

This is the kind of thing that you can do with a Translate function (which T-SQL does not have). I generally don't like scalar UDFs but this guy is...

Phil Parkin (3/30/2016)

---

Kevlarmpowered (3/30/2016)

---

Thanks... I knew there had to be an easier way. I will check to see if the 8K is installed on that server or not. ...

Thank you Sachin and Jacob. From my initial dev testing, this appears to do the trick. Now we see if the QA team can break it ...

I...

The cleverer peepels here will probably shoot me down on...

The datatypes of your source columns does not match. Find the biggest...

This looks like a simple UNPIVOT requirement

CREATE TABLE #temp (

ID VARCHAR(100)

, ResultA VARCHAR(100)

, ResultB...

You could also pass the filter directly to xp_readerrorlog.

See this post ... http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/

IBeDatMan (3/3/2016)

Thanks for taking a stab at this. I modified your code for my purposes but I get an error: Syntax error, expected something like a name or a...

The following code is a basic template that will get you what you are looking for.

DECLARE @SampleSize INT = 10;

SELECT *

FROM (

SELECT CUSTOMER_ID

...

It's been more than 10 years since I last worked on Access.

That said, the scenario you described was not an unfamiliar one.

The solution was to create a table that held...

MysteryJimbo (2/24/2012)

---

DesNorton (2/24/2012)

---

I run the following in a batch file on the subscriber to try and initialise the subscription:

REM -- Declare the variables.

SET Publisher=PPWAPPSRV01

SET Publication=VHS

SET PublicationDB=HBH_VHS

SET PublisherLogin=sa

SET Publisherpass=*****

SET Subscriber=TESTSQL\VHS

SET SubscriptionDB=VHS...

subscriber is listed correctly in

select subscriber_server from dbo.sysmergesubscriptions

Removed subscription at subscriber then at publisher.

Added at publisher then at subscriber.

Still no info for subscriber listed.

Gonna start following sys.sp_ trail to see what gets done. Maybe error gracefully...

Originally...

exec sp_helpsubscriberinfo comes back empty

select * from...