Create table #TempA ( Name Varchar(20), Age Int,Hobby Varchar(20),HobbyCode Int)

maybe I'm reading the requirements wrong, but if you want the current distinct combinations that exist in the table, would it...

I thought it's probably 30 million records, and not 30 million users, which I thought was on par witha Google sized-installation....but

just for fun, i searched for Google Searches per day...found...

you'll need to make it a UNC path, like \\ServerName\SharedFolder\Filename.txt or whatever.

you cannot put it on a C:\ drive, it has to be a share since you want other people...

i have this saved, because it is a great resource for determing the minimal impact that a trace incurs:

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/16/performance-impact-of-enabling-page-checksum-and-default-trace.aspx

i created a view to see the data in my DML trace..only thing obvious i saw was to simply do a SELECT * from myDMLView where TextData like '%#%'...

there is no limit to the number of views you can create, even if they reference the same object over and over.

you can create views against system tables, but they...

I'm with Greg,...

this seemed to work for me, but i only had one table with no index:

select distinct object_name(syscolumns.id),

syscolumns.name As CalculatedColumn ,

syscomments.text as TheCalculation,

isnull(object_name(SYSINDEXKEYS.id),'No Index Using This CalculatedColumn') As IndexName

from...

syscolumns has a iscomputed column...the calculation is stored in syscomments if you want to join to get that:

now to get the indexes, that i'm not sure yet....

select object_name(syscolumns.id),

syscolumns.name As CalculatedColumn...

get the script "sp_generate_inserts" from Narayana Vyas Kondreddi at http://vyaskn.tripod.com

he's got a 200 and 2005 versions, and they generate INSERT INTO [YOURTABLE]....statements for you by simply passing it the tablename.

be...

using COLUMNS_UPDATED, you can't, i guess you'd have to write your trigger to do each column individually, if that's what you wanted to do:

IF (UPDATE(DESCRIP) )

BEGIN

[same code example]

END

IF (UPDATE(COLUMN2) )

BEGIN

[same...

the inner join would only show members with records int he detail table...you want a left outer join instead:

SELECT DISTINCT email

FROM Member usr

LEFT OUTER JOIN Selling_Photo pho

...

lleemon13 (5/11/2009)

---

In Restore Files and Filegroups, I can select the 'To database:' but in the Source for restore I selected 'From device' but can't paste the location into the box....

yes you can.

Paul is right..if you take your backup .bak file, you can restore it on any SQL 2005 instance, but behind the scenes it will be upgraded to the...

enterprise? no, that would be illegal. standard and enterprise are all purchases, and often involve thousands of dollars in licensing.

developer edition costs 50 dollars on amazon.com, and allows you to...