Unfortunately its a complex alphanumeric, not an integer sequence

I was a bit reticent to try indexed views because last time I did that I disappeared down a rabbit hole,...

What fixed this was connecting to SqlExpress in Visual Studio, Server Explorer - creating a new data connection.

This re-created the C:\Users\<username>\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory - with default copies of...

Thanks Gail,

For some strange reason in SSMS the dbname was [C:\inetpub\wwwroot\website1\App_Data\ASPNETDB.mdf] I renamed it to ASPNETDB - now the cross database query works.

So I guess I don't have to...

Search always was a bit odd on this site.

Just tried search on "windows surface" - no results -I wasn't surprised but I had expected someone to mention it....

There is no default sort order, so SELECT * FROM Table is not guaranteed to give the same sequence you put the records into the table.

The column you added cannot...

herladygeekedness (9/13/2012)

But what you are saying is that potentially changes in the source servers could cause this in my package? I have to assume that indexing of the hosted...

If you haven't changed the package, then Something must have changed on the SQL Server.

My starting point would be to ask 'TheirRealDBAness' if there are any new indexes, or triggers...

1) Are you running the stored proc in a transaction, as you mentioned you want to be able to rollback. If you do SQL Server will be very slow...

A number of points here.

If your web application runs all its SQL activity in a single transaction, then recycling the worker process should not cause any problems.

However if...

I'm not sure if this is the best way, given you have a fairly small fixed data set, but it's an excuse for a dynamic pivot.

First get all the column...

replace the untouchable 'BA#' first, then do the main replace, then put the 'BA#' back

SELECT REPLACE(REPLACE(REPLACE(@STRING, 'BA#', '***'), 'A#', 'C#'), '***', 'BA#')

L' Eomot Inversé (9/6/2012)

---

Tom Brown (9/6/2012)

---

Anyone from the UK remember BT Phone Day - back in the 1990s sometime, the UK phone company changed all number prefixes to add...

Lynn Pettis (9/6/2012)

---

Tom Brown (9/6/2012)

---

Anyone from the UK remember BT Phone Day - back in the 1990s sometime, the UK phone company changed all number prefixes to add a...

Anyone from the UK remember BT Phone Day - back in the 1990s sometime, the UK phone company changed all number prefixes to add a 1 - so 071 became...

OutGeeked

http://www.sqlservercentral.com/Forums/FindPost1354183.aspx

(Thanks Lynn didn't know they're deprecating my favorite script)