**Ignore this post, was meant for another thread and my session data in two tabs got mixed up**

Things like:

LEFT (RefCode,7)

will return all of the first 7 characters of the string. Is this actually what you want, or are you trying to select the 7th character only?

If...

Yes, obviously they should tell you, but if they're not, bring the situation into your own control and approach it from a security/change control standpoint. There's no reason that Domain...

No, it's not possible.

Yep. The SQL Server Destination can only be used to insert into a local server as it utilises a shared memory connection. It therefore can have a slight performance gain,...

WayneS (3/27/2012)

---

This goes to a listing of directories...

Jeff Moden (3/27/2012)

---

HowardW (3/27/2012)

---

The point of GUIDs is that they're globally unique, so you can have multiple unconnected client/middle tiers that can safely generate an ID without worrying about collision...

Using http://<servername>/Reportserver_<InstanceName>/ should go to the Report Server interface. It's much lighter weight if you don't need users to manage report subscriptions/settings

Is it slow when using both the Report Manager and Report Server interfaces?

Chrome has a known bug that can consume all the client CPU in a loop, but IE and...

There's no global setting, but you just have to add the name of any other servers that you want NTLM pass through for.

That solves...

Lynn Pettis (3/24/2012)

---

I may be wrong, but it appears to me that SQL Server has determined that for these two queries (even though one is a seek and the other...

CASE

WHEN AJADR# = 0 then 'No Address, ID = 0'

when AJADR# > 0 and isnull((Select distinct cast(GAADR# as varchar) from PSGADR where GAADR# = j.AJADR#), 'nm')='nm' then 'Master Address ID:...

Having said that, it's not rocket science to restart services, just use the Net Stop and Net Start commands:

http://technet.microsoft.com/en-us/library/cc736564%28v=ws.10%29.aspx#BKMK_cmd

SQL Server has some of the most stable and reliable services there are, there's likely to be something else funny going on that restarting happens to solve but could be...