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,...

there's a logonproperty function that lets you pull things like the last time the password was changed;

with this query, you could find items older than 180 days, and issue a...

maybe something more along the lines of this?

With MyClients(ClientID,UserID)

AS

(

SELECT 111,5656 UNION ALL

SELECT 222,5656 UNION ALL

SELECT 333,5656

)

--INSERT INTO document (documentTitle,actualFileName,clientID,documentDescription,documentCategoryLV,updateKey,savedUserID,savedDateTime,contentType,url,effectiveBeginDate,effectiveEndDate,featureYN,language,imageID,sequence,effectiveShowAsNewDate,javascriptURL,homePageYN,enrollmentYN,bestFitVideoYN,benefitPlanTypeID,eeMarqueeUntilDate,imageName,thumbnailImageName,thumbnailImageID)

SELECT 'Health informational video','',ClientID,'Health Rovion Video',16,1,UserID,GETDATE(),3,'<a href="#this" onclick="try{playThisVideoNow(''20110824181720e66FsHYTkWv'');}catch(e){}">View Video on...