Talib123 (4/16/2015)

---

Not me 3rd Party. The table is a Heap it is badly designed with far too many columns and serving many different purposes.

They believe it will improve performance....

SQL server does not have easy ways to do anything outside of a database, like files and folders.

sql does not have any native way to play with files and folders.

xp_cmdshell,...

Theo thanks for the script!

i got it to work on a regular basis on most of my servers that have SSAS, but I've got an exception on one SSAS database:...

this worked for me:

/*--results

t Name="DistributionCoderPerHour"><ReportName>Code...lots of XML follows

t Name="DistributionDataEntryPerHour"><ReportName>Da...lots of XML follows

*/

WITH MyCTE

AS

(

select convert(varchar(max),CONVERT(varbinary(max),Content))As StrContent,*

from ReportServer$MSSQLSERVER1.dbo.Catalog

--where name ='CPU - Dynamics UpLoad'

)

SELECT SUBSTRING(StrContent,p1.i + 9,p2.i - p1.i),* FROM MyCTE

CROSS...

// is the default way to add a line of a comment in the C++ / C# /C#.Net language.

most likely they just copied lots of stuff to give toy you,...

as a proof of concept, i searched the xml of the RDL for the tab <subreport, and confirmed that this gets me pretty close to findingf the names of the...

there is no DML in a DDL trigger...but there is a command text.

if you mean command from the DDL trigger that...

I've used the Microsoft.SqlServer.SqlParser.SqlCodeDom.SqlScript object to create a parser that found all the objects in a given query, so that i could format the whitespace to my own rules.

it's a...

could it be a legacy of a normal user who got access to multiple databases, and then someone upgraded them to sysadmin, because they needed more and more access to...

i think it's the secondary file. i've seen this before, and the script it creates names both files the same name, ie you'd expect dbname.mdf and dbname.ndf and dbname.ldf, but...

the two values you posted will convert to datetime2, but not date or datetime; maybe that's it?

--select convert(date,'04/01/200') -- error

select convert(datetime2,'04/01/0200')

--select convert(date,'200-04-01') -- error

select convert(datetime2,'0200-04-01')

people only have access what you grant them, but you have to be careful with granting roles like db_datareader or giving people sysadmin rights.

here's a full example:

Create LOGIN [ClarkKent] WITH...

convert has an optional third parameter for <style>, so when used on a money or smallmoney data type, you can get four digits to teh right with no commas,...

great job with the same data!

here's one way to do it, featuring FOR XML to do the concatenation:

/*--Results

Email(No column name)

Branch101@ACA.comA54, A56, A59

Branch102@ACA.comB49, B54, B10

Branch103@ACA.comC80

*/

SELECT Email

,STUFF(

...

you have to explicitly convert [AccountBalance] to append it to your string:

Select Company + ',' + [AccountNumber] + ',' + CONVERT(varchar,[AccountBalance])

from customer

where accountbalance = 0

order by accountbalance