i believe it's a design structure built into SQL, where in place updates are never truly performed.

'The design makes sense, because it allows you to reference both old and...

i googled "tsql normsinv" and found quite a few; my second link pointed me, indirectly, to a script and forum post here on ssc for a couple of variations:

http://www.sqlservercentral.com/scripts/Miscellaneous/31632/

http://www.sqlservercentral.com/Forums/Topic158858-21-1.aspx#bm159154

i hav ethis enhanced and revised version bookmarked and saved in my scripts;

it takes the idea of sp_help_revlogins and runs with it, adding role memberships as well:

http://www.tinyint.com/index.php/2009/07/08/sp_help_revlogin-cleaned-up-and-revised-with-roles/

it's part of my...

I've got to say, the amount of spam posts is making the site nearly unusable for me;

I used to be a more prolific poster, but it's just too discouraging to...

depends on what you are referring to;

taken at face value Wikipedia...

declare

@email varchar(200),

@subject varchar(200),

@htmlBody varchar(max)

declare c1 cursor for

--#########################################################################

SELECT

e.Email,

...

well, first, the reports are actually stored as binary in tthe ReportServer database, so there's no direct requriement to extract out the RDLs.....but it can still be done.

to migrate your...

jacksonandrew321 (8/13/2014)

---

I m getting this error, when I sent mail using sql and tested sent mail then saw below error. Tell me the reason.

" 08/12/2014 04:49:27,,Error,15,The mail could not be...

i guess that was my point of the question of the day: the definition may not be what you think it should be.

the "correct" definition as Tom puts it, where...

can you check the underlying tables for triggers? i'm thinking maybe a trigger is raising an error, maybe using dynamic SQL?

the exact, specific error you are getting would tell us volumes on the actual solution.

without that, all we can do is educated guesses.

help us help you!

remember we are not able...

your target table needs to have the same number of columns, ideally, for this simple example

CREATE TABLE BULKACT(SomeColumns VARCHAR (30),MoreColumns varchar(30))

BULK INSERT BULKACT FROM 'c:\Export_o.txt'

...

the data of the index itself cannot be backed up, because it basically is just an organized set of pointers to the actual data records.

now if you mean how do...

yep it's possible, but it's not built in.

using the GUI or via SMO is infinitely easier; I know, because i poured weeks of effort down the TSQL-only method, and it's...

you can explicitly extract both those DLLs from the GAC(Global Assembly Cache), and then make sure they are in your bin folder with the executable you are calling.

in that way,...