ok, using pure string manipulation, can you ASSUME, the value you want is between a tab and the first left parenthesis?

someone will pretty this up with a cross apply, which...

something like this seems to find matches:

;WITH MySampleData([ID],[CompanyName])

AS

(

SELECT '1','All Season Equipment Ltd.' UNION ALL

SELECT '2','All Season Equipment Ltd' UNION ALL

SELECT '3','West End Housing, Inc.' UNION ALL

SELECT '4','West End Housing, Inc'...

When you say "encryption" , do you mean Transparent Data Encryption?

or row level encryption, which requires each protected column to have data type changes, and encryption and decryption routines...

when you copy pieces, it's so easy to overlook something that was required.

there's always one mor ething that got overlooked, and turns into a constant trickle of research.

i lean...

No, that's not right.

To...

log backups are cumulative, and are not affected by differential, so you cannot go from full + diffs + one last log. it's an either log-or-differential process.

full backup, plus any...

exactly how i do it myself.

Also, there's...

I think row_number is they way to go here; then you cna just multiply it by five.

WITH CTE as

(

SELECT row_number() over(order by MyPrimarykey) * 5 as myColumn from table

)

SELECT...

mohanaprabhu.v (6/4/2015)

---

SELECT tblInvoice.*, tblCustomer.FirstName + SPACE(1) +

...

lduvall (6/3/2015)

---

I've reached out to the "wing" of the company that might tell me if they have disabled my predecessor's account & could temporarily re-instate it so that I could...

same thing then, right?

if he is a local admin on the PC in question, he can run the script and take over the SQL instance(s).

if he had 3 instances(ie...

if you can rdp or login directly to the server, then you could stop and start the service in sinlge user mode, regardless of whether you are a sysadmin on...

are you familiar with SSMS's Registered Servers or Central Management servers?

it does exactly what you seem to be asking, and it's built in.

once you add them in a hierarchy, you...

help us help you!

CREATE TABLE and sample data get you help fast!

i put this example together that might help you visualize it.

i got the formula for ounces to grams from...

Joie Andrew (6/3/2015)

---

In SQL Server Management Studio view "Registered Servers". Create a folder for your 10 instances and register each server instance. Once all 10 are added right-click on the...