generally, you create a linked server.

then your procedure calls the four part name of the object on the other server,

like this:

SELECT ID,ColumnList FROM FinanceServer.FinDatabase.dbo.ProductsSoldTable

SSMS assumes you have sysadmin rights on so many things, my knee jerk reaction is "no, not for right click"

if a developer has VIEW DEFINITION permissions, that's sufficient to use...

for your local SQL instance, I'm sure you are sysadmin of the box;

that means any database you create or restore on that locla isntance will be under your umbrella, so...

don't you have to put singe quotes in there...

your application would handle the CrLf automatically, with zero changes, as long as you are using the right object;

in C#.Net Windows Application,in a windows app, you'd could use System.Windows.Forms.Label,System.Windows.Forms.TextBox...

i don't have an azure virtual, but on a regular box/server, you can extract the key from the registry; i found a decent powershell script that did that for me.

can...

i'm thinking you might be able to do this in SQL, can't you?

what am i overlooking here?

i can get the UTC date, and datediff it agaisnt getdate(0 to get my...

the error is being returned from the mail server, there is nothing wrong with your mail setup.

with rare exceptions, mail servers deny connections or anonymous emails in order to prevent...

i believe you should simply do like windows AD does, and store the hash of the password, and not the password itself.

then you compare the potential new password to ...

UPDATE o SET Order_Number = (SELECT ord_number FROM dbo.orderheader oh

[highlight]WHERE o.mov_number = o.mov_number[/highlight])

FROM #Output o

that...

well, the WHERE statement is still a "catch all" query, but isn't this functionally identical?

WHERE 1 = CASE WHEN @p_flag = 1 OR moveFlag = 26

...

that looks like an accidental cross join to me.

it explicitly says UPDATE DRPDATA, but since the FROM has the table name as being aliased,and the unaliased table is not referenced...

well, if you can show us the code, that would be helpful;

does the current script gracefully handle wierd db names with quotename?

a dynamically created backup command might fail, and move...

first look at the job's code itself;

is it using a cursor to get the list of databases, or is it a static list?

for example, if i use red gate to...

the starting at zero vs starting at one is because the function is adding time elements to generate your matrix of data

SELECT DATEADD( minute, n, DATEADD( YEAR, -2, GETDATE()))

if...